I have a database with several related tables.  The main
table has one entry for each property and there are four
related tables that have unlimited records for each
property, for example a list of structures on the

I actually have 2 questions in regards to this.
1) Is it possible to send only part of a query in an
email. For example, I have a list of vendors and parts we
want to purchase from them. I have an email field for each

Is it possible to have one macro execute more than one
report?  I have had to split a report in two because it
was too large and I would continuously get errors on
preview "cannot open any more databases".  One report has

I am trying to open an excel file from runapp action of an access macro. the only success i have had is using the argument: "C:\Program Files\Microsoft Office\Office10\EXCEL.EXE" /e which opens the program but not the intended excel file. when i enter the path and file name i get ...

Help.  Is it possible to use the DLookup in the To:
portion of Send Object in a macro?  If so can you show me
the syntax.  Thank you.
Don Rountree

Having a problem with macro when trying to import text data. Error Message ' The Microsoft Jet database engine could not find the object ' races.txt' make sure the object exsists and that you spell its name and the path name correctly.' Thats strange because it works perfectly ...

On my form I have the following fields
cboReference (containg the name of a file without extension)
txtPath (containing the full path to the document)
txtFileType (containing the type of file; Word, Access, Excel, PowerPoint)

I don't know how to setup macros, is there a easy program out there
particular (free) that I could use to build macros. I've got Mozilla as my
web-browser and it has options to perform macros but nothing tells you how
to build them. I would appreciate any input on this matter.

how can i bypass the yes or no option during generating a table.
sendkey?
Thanks a lot.

Hello to everyone on the board - I'm new!
I'm having a bit of a problem with Access 2000 and hope somebody can
provide an answer. I'm trying to configure a macro that when I click a
button in my form will copy today's date into a field called 'Out'.

Been learning VB.Net.
Started taking this because I wanted to learn the VBA Macro language.
Knowing .Net isn't really as helpful in programing VBA as I had hoped it
would be.

RE: Access 97
I get an Automation Error anytime I try to use an object
in code. I've "Repaired" the database via
the "Tools|Database Utilities|Repair Database" option, but

After upgrading there is a spreadsheet that won't open.  
After clicking the "enable macros" button that appears
when it opens, the next message is "unable to open
template wizard."  I haven't found any answers for this

Can anyone help me with this problem.
I have a database which connects to an Oracle db through
an ODBC connection.
The user runs a macro which does a variety of things

I have a macro that runs queries and then outputs them to
a network drive using the transfer spreadsheet action. The
macro fails and gives me an error "Failure creating file"
I can right click on the query and export it to the drive