I am performing a set of very simple database queries in Microsoft Access,
that I want to automate instead of going through them all manually.
Namely, I possess a database of records as usual (the first field is a name,
the second date and the rest numerical, like height, weight, ...

I have a MS access 200 DB in which I have an update query which
repalces all the " " with ''" in a field. I would like the update query
to run in the background, and not ask the user for any perrmissions. I
was thinking to run the query as part of the autoexec macro.

I have a table with information on documents.  Each document goes through
several review steps.  Another field contains a document number.   I want to
assign this  sequential tracking number to each document only when the
document gets to review step 3, for example.  

On a Print Report Dialog form, I have an Option Group to print reports.  The
user selects which report they want to print.  Below the option group, I have
a combo box for Division, then another combo box which filters the Region
based on the Division selected in the previous ...

I have a MS access database table for which I regularly need to import
fixed width text data. At present I have to to cut and paste the text
data from its source to a text file, save the file, import the text
file as fixed width text [it is not naturally delimited], and then run

i had 2 macros. if [field A]. [tbl01]=1, excute macro1, if [field A].
[tbl01]=2, excute macro2. how can it be done? thanks!

Hi, I'm new to ms access 2000 and require help.  I have three files -
A,B,C which are produced daily;  each of these files have a date in the
name - meaning file A is A-12152005.txt; B-12152005.txt and
C-12152005.txt.  I would like to create a macro that would import these

I want to email specific pages of a report based upon content within the
report to users on our network. Each page emailed will be based upon content
specific to the user. For example, Page 1 contains data for John Smith while
Page 2 contains data for Jane Doe. I want to ...

I have inherited a set of complex Access Databases, one for each state
in the US.  They are all based on a similar principle and processes,
and have the same goal of calculating a price to charge each customer.
However, each state has slightly different logic to calculate the cost

in a query,  I prompt for a date range ( mm/dd/yyyy )
--   works great
in a report based on the query, I want to re-display the entered
date in a long-date format.....  cannot figure out a way......

How do I create a macro that will run a module?
Thanks,
Scott

I have a macro that on a press of a button it e-mails a copy of a table to a
selected person.  The will work on the first click of the button but not on
the second button.  If I come back to it 5 min later,  the second button
works but not the the first.  I am wondering if it is ...

I have one column that contains three numbers, a space, and a sentence. I
need to remove, delete (whatever the term) the first three numbers and space
OR move the sentence to another collumn. I need this action to repeat it's
self till it reaches a blank row (400 rows).  Anyone ...

I am trying to set up a macro that imports data from a text file using one of
the Import Specifications I have set up.
When it imports, I want Access to add a primary key (just as it would if you
mannually went through the Import Wizard where it adds a column at the far

I use an Access table for data entry, much of which is pasted in the table
from other sources. Many times, the text pasted is ALL UPPERCASE TEXT, which
drives me nuts, as I have to go in and manually change it to All Title Case
Text.