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.

My currency field have 4 decimal point in my Access Table, but after I
transfer to Excel using functino TransferSpreadsheet, it become 2 decimal
point only, why? Can I solver the problem?
Second, how do i set the date format to "dd-mmm-yyyy" for all my date field

I am trying to import several hundred text files into access using a macro
and the TransferText action. How can I tell access that the name of each text
file varies?

I am trying to create a macro which I can use as a button in the form view
toolbar.  I want to be able to enter my data on the form, and then print only
the corresponding report by hitting the button.  I can get it to print, but
what do I do to only print current report?

I'm working on a .dbf table from another program, trying to manipulate the
data so it can be used in a mailmerge letter.  Anyway, the table has
numerous fields.  Some of those fields have a person's first and last name
(in one field) ex.: "John Smith"

I am trying to use the TransferSpreadsheet and OutputTo commands in a macro,
so that the files created are stored on the same path as the database itself.
I do not want to type the entire path, because I want to be able to place the
database in different people's drives, in any ...

I have a list box that lists out names of reports that can be run.  It is
linked to a table that has 3 fields.
Report Description
Report Name

Is there a way to set a variable within the macro that the macro can use for
different steps??  Specifically, I want to be able to pass a value to a VBA
function.  Also, is there a way to take the "output to" command's file
name/path setting and put so type of variable in it to ...

Does anyone have a quick way to dispay the name of the query that is
currently running when runnig a macro?

Appreciate it if someone could help me.
1) Execution failed to RunSQL action for SQL Statement
  ALTER TABLE Table1 ADD Column1 NULL
2) Confirmation Box (Yes/No) still appear even I created

I would like to use access to send files automatically to people and track
them. Please let me know if you can provide more info or share any example
codes. Macro suppose to use e-mail address from table and use created file
and send it to user.

I created a macro which will take a report and output it in HTML format. This
works ok but i would like to put a logo and a few other things on the HTML file
before i put it on the server and make it available to our customers.
I understand you have to us a templete for this and i ...

I'll try and describe this as best I can
I have a database that i want to use as the basis for another database.  I
run a few queries that place data into this database.
What I want to do is run the queries that place data in a copy of the

I would like to be able, from a form, use a button to open a particular macro
in design mode so the user can update some of the fields.  If it is possible,
how do I do it.  thanks.

I am writing a macro that exports a table into a text file, i need this text
file to be tab delimited not comma delimited.
How can i do this?