I am fine with using the Autokeys Macro to assisgn vatious bits and bobs to
keys, but no-where can I find a list of which keys you can use. I am actually
interested in using the Home/End and PageUp and PageDown keys but when I try
I keep getting a message saying they can't be ...

We have recently upgraded to Access2003 from Access2000.  I used to have a
button in a form that when clicked would run a macro that did several things
including an action "RunCode" that ran "SubmitUC()"  (see below)  Now when I
run this macro, all other steps work fine, but when ...

I have a form which I'd like to automatically be able to run a macro which
will create an rtf file for each record and save each one to a file based on
2 fields.
I'm able to to do an output to but then I have to save each one, one by one

Wonder if there is a way so that i can do get text files and then do a
transfer text. I tried the transfertext macro but it only looks for the file
name & directory that is already defined. Want to know if i can somehow make
a popup dialog, so that i can select the file and ...

I have a macro that calls a query and outputs the results to a form, the form
is then printed and another query is called to clear out the orignal results.
The macro runs fine, my question is - How do I get the macro to run when a
field is set to 'True' without intervertion from ...

Hi there
I have the following code which sends reports via e-mail to managers listed
in the table.
With rst

I have a system that returns the above error when a query is run.  This query
runs find on another system, and the library references set in the modules is
the same.  The Access version and the operating system is the same.  When I
change the caculation the error goes away.  I ...

I would like to create a macro in witch a report can be saved as a HTML page.
How do I proceed?

I'm completely lost... I don't understand the logic of Access.
What I want to do is update a value in a form when another value i
changed.
What I have now is:

I have 4 combos on a form and the selection on combo1 filters the query used
in Combo2 etc. I had asked in a previous post on here that I would like to
have Combo2 select the first item in it's list after Combo1 has been updated.
Below is what I have been able to do based on ...

I have a macro set up to run daily that appends new records into my dbase
then I have 5 reports set to run and output to rtf file.  This rtf file is
a link on a daily reports web page I have.  I ran into this problem the 2nd
day the macro ran.  After the report runs I get the "file ...

I have a table set up like this:
FirstName - LastName - EmailAddress - TakenClass? (yes/no type)
I have a query that searches for all records where TakenClass? = yes
I am trying to send an email to each person where TakenClass? = yes.

I think my question is simple, and therefore, I assume the answer is simple,
but I haven't been able to find it.  
I did search the groups, and didn't find anything that really applied.
I have a checkbox (downtime).  When I check it, I want two other fields

I would like to to create a Scheduled Task and have it
run a macro in my access database.  The database is at ...
S:\Program Database\Tremont Databases and the macro is
called "Auto Send"

Here's the situation.  I have a form called Companies.  It has a subform
called Contacts subform.  It has a field called Title.  This field is a limit
to list, lookup combo box with the data coming from a table called Titles and
has say 3 records: Manager, Superintendent, Foreman ...