My form enters work order data into a Work Order table. This data includes
delivery information that must be entered into a Delivery table.
A command button on the data entry form sets the required delivery data into
the Delivery table using a SetValue macro. The macro works ...

After upgrading to Access 2003, macros using the Sendkeys Action do not work
properly. There is a error message: "The sendkeys Action requires the
Microsoft Office Access Utility Add-in to be loaded. Rerun the MS Office
Access or MS Office setup to reinstall MS Office Access and ...

Previously I am using combo box to select which data I need to print out the
report such as Customer Record with Status of Active and Blocked. I created a
Macro's that will open a report that Customer Record only with Active status
when I select Active.

he hi,
In the macro command to do GotoRecord ,,last .  It works , the query
'qryDATA', to put the macro on the Form On open . Yes , when open the form of
bound textbox the 'qryDATA' will autorun the code the record move to the last

Is there a way to have a Macro run every night, or at a specific time,
without the aid of my IT department? The process finishes with an export to
Excel and this must be accomplished as well during this pre-established kick
off.

Thanks for the help ! I am using Access XP. I have a table in Access that I
need to export to Excel. I'm trying to use the Transfer Database macro
command but I can't seem to get the syntax correct for the Excel spreadsheet.
Here's what I put:  C:\Documents and ...

I have two macros for two unbound text boxes on a form.
Each macro applies various filters depending on what is entered in its
particular text box - the macros are set to run "on exit" from the text box.
Say I enter "EM" in text box 1, this will filter for all schools in the East

I'm using Access XP. I need to transfer a table from Access to Excel. I
thought the TransferDatabase action would be the approriate way to accomplish
this. I keep getting this error message when I run the macro: "The object
name 'C:\...xls' you entered doesn't follow Microsoft ...

Tools->Macros->Security is not on my machine, but on my co-workers machine,
where Access 2003 was installed at the same exact time.  I want to get rid
of that annoying secuirty message when opening all my databases.
Thanks.

Just starting to use macros in Access and trying to figure out a way to
import .dbf files using but not successfull. Any suggestions?

A microchip could be used for the CD by puting a round chip in the middle to
gain info for games (More-RAM),Video,music,(ext)Please tell me what you think
and E-mail me at michaelwoolls@yahoo.com My (ADD)1114 N.Howard ST Alexandria
VA.Zip 22314 Home phone is (703)370-4635.Thank ...

I have a combo box which has a number of years in it (i.e. 2000, 2001, 2002
up to 2015). Whenever I select any one of them, I want the year selected to
be included in a msg that comes up in a macro. Example, "You have selected
2002".

like to turn off ALT{F11}} key combo. don't know the key symbol for ALT. the
rest i have no problem with.
any help would be greatly appreciated.
thanks!

I am trying to create a conditional statement inside a macro so that a form
is only opened if this condition is met. However, even though my expression
is correct in expression builder I am told later when I run the application
that I am using a function that Access does not ...

Hi
I have created a form with a subform.  I would like to not be able to go to
the next record in the form unless there have been entries made in the
subform.  The field name inside the subform is called "Date Incurred".  The