Group:
I would like to add the capablilty to my application to export a form's
underlying query to an Excel spreadsheet while the form and query are open.
Is this possible? If so, what would the VBA statement be to accomplish this?

My database grows very big. How could i enter a code that compresses the
database on exit ? Is it possible to revert to the original zize of the file ?

My database grows very big. How could i enter a code that compresses the
database on exit ? Is it possible to revert to the original zize of the file ?

I can not split the database with the following errorrmessage windows:
The database engine could not lock table "Switchboard Items" because it is
already in use by another persons or process
I appreciate your help

I need a way to get some data from an Oracle table into an Access table.
(I looked at linking the table, but it seemed to take a long time that way).
I've used ADO to put data into an Excel Pivot Cached, so I know the various
database connection strings, etc. from that.

I am looking for a method to print a report to pdf using acrobat 6.0 all in
vba without user interaction.  Basically switch to the pdf printer, print,
switch back to the default printer.
I have looked long and hard on google and found nothing that is seemless

Good afternoon,  Using code snippets I have found, I have managed to create a
nice filter on a form.  I am now trying to export the results of the query to
a csv file.  The code below works fine except, I don't know how to write the
manual header to the csv file.

I need my program to send a double push of the Scroll lock button to the PC.
Is there a way to send this command, and if so, what function do I use?
Thanks for any guidance on where to start.
Mark

Hi, using code found on-line I'm trying to print a word document in a report.
I get a run time error #424 saying "object required".  My document prints
well though. What I would like to do is instead of hard coding the location
as in C:\Wordtest.doc, can the file location be ...

I have a mostly unbound application and would like to use temporary local
tables for subform data to allow for edits. It's easy enough to load those
tables.
Does anyone have a suggestion or article as to how to save that data back to

I've encountered a problem with a shell command not liking filepaths with
spaces.  For example, Shell("c:\My Special Folder\Do This.bat") fails, but
Shell("c:\MySpecialFolder\DoThis.bat") works.  Anybody know a solution that
will make the names with spaces acceptable to the Shell ...

I'm trying to use the 'Application.DoCmd.Outputto acDataTable "Table1", etc.
I have no problem doing it as shown above, but when I try to substitute a
variable for "Table1", I'm not able to do it.  
So my question is, how can I save a reference to a table as an object

If I run a query from the query grid using ODBC it works. If I run it from
VBA it fails with and ODBC run time error 3157.
This is my code
  Dim stDocName As String

I have some code that copies a set of files from one place to another
and renames them, which is great.
Unfortunately, the string for the destination path/file name seems to
have a maximum of 46 characters.  The code captures the full path, but

Basically, I'm trying to do what it says in the subject.  I have a
table (tblReportsMe) with three fields:
woindex (unique)
wofile (current path to a specific file, eg. c:\00916678423 ... file