I have two tables( Table_1 and Table_2) and Table_2 has a field that
calculate the max value from one field in Table_1.
I have the macro to calculate the max value, but I could not save this value
in Table_1.

Whilst executing the following from within NOM_FE.mdb that has linked tables
to NOM_BE.mdb, I get error 75 Path/File Access Error.
Name DatabaseName As strBackupFile
where DatabaseName = C:\stuff\NOM_BE.mdb and strBackupFile =

Hello. Using Access 2003. I'd like to create a simple
macro that imports multiple worksheets of identical
format (headers in row 1) from an XL file into the same
Access table. Something like:

I have a few queries in a macro.
Each query has its own little message popping up, such as “You are about to
append, or delete, etc… number of records”, which requires the user to keep
clicking Yes Yes Yes.

I have a query that I would like to export to a html file. any suggestions
Thanks
Diggsy

Using Task Scheduler to Run a Macros Gives An Error Message When Closing.
I created a scheduled task that runs a macro. The task starts fine, Access
is opened, the macro does what its supposed to do, then ends.  But instead of
closing after 1 minute as scheduled by the Task ...

Hi, I use a macro to export files to excel. No problem here, but I'd like to
use file names dependent on variables in the form. One variable is the team's
name "First" another variable is year "2004". My preferred export file name
is then export_First_2004. How can I arrange ...

I have a one line macro to open a more detailed form if you press a button
that runs a macro.  The macro opens the form withe the following in the
where statement...
[ID]=[Forms]![Pay history]![ID]

I need to write a macro that can copy the information in a cell (This cell
information is unique) and then open the window to create a hyperlink.  Find
the address for the first part of the link, paste the copied cell information
and then close.  I have tryed writing a few macros ...

I use a macro with an 'Output To' statement that exports my reports as RTF
files witha name I've hard coded in.
Is there a way that I can generate the current date into that name so the
files are their hardcoded name+the current date ?

I'm trying to find out if I the macros to send object via email will work
with other email programs besides Outlook or Outlook express.  Can anyone let
me know?
Thanks.

I've got a problem and am not sure which newsgroup to post to.  Please feel
free to re-post this in a more appropriate newsgroup, if necessary (but
please let me know if it's being moved).
I designed an Access '97 database containing some macros which are called by

I have an application originally developed under Access 97 and converted to
Access 2000.  It runs fine under Access 2000.  When someone with Access 2003
tries running it, however, the SetValue action results in a message "You
entered an expression that has an invalid reference to ...

In my Macro to export Access data to Excel, I am getting the pop-up message
that my xxx file already exists, do you want to overwrite it. I saw in
another post on this newsgroup, that someone suggested using the "SendKeys".
I tried to add that in and hit the left arrow and enter ...

I have a macro with a SendObject action.  I am using
exchange 5.5/outlook 2000 for email.  Is there a way to
change the sender of the email?  by default it is my email
because the action is running on my machine.  any