I have a table that I input an effective date. Is it possible to run a macro
on based on that effective date? There are 2 TransferText files that I want
to send to another group.

I have a table named "Zipcodes" with two fields: City and Zip
On my main form, I have a control named "City" with a drop down list box
that derives its contents from the "City" field of the "Zipcodes Table".
After I select the City from the dropdown list, I would like Access to

I've gotten some really great help here before and I'm hoping I'll be
able to get some again because I'm at wits end. I'm trying to get a
script to do text to rows. The following is how my spread sheet
looks...a few hundred rows of cells with data points separated by

I'm trying to write a Macro to export a table to Excel. I want to name the
file so it has the current date in the file name (date the file is created or
Macro is ran) i.e. "AccessReportFile 20061026.xls".
I can't find this anywhere in Access or Excel help menu.

I am after creating a macro that will copy a table structure and paste a copy
into the same database but then ask the user to Name the Copy which has just
been created.
Is there a way i can do this in VBA?

Hi everyone!  Using A02 on XP.  I have a validation macro that checks for
rules and then will preview the report if the macro doesn't stop for a rule
violation.  However, I need to preview the report for just the record showing
on my form.  

I hv created two form and want after closing 1st form by user then second
form should display and it should remain on the screen for few seconds. Hw i
can do this in Microsoft Acess

I'm trying to link an Excel spreadsheet to the database I'm working on
(access 97).
There are 12 worksheets in the Excel workbook and I wish to reference a
sheet called Committed & Invoices, which is sheet12.

I think I figured out what I need to do to solve my problem, but I'm not sure
how to go about coding it.
I'm making a list of test numbers, and a seperate database with the same
test number as the primary key. The second database containts cost to patient

I have converted an application from Access 97 to Access 2003, and used the
Package & deployment wizard to create the setup. I included the Access
runtime in the setup wizard settings.
When i installed this converted application in a system where there is no

Inorder to control deletion of mails from a shared mail box, we want to put
in place a control wherein I have a count of mails received on a particular
day.

How to get the database window to be maximised when you open an Access file

I have made a new macro named AutoKeys and entered ^d for the macro name,
action is SendKeys (keystrokes ^d and no for wait), Date() for comments. Two
lines under I made a RunMacro action with macro name of AutoKeys.^d in action
arguments area.  When I attempt to do Control D in ...

I am having trouble with my paths working.  They use to work but we changed
the computer server around and now the paths will not connect to the word
documents.

I have been trying to create a macro that will open a report based on whether
the client name is valid AND whether they are currently residing at the
stated address in the data based (checkbox yes/no).
A client may have many addresses but only one active one and that's the