Hey guys,
I'm trying to setup a macro that will call a mail merge
document and then assign the time to a field on a bunch
of records. I have the first part done but I'm having

Hi, I have a report that is run from different queries.  
On my Form, I want to put a check box, which by checking
it, it will cause one of the queries of the report to
EXEMPT records that have a certain field...so it won't

I've got a macro that uses seven access reports to update seven
spreadsheets. However, I have to use the keyboard to overcome the message
"myfilename.xls already exists. Do you want to overwrite the existing
file." - seven times :(

I have a form and a report that are pretty much identical.  I want to create a cmd button to print the current record that is visible on the form.  I am missing a piece and can't figure it out.

I have two forms I'm working with (both posting data to the same table). What I need is to be able to click a button on the first form and have it open the second form to the same record number as the first.
I can get the second form to open, but it jumps to either a new record or ...

I am making a macro to take things from 4 different tables
and I want them to pull all of the same dates. In the
queries I have conditions and those work, the only problem
is when someone runs the macro you have to type the date

May I know is there a way to pass parameter into MS Access
macro?  Thanks

I have a macro which includes a send object action.  Also
have a form which the user enters a value into.  I want
to somehow embed that entered data into either the
Subject line or the Message Text of the e-mail message.

Does anyone have a Macro to enable the insertion of an OLE
object into a form, specifically a picture. Access allows
you to insert pictures, but the process is serveal stages.
I am looking for a program that asks where to look, and

I would say I'm an advanced beginner. . .
I have a database of employees.  I want only the employee
to be able to update their record.  So in the Employee
database I have their ES No (7 digit text) and Password

I saw this once before here, but stupid me I didn't think
to write it down. I should have known I would need this
sooner or later.
I am looking for an inactivity timer. If a user does not

I would like to create a macro that asks user for password before opening another form upon a click of a command button. Is this possible with a macro?
Or maybe some VBA code that asks for password and opens the form with correct password entered? Thanks for any help!
Regards,
Sam

I've got a series of reports - lets call them "Report 1" and "Report 2" that
I'd like to automate in terms of producing excel spreadsheets of the same
report name.
I can do it manually and individually via the 'Analyze It' command in the

How do I send mulitple queries in one SendObject command.
I have built a macro by using the SendObject action. But
I'm limited to only one output spreadsheet. I would like
it to attach two spreadsheets. I tried to use two

I use the sendobject command to e-mail a report from the
database. Of the various formats, only snapshot gives me a
tru representation of the report. In HTML, RTF format, a
subform that appears on the report is missing!