In Access you can hide objects like forms.  So, if your users are trying to open the form from the "Forms" section and can't see it, have them go to...

You don't have to worry about date "format".  A date is not really stored the way it looks to the user anyway.  The main problem you will have as far...

I work for a smart company, Bryan Cave LLP.  I think Bryan Cave is smart because of the culture and how it welcomes diversity.  People are respected for their work and...

Use the datediff function. 

select datediff(d,dateStart,dateEnd)

You can give a Windows authentication login access to the SQL Server through a group.  So, let's say you have a Windows group called App_Users.  You add the Windows accounts...

Try this for SQL Server 2000:

select name, case when isntgroup = 1 then 'Group' when isntuser = 1 then 'Windows Auth' when isntname = 0 then 'SQL Login' end as...

I vote for Steve's solution.  You should not use a cursor for this.

Take a look at this thread to see some possible causes and solutions:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=209497

There is not a function to do it.  A loop that adds one day at a time to the start date is an easy way to do it.

Even some simple things in presentations like not using SA would help. That is easy to avoid and doesn't complicate the demo.

Maybe I am stating the obvious here, but what does the @v_query do?  Is it modifying the table structure of the tables that are part of the cursor?  

Steve, I'm confused on how you loaded the data into SQL Server in the first place using DTS.  How did it know that the three lines were supposed to be...

It is easy to get the report definition out.  Just go to the Report Services web page and navigate to the report you need.  Switch to the properties tab and...

My daughter, a chemist, is so good with the software she uses at work that I keep telling her she is going to get recruited by their IT dept.  I...

Just for the record, I consider myself a geek and am proud of it.  Who really knows what leads someone to be a programmer or a DBA or a pet...