Can anybody recommend a nice way to get to the contents of
a macro via VBA? I need to find where functions or objects
are being used by macro commands (e.g. RunCode). I've
considered using "DoMenuItem" & "Convert Macros To Visual

I'm a complete novice, but I'm trying to use SQL in a
macro, to send an email from Access.  The SQL statement I
use works fine in a query, but doesn't in my code. The
SQL statement, as far as I know, looks in the TEmployees

In Access 2000, I have been using an autoexec macro to
bring up a Form, it's been working great.
But in Access 97, I have been trying to do the same thing
but I always get a error message saying I can't use auto

I have a macro set up to import a file, but I have the
file name hard coded. Is there a way to have a dialogue
box pop up so I may select the file?
Thanks in advanced for your time.

does anybody know how i can assign variables to items in
a column in a table using arrays?
Can somebody help?
Regards,

Here's a tuff one (for me anyway).
Every month i have to print only 10 reports from 6
databases and i spend a lot of time doing it. I wonder if
i copy all data to another database (new) and those qry

I would like to open and run a merge from within a form
using the contact details entered within the current
record (create just a single letter)
I guess i have to run a macro - but i am not sure what to

I need to set a fields required property to true if
another fields value is true, else I need the fields
required property to remain false.  Does anyone know how
to do this?

When trying to run 2 macros that are part of a database,
I get the following error message:
"The expression you entered has a function name that
Microsoft Access can't find"

Can someone point me to an example of a calendar control being used?  I'm
trying to make a timecard, of sorts.  I tried the MiniCalendar3 at
wolfwares.com, but it wouldn't open on my computer.
Win XP Pro

I am looking for the format to use the setvalue to add
minutes to a short time format field.
Many thanks,
Rob

The code below is a sample of code that I use to try and set the values
for two drop down lists.
The table that it points to is a linked FoxPro database.  I think that
the table has some form of indexing that I cannot see in the records

I need to create a fixed length file that will be created
nightly.  Not sure where to start.

We have been using Access97 based database in a clinical laboratory for
last three years. I would like to start specimen number as 04-00001 for
the year 2004 in the existing specimen table, which as number
03-XXXXX.

Recently bought new computer w/ Access 2003
Have Access 2000 file that runs report from criteria specified by a form.  Was created using Access Help instructions "Create a form to enter report criteria".  When trying to run report from file in Access 2003 I get the following error ...