I am trying to use a form to change the query that report is based on.  I
followed the Make your queries interactive by using parameters instructions,
but the module code is returning an Unexpected End function.  I copied the
following code from the instructions:

I have a Form called "Form1" that is created from "Table1" this form contains
project information it also has a UnqiueID (ISSUEID) that is an auto number.
I also have a form called "Form2" which is created from "Table2" this form
will contain more detailed information about the ...

I am repeating the following steps often:
1. From Access, export query to Excel
2. Open existing spreadsheet and go to appropriate worksheet (only 1
worksheet is being updated, other worksheets are maintained by others)

I am using a macro to prompt the user to enter a date and am setting the
entered value to a temporary variable with SetTempVar.  There are two
problems.
1 - I see evidence that the temporary variable is representing the entry as

I have a scenario where I have a macro that is calling another macro based on
whether a certain counter hasn't been reached.  The macro that it is calling
is working as I have put in counter and other items to show me where the
macros as getting to.  The macro is completing.  ...

I have a query that works fine when I increase the odbctimeout value to 600.
I would like to run this same query in code using docmd.runsql however I am
getting run time error 3146.
Is there any easy way for a relative novice to get round this?

2003 up-to-date
How to save current project with current project filename + Current Date + Current Time
? Date() in Immediate Window - Returns date with "/" which cannot be used in a filename.
Therefore, how can I SaveAs a CurrentProject.name + Date + Time in a "new" filename?

I need to write a Macro that only opens a query if today's date is not
already in a particular table.
My table name is "APDOverdues"
The field that the macro condition is based on is "Today"

2003
Using the following VBA Macro in Access:
Function Delete_Tables()
On Error GoTo Delete_Tables_Err

I've developed a spreadsheet with macros in an older version of excel. When
I bring it into a newer version of excel, the macros fall down immediately
with the following error message: Compile error: Can't find project or
library. Is there a way of automatically loading the ...

2003
From an on_click event I am attempting to call a macro that has been converted to VBA.
The macro name is "Open_FBWT_Macro")
The module containing the macro is "VBA Macros"

I found a reference in a book instructing how to attach a macro to a form,
such that if a particular field is null, the record is not saved, the focus
is changed to the field on the form and a message box displays with
instruction to the user.

I would like to delete a record based on a user entered string. Here are the
details. I have a txtFind textbox. A string is entered by the user. Based on
that string value it displays that  one record in the fields in the
frmDeleteComponent form. There is also a lstDelete listBox ...

I have one main form linked with many sub form, my problem if I want to
delete one record, it delete only form the main form table so when you open
another table you will find same record still there in another tables so what
I will do to delete the records from all tables in the ...

Does anyone know how to set a macro to change a record from snapshot to
dynaset? I want to set the macro to a command button on my form to change it
without going into design view.  I know how to apply it once it is set and
have worked with macros, but I cannot figure this one out.