Using A2003
I was wondering if it is possible to assign a combination keystroke to
launch a function?
The function is listed in my macro list as I was going to launch it via a

I am using the following VB code to create a temp query.
       ' get cycleID from cycle Table
       Set qdfC = dbs.CreateQueryDef("", _
               "Select ID From Cycle where Cycle_Yr_Month = " & YrMon & _

I need two counts on a MSAccess FORM (please don't talk about Excel or
Reports).
Fields on the table are PatientID, Admit Date, Visit Date, Visits, TotVisits
1) count number of visit dates by the Admit Date for a PatientID, so that

I would like to run a report in Access and then copy the results into the
body of a new Outlook email message.  Can any of you guru's suggest a
solution? Thanks in advance

I'm trying to run a batch file from within Access.  I can't find the proper
command to run to accomplish this task.  Can anyone help me?

I'm trying to send an email but need the result of the query/table to be
contained in the message body of the email.  
For example, the table is called 'Request' and the field I'd want sent is
'Data'....is there a way to do this ?

Automation has worked for over a year but stopped working after a recent
security patch. Users log onto an Access 97 database over a terminal
server, select a record to merge, and Word 2002 and the document open
via code in Access.  The data source in .rtf format. The Access 97 ...

I am currently trying to send a report via access and email every hour. At
the moment I have set up a macro to send the report and this works find
however it comes up with a dialoge box to say that "A program is sending an
email, if you havn't requested this say no etc etc." The ...

How do you run a VB module from a macro in Access 97?  The only option I see
in the the macro is to open a module.
Thanks,
Nick

I know you can run a macro depending on whether a condition is met in a form
or not....but how about a table or query ?
I send out reports to a huge group of people on a monthly basis.  Sometimes
their reports contain no data and shouldn't be sent...is there a way to not

I have several boxes inside a form (two combos, one tex box and 2 option
groups). Now I want to have this feature in "reset" button such that if i
press it, anything written inside any box will be dissappear/any option in
option groups will dissapear too.

I'm trying to build a macro to export a fixed width text file from data in a
table. I selected "Transfer Text" as the action then I selected the type as
"Export Fixed Width". I then selected the saved specification for the file
format. When I run the macro I get an error message ...

Problem:
I am creating a form to collect data on transfusions.
Each unit of blood is a separete  entry into the data base.
Some Individuals receive multiple units of blood.

People using my application (forms, reports) tend to stay in it overnight or
over the weekend, making revision changes difficult.
I would like to have my access application close automatically if the
application was not used within a period of time (30 minutes).

I have a form that lists all rooms for a specific customer.  For each room
there is 5 checkboxes (Stage 1,2,3,4,5).  The checkboxes are checked in order
of 1,2,3,4,5 as each stage is completed.  After the checkboxes are checked
the user clicks on a command button that takes them ...