I have a problem. I use the following code to transfer a query to an excel
sheet.
Private Sub Command9_Click()
DoCmd.OutputTo acOutputQuery, "6_FORECAST_TO_VENDOR", acFormatXLS,

I am trying to get an access form to initiate a .cmd script and pass two
arguments to it. The contents of the script files are shown below:
initdb2.cmd
-------------------------

Access03/WinXP
This should be fairly straightforward, so not sure what I am missing.  
Looking at the help example for .CreateField (from the Northwind DB), I am
following the same format:

Form A is bound to Table A
Form B is bound to Table B
I have a button on Form A whose Click event opens Form B and gives Form B
focus. Form B has a Cancel button that is supposed to prevent the new record

Access03/WinXp
I was wondering if it is possible to define a recordset of a specific set of
tables in a database, rather than all tables in the database collection.
I have a procedure that runs through all tables and if the table name begins

I need some help with several problems --
1. When i'm importing records through a query, using an append table, its
telling me its found several errors in all the records, because of a
validation rule.  Tehre are no validation rules set, and ther are no

I have a report that displays records of a list of prodcuts. I also have a
table of special codes that I need to link to a text box in this report such
that it will display the special codes in order and then recycle to the
beginning, continuing until all the records in the ...

Is there a way to execute a string as a VBA statement?
For example something like:
Execute "Msgbox"
I am looking for a means to assemble and execute a VBA statement as a string

I keep getting an error at the rsResults.open line of this code:Run-
time error '-2147467259 (80004005)' ODBC--call failed. From what I've
researched it's fairly common, but no single solution. I get different
messages changing the sql string around, so I was hoping it might be

Hi Access programming gurus,
I have written a public function in the VBE and am trying to use it in a
query I'm creating.
I have been getting my SQL statements by first building a query in the

Hi all, not too good at this but i am using the following statement to use
the last record :
strSql = "SELECT * FROM tbl_CIANumberRequest ORDER BY dtAdded DESC"
   Set dbs = CurrentDb

Running Access 2007 with SharePoint MOSS 2007
Here is a message from a biz friend that has created an invoicing system
using Access 2007 on the local PC, and SharePoint 2007 on the remote server
for file storage.

i'm hoping someone can help me with this problem.
I am compacting my access '03 database and its creating the db1 copy but the
copy is not being deleted and my original database is not being compacted.
the original reopens without any error messages but i can see the size has

I'd like to put a button on a form to export a specific table (view) to
Excel. I've checked the sites I know (Access Web, etc) for that code and
didn't find what I needed. Does somebody have a link to vba code that does
that? Thanks so much.

There are two things I want to be able to do with my access database. The
database is called books and it has two tables: Books and students.
1) I want to be able to link to the books table and have a page read the
information about it. Such as, the page will read the books and ...