Is it at all possible to key a field in a macro?  Specifically, I want to key
the first three fields a table as a step in my macro.
Also, is it possible to change the "Field Size" of a text field using a macro?
Thanks.

I have Access2002sp3 on WinXP. I have a database where I regularly want to
export a table of data to excel. The table concerned varies, and I have
always written a new macro for each table, even though the sequence (or
code) is the same as the last, just a different table name. ...

I do not have any background in creating VBA code and very basic knowledge of
macros in Access so please bear with me.
First let me give a brief description of my problem.
I am pulling data from my business software database, I have the tables set

I use the following code in Access to open an instance of Excel to do some
worksheet operations and close Excel at the end:
Dim appXL As Excel.Application
Set appXL = CreateObject("excel.application")

I should be able to figure this one out, but it's late:
I'm trying to sort a report by two fields. I can do it easily if I
hard-code the fields. However, I want to get user input and store the
input in variables, which would then be used in the OrderBy method.

I'm sort of a novice macro developer but I really need help from someone
concerning reversing a name.  I have a long list of names in one field that
are in last, first middle initial (sometimes without the middle initial and
sometimes the whole middle name) order and I need it ...

Do macro's run in succession or do they run concurrently?
If they run concurrently, how can I set them up so that the steps will run
one after the other.  
Reason is my queries create tables which are dependent on each other.

i'm a teacher and have created a reporting database.  for my database
to work i have an reports table that looks like this that has the
following fields.
Admin No  : unique pupil number

I have got a database which has a mian page which then can open up three
forms which have been done with command buttons. Everytime i go into the
database my main form is not big enough i always have to maximize it. Is
there anyway that i could run a macro in the back ground so ...

I have been running a SendObject command within MS Access XP (2002) for a
year or so now with no problems.
I have just recently updated MS Office to the 2003 version and since then
the macro has not worked correctly.

I have a report that is grouped by Department Heads. When printed, each
section begins on a new page that is then snail-mailed to the relevant Head.
I have a field attached to the Department Head with their email addresses. I
want to be able to email the report, using the emails ...

I'm using Access 2002. I converted a macro to a module because I need each
step to execute separately - and then I added a RunCode macro to execute the
module. The problem I'm having is when I execute the macro (with a command
button on a form) I get the error "The object doesn't ...

I'm trying to set the value of a field in a form to a number I'm looking up
in a table where it's between certain dates on the form.
Here's the expression in my macro (set value action, to set the value of the
Fuel textbox on my form):

When I insert a new record in a subform and then move off the sub-form, the
AfterInsert and AfterUpdate events/macros are both running, one after the
other.
Is there anyway of preventing the Afterupdate event/macro from running as

I have tried the insert hyperlink and get an error message:  "Unable to open
"emailed address". Cannot open the specified file.
the help file says:  To test the link in a form or report, right-click the
label, point to Hyperlink on the shortcut menu, and then click Open.