In my macro I have
    Output Type = Table
where the tables has 27,121.
When I attempt to change the Output Format to Microsoft Excel 97-2002(*.xls)

How would I write an Open event to run a macro when I open the workbook/pivot
table and the stored data will refresh? I'm pulling the information from a
query into a pivot table.

I've set up a macro that executes a query (Open Query), dumps the data into
Excel (Output To), and opens Excel. Within Excel, I have a macro that
rearranges the data and defines the page setup. Is it possible to include the
execution of this Excel macro within the steps of the ...

I'm using a sendObject method to generate an email. However, the
message is in plain text. Is there anyways that I could generate a
rich text format instead of plain text.
Guidance will be appreciated.

is there a macro action which will move the focus from the main form to a
sub-form, or between one subform and another subform?
I need to provide a requery action so that as the user moves from one record
to another in a datasheet subform, the corresponding records in other tables ...

I am getting Field 'F1' doesn't exist in destination table when I run a macro
to import an excel sheet into an Access table.  I deleted all the field names
on the Excel sheet and in the macro for the "Has Field Name option, I
answered No, but I still get the error.

Can anyone help?
I have created a MACRO that will run a delete query.
I then created a form that when the user clicks on a button it will run the
delete macro.

I have recently changed over from Access 2000 to 2003 (yes we are a
little behind the times) but many of my users are still using 2000 so
I haven't converted the database.
There is a complex macro that I run from a button on a form. This

I am printing to a report which is actually a contract that auto fills the
info from a form.
EX- John A Smith And Mary B Smith
John A Smith is a control concatenated

Does anyone have a script that will combine the first initial of the first
name and the entire last name to make a username???  The first name and last
name fields are two different fields in the DB table.  I have created a
"username" field in the same table.

I have a macro that calls a command to run a batch. However, in order for it
to work correctly we need to have Quick Books open. Since our Access
application and quick books connect w/ data. Once the command is complete
quick books stays open. Is there a macro command I can use to ...

Reviewed earlier post on problems of setting the Visible property in Access
2003, and followed directions in MS Knowledge base article 841916 in creating
a module, and then running via a macro.  But I still can't set the Visible
property of the Navigation buttons on my ...

I have a number of reports that I want to set up in a macro and then print to
a pdf file. Can I do this and also how do I define the "save as" for the PDF

we have created a switchboard which takes care of all tasks from
entering data, generating various reports and viewing those reports.
We want to write a macro which asks the user for the dates i.e. from
date and to date for which the reports need to be printed.

I’ve a form (F_OE_Ideas_FillIn) with a couple fields where users can put
their data in. After they put their data in, I’ve a submit button witch
select all the data from the fields on this specific form and put it in the
database table (T_OE_Ideas).