I have created a form (called ADD RECORD) that will be used for doing 2
things when a command button is pressed. The fields on the form are:
Job Title, Schedule, Shift, Start Week, End Week, Head Count#, ST, OT and DT
The two things the command button will do are:

Hi:  I have a Macro which Exports a table to my C: drive.  For the File Name
I have a specific name, but is there a way to automatically update that name
to something different with a promt or other feature every time I Export the
file?  Instead having to go to FileName in the ...

Hello all,  I have an interesting error.    My problemis similar to the one
asked in "TransferSpreadsheet trouble" by slmndr.  (Type "TransferSpreadsheet
trouble slmndr" into the search box and press "Go" to see it.) When I type in
the "range" box " (this is a macro) ...

I am using A97 under windows 2K across a peer-to-peer network of 4 PC plus a
fileserver running windows 2k server. We use Outlook Express for emailing.
Each PC has its own (identical) frontend, with linked tables that are on a
db on the fileserver.

I'll start posting here because I'm not sure if this will take a macro or a
VBA module.
I have a form that opens reports based on criteria from the form and the
report depends on which radio option you choose.  However, the same report

I need a macro that will run at 12:00am on the first of every year.  I have
tried using the date and time as a condition in my macro, but it doesn't run.
My users will not be able to go in and change the year to the next year,
either.  To add to that, the database may not be ...

I have a form that when OK is click this runs a macro that opens a report
that has 10 subreports in it.  Once the report is open the form stays open on
top of the report.  I need to close this form once the report has been
completely opened.  The information gathered in the form ...

Help.  Don't know what to do.

I am trying to copy a table in access using a macro. I'm using CopyObject
I want to copy the table into the same database but with different names
every time.

I want to display an Access query on a big screen and have it automatically
update the query every 5-10 minutes.  

I need to create something in a form that will allow me to set a field in a
record to point to an Excel file that is outside of the Access database.  I
have a table that has the summary points of a excel file, but I would like to
like that summary to the detailed document.  I am ...

I have a simple macro that takes the report currently being viewed and
exports it to a rtf file and opens Word so I can make notes on it before
printing the report.
Currently I am going through Tools - Run Macro and it works well. However, I

I have a RunApp macro to open a word document as a mail merge (example
"c:\program files\microsoft office\office10\winword.exe"  "c:\my
documents\test1.doc"). The problem I'm having is that people are running the
database at various locations, office, laptop, home or flash drive. ...

I am trying to create a macro or VB code which refers to the current field
which is selected.  Because I am trying to create a macro which will be able
to be used for different fields.  So if I have Field1 and Field2 and I am
trying to SetValue after the field has been updated.  ...

I have a report that has 1/2 inch margins on all four sides.  Every so often,
it goes back to 1 inch margins and prints on 4 pages instead of 1.  
Is there a way that I can reinforce the set margin command at each printing,
maybe by resetting the margins to 1/2 inch as part of a ...