When opening my database, I have created a form for the user to enter their
password.  Once this password is entered, I want the user directed to a
certain section of the switchboard.  I have used [Switchboard
Items]![SwitchboardID]=5 And [Switchboard Items]![ItemNumber]=0 in the ...

I have a form entitled "Purchase Requisitions" and a subform entitled "PR
Details."  I have a button on the subform that is called "open job," and
initiates a macro that opens a new form called "Existing Job."  I want the
macro to set the value of the "Job ID" field on the new ...

I have a macro in Access that performs several steps that is run in an
unattended mode (from the command line via a scripting language).
What I'd like to do is have the macro record to a text file where in
the process it is in order to track down where a problem occurs.  For

Can I edit an excel file from an Access Module. I only need to update one
cell from No to Yes.
Thank you for your help,
Diana

I would like to create some sort of script/macro to automate the ouptut of 5
reports into 1 XLS (Spreadsheet), with each individual report as their own
Worksheet. I know how to perform this task if I were just working with 1
report and 1 spreadsheet, I'm just not sure how to handle ...

The following MsgBox  in a macro generates a Yes No condition
MsgBox("Question",36)=7
Can someone tell me what the "36" and "7" do?

I'm trying to output a query to outlook express for e-mailing.  I need the
ability to name the excel file at will prior to e-mail.  I've been trying,
by creating an unbound form with a textbox to enter the file name, then
clicking on a button to run a macro. With the intention of ...

I was talking to my friend about creating a Log in
function built from forms and macro's using the Autoexec
command.
I dont know how to do that? Has anyone have any ideas or

Is there a way to create a login and password using a
macro for multiple users?

I am trying to use the "transferspreadsheet" action through the use of a
macro in order to import multiple excel spreadsheets.  Each week a new excel
spreadsheet will be created with the file name in the format
"weekof_mm_dd_yy.xls", and i would like to tell access to read in ...

Have just finished my first Access application.  Thanks again to all who
helped along the way.  
I need the user to import a table into Access and then run the module I've
written.

I would like to start access (MS Access 2000) in a forms view based on the
CurrentUsers permission level.  For example.  A user defined as a Manager
would get the Manager's Main menu and Staff members would open to the Staff's
main menu.  I've tried setting up an autoexec macro ...

I have several tables linked to Access from my company's mainframe.  I wanted
to be able to copy those linked tables and paste with new names, so I
wouldn't need to change my queries when switching among different tables.  In
Access 2002, I used a "CopyObject" macro to copy those ...

I am trying to use the above function in a Macro.  
Basically I want the Macro to open up another Access
Database, but my Command Line code is not working.  At the
minute, I am doing the following in the command line:

I want to create a sleep function which lets me run a routine, stops it for
the amount of time I specify, then continue on.
I have tried a couple of different methods without success. Thanks.