Can anyone help me to export an access report to a new text file with a macro?
Thank you.

I'm running a macro that imports text files into a table.  I do a "delete"
query on the table to clear the contents and then I start import text file1,
text file2, etc...
The problem I have is that sometimes the text files are not in the table in

I use macros and the OutputTo command to create spreadsheets and reports.  
What is the command to have the macro erase/overwrite the existing file?  
When I run it using the switchboard menu, it does not ask to replace the
existing file.

I think this is a macro issue, not sure.  I am using Word 2003.  I have Adobe
Acrobat 6.0 Professional.  There is suppose to be a Acrobat PDF icon in Word
that you just click which then saves the document in PDF format.  But I
cannot get the Icon to show in Word toolbar, anyone ...

I need transfer a table of data to another table
with the use of VBA.
For example:
Read from table 1 then

In microsoft Access i cannot find an expression command list. I am using
Windows XP professional.

Ihave created a macro to import an excel spreadsheet with a list of Postcodes
into tblMain1 which is linked to tblPostcode Locations on a one to one join
my report takes Postcode from tblMain1 and X and Y from tblPostcode
Locations. Then i told the macro to print the report.   As ...

I am trying to setup a macro to run at off peak hours i.e. 12:01 a.m. every
Saturday

I have a table like such (with additional columns to those shown):
Name                Type                Amount
Mike                  A                     20
Mike                  B                     40

I'm trying to create a report where the the user can enter criteria
(beginning date, end date) to generate a report.  (Using the Acess Help file
instructions to create Macros while creating a form to enter report criteria)
*I've created a form to enter the criteria.  (with macros ...

I am running Access 97.  Is there a way to use the 'SendObject' action to
send a report as a .pdf document?  I have the Adobe Acrobat Distiller
installed on my machine and I am able to go to File-->Print-->Distiller and
create a .pdf document.  I can then attach this to an email ...

I have recorded a macro in the record mode then tried to recall that macro
and when it comes back to me it is not the way I recorded it i.e. style
(font) and sizes that I recorded it in.

I have created my own alert for when someone accidentally tries to input a
duplicate record in a data entry form. My question is, how do I supress the
automatic alert that also comes up? If it requires VB, can someone give me an
example?

i am using Access 2000 and want to email a word document to a selection of
people in my database. What is the best way to do this, can I use the
SendObject action
thanks

I have a text file that is imported into an access table. As an example, the
file contains the following data:
101,10, 1,04,2South
The space before the "1" is deliberate. The table has all text fields.