I guess I am getting into this game a little late but just started the articles since they were in the latest daily newsletter. Just read the Part 1 and...

OK, now the code is showing. Thanks.

Where's the code?

After you apply the sort you have to run the form's requery method to get the sort to show:

Me.Requery

I think I later reader that the debugger only works with 2008.

Does anybody know if the debugger in 2008 Management Studio works on SQL 2005? Also can you get 2008 Management Studio without buying the whole SQL 2008 package?

You're welcome!

Sharon have you thought about converting the database to an Access Project (adp). It uses SQL Server as the back end and Access as the front. Your tables and queries...

That sure is a lot of code to pause for a few seconds. How about a For loop.

x=100000

For i = 1 to x

Next x

You could experiment with the value in...

I don't know where you're running the query from, the form Record Source or from one of the controls. If you want the query to update the form you can...

It's been working great for me!

The DBA didn't make it clear what the problem was. I know somebody made some change that messed things up, but he didn't say exactly what it was. I do...

It was something in Master, but they just fixed it. You could run a query on permissions in Query Analyzer and see them, but if you tried to look at...

Enterprise Edition 8.00.2039 SP4 

It's the latest, greatest in the 2000 version. The DBA said he thinks the Master DB may have gotten corrupted.

Thanks Carl and Dick

The DoCmd.OutputTo acOutputStoredProcedure, strProcName, acFormatXLS, FilePath, False worked great. I didn't get a chance to try the RunSQL, but I try to keep all my queries as...