This macro has been quite handy for me but I still have to manually
click "yes" to save changes on each file after it has prepped (see
below).  What
can I add to eliminate from clicking "yes".   Thanks for any help in

OK OK......stuck again.....looking for more help.........
without explaining the whole database, I hope I can explain the
situation by the example below..........
I have a query that pulls all the records from a table.  For example,

   I have a database that I am using to store emails I send to customers &
suppliers.
What I want to know is this, is there a way that I can select more than one
source to create

I have a continuous form were it has the employee, field 1(Deserts) and
field 2 (Flavors) are one-to-many related.  Field one will give me a combo
box drop down of Ice Cream, Pies  Field 2 needs to look at field 1 and say Ok
you have selected Ice Cream so I'm going to show you ...

would like the field to be able to keep running count of items keyed in , but
then when items are taken out of field would like it to subtract from count.
Basically i have a drawer with folders that accumalate daily, but then some
are taken out daily. How can i keep this count.

im a novice with access and cant seem to figure out how to perform what i
would believe to be a simple task...
background:
-i have a main table that houses 'request' information

Does anyone know a good way to have your database evaluated?  I've spent
countless hours refining my DB and I'm so close to having it the way I want,
I was wondering how I might go about having someone review it to make sure I
don't have any fatal flaws (I don't see) that would ...

Lets keep its simple...How do I completely Un-Install Outlook Express?

I have some .MDB files I need to be able to read... What viewer ( like PP
Viewer ) can i use just to be able to read these files ?

Hi,i'm Mishu and I need to build a logon form, where users who logon can edit
the DataBase,and the ones who have no account can only view the content of DB.
The second thing is that I need a form where users logged on can upload and
download files to/from the DB. Sorry for my bad ...

Hello, I posted a question (One PC not able to calculate formulas ect.) a few
days ago and John Spencer answered it. I marked the post a answered so I
figured it wouldnt be checked again and I had to repost the question. Anyway,
John gave me an answer that I had missing or messed ...

Hi! I'm new on this. Can anyone help me?
I want to do a form where I put a combo Box (cboCategory) to select a
category of produts.
In the AfterUpdate event I activate and selected another comboBox

Newbie to Access .MDB
I am trying to create a VB6 form for users to change their log-in password
if they want to. I am not sure if it is possible to save the passwords to a
.MDB file with encryption so that the actual characters of the password do

I have a imported file from another application where one field is a
date.
Using DoCmd.TransferText, the structure and the data of a temptable is
created. The temptable has to be delete (data + structure) for each

I have an Access db which keeps details relating to a series of
reports ie how often are the reports produced, who they are sent to
etc. In a seperate Word document are the detailed instructions as to
how these reports run. I would like to link the db to the word doc.