I am using Docmd.OutputTo to export a stored procedure (SQL Server) to Excel.
Only 10,000 records are getting exported.  Is there a record limit on how
many rows I can export to Excel?  I have read that this limit is 16,384 rows.
Is this limit different using SQL Server?

Is is possible to know which was the last opened form or report ??
Thank you
Javier

I'm getting tremendous bloat of my backend when I delete all records from
tables on the backend.  My VBA is in DAO 3.6  I'm closing all my recordsets
explicitly.  I'm thinking one way to eliminate is to delete the tables on the
backend and recreate them, however I cannot delete ...

I have a bug that is driving me crazy. When Access 2K is running at "full
speed," you get a run time error that is "down stream" somewhere from where
the problem is, and when you open up the debug window the message is
essentially meaningless.

I have built an application that has been deployed to customers via the
Package Wizard of MS Access Developer Extension. The database is an .mde
format at it uses a customized .mdw.
From time to time customers ask for some new features and I need to delivery

Is it possible to export a selected record 'from a form' to 'an external
folder' in 'report format' so when we print it out,it has the same
appearance.

How do you write code to set up an undetermined number out outer loops
or to properly write a sub to call itself and exit properly?
With known values stored in arrays I am able to manually code the
number for next loops to fill a string that is passed to a sub to xor

Can you provide code to print a list of controls in a specified table or
form? (Debug.Print)

From Access I can easily open a WEB page with:
Application.FollowHyperlink (strUrl)
But,.......... How Can I close the WEB page from Access (with code) ??
Thank you !

I'm trying to give my users an option for not in list in a data access page
drop down list.  I have given them a link to a different window where they
can add new products.  The problem is when they return to the initial window
the drop down list isn't updated to include their ...

Here's one for the uber-gurus.
I need to import multiple worksheets from the same workbook into 1 table.
(The data comprise more than 65,536 records, so they are split over several
worksheets.) I can do it this way, but it's a bit clumsy:

Other than the inevitability of Microsoft not supporting Access 2000 forever,
is there any compelling reasons to update a smooth running database written
in Access 2K?

I want to open a form of the current database in design vew from the library
database (code database). I can open the currentdb.form in design view, if
the library database is in .mda version. But if the library database is an
executable .mde, I cannot open the form of the ...

When I try to run the following
DoCmd.RunSQL "Select tblTest.* From tblTest"
I get an error 2342 A RunSQL Action requires an argument consistent with an
SQL statement. What am I missing

OK, he're's the dilemma.
I have two lists of files I've imported.  One has the file names/paths in
long format that contains the path, name, size, last accessed, etc.
The other list has them in DOS format wiht name, path size, last accessed