i have a command which send all the tables in my database through emails
after having saved each of them in .adtg format in a folder named backup.
Now i would like to compress the folder and attach the compressed file to
this email.

can I download office 2000 on line?

I understand there is a way to check for compiling errors in Visual Basic
Editor.  Does anyone know a simple code I could run that would return
problems in the Immediate Window.  Please be specific as I don't have a lot
of VBA experience.

is there a way to fire a procedure on closing the DB?
the application object doesn't have any events...so how?
I would like to record in a table the date and time of the closing
Nico

G'mornin' all!
I've been trying to do this for a couple of days and I've had enough of
struggling so I'm hoping one of you has tried this before!
I've got a form with contact details of companies on it. It's based on a

I am new to this forum and pretty new to VB code. I have not done much with
it in the past and what I do is very simple. I am having a problem getting an
If Then Else statement to run. In an Access database I would like a line to
display IF a number is greater than another number ...

   I am a form with a Listbox and a command button.  When an user clicks on
the button an inputbox will appear to prompt for name of the new item to be
added into a table.  Then it'll requery the listbox so it'll have the latest
entries.  Here is the code for the cmdbtn:

I need to update a table (Table1) from a temp table (Temp1) that I imported
data into.  I'm getting an error on the db.Execute line.  
What's wrong with these codes?
Dim db As Database, rsCust As Recordset

i am using access program for my doctor clinic and i want to install a growth
chart in there some how where i can use data i inter as for hight weight and
length and then when i press a botton i can see it on a growth chart

i need to disable a running timer if the Access-Mainform
was minimized.
How can I solve this?
Thanks in advance for any help.

I need to export a file.  That's the easy part.
The difficult part is I need the file to be named YYYY-MM based on the data
range someone pulls.  How do I do this?
Furthermore, I need the file to place the data on a certain tab in a certain

I have a DB with several ODBC linked tables.
Using Code, I am 'Executing' queries using these tables but require a
password each time.
How do I build up a connect string to use in my SQL to save me having to

I'm a relatively new database programmer. I am wondering if there is any
kind of tutorial or information on how to properly use recordsets in code to
locate and manipulate data. I am mostly self-taught in Access, and feel like
I missed a pretty important ability here...

Good morning,
I am using an Access 2003 on an XP Pro computer and using an Access module
and an object variable to control Excel and things seem to function w/ no
problems if Excel is open, but if Excel is closed, my code should test to see

I created a database for my book collection. One of the fields is the ISBN of
the book. Amazon.com has a product page for every book by going to
http://www.amazon.com/exec/obidos/ASIN/[ISBN].
Therefore what I'm trying to do and can't figure out how is to have it so