In Access 2000, I know how to export each table in a database.  But how
should I dump the whole database which has many tables?  The dump
should be saved in a file which can be then used to import into MySQL?
Can it be done in Access or I have to use some extra tool?

Okay, I've read previous suggestions about not showing the primary key to
the user of forms.  If a number is to be shown (let's say, customer number)
it should be generated independently of the primary key (which is
autonumbered and no dups).  I think I've gotten that all ...

There's an anoying problem with a project I built, where the reports
have a message saying that the OpenReport Action failed.  The reports
open just fine on all machines, except for one.  Could this be a
corrupt Office installation or incompatible code?  The versions of

I have an access ordering database set up.  when i enter an order i
want to be able to print a  deliverly label.
How do i just print one lablel and how do i specifi which label on the
A4 sheet to print to

I'm a novice with VB and I've written this pretty simple script, but
for the life of me, I can't get the last bit of the script to work.  It
should compare the value entered by the user under the BeforeUpdate
event and compare it to the value in the main form.  It's doing that

The above error occurs when I attempt to select any of the check boxes
that are within this code.
Private Sub Check39_AfterUpdate()
If Check39 = True Then

How and where can one find out about the basics of VB/Access2003
syntax?
I am a died in the wool C/C++/Java Linux/Unix programmer and I am
finding it difficult to understand the program format for accessing

I all, i must to put a value in a textbox that's the results of a query
"select" in the code..
How can i do
Thanks

I have code in my front end that opens a form for backing up the front end.
I'll give a brief description of what the form does:
1) When the backup form opens, it closes all open forms except for three
hidden forms and the backup form itself.

I have a table that has Emp ID, EmpName and EmpSignature. The
empsignature has the path of each Signature.
On a form I have a combo box that will display a specific employee.
On a printed report that employees signature will be displayed. How can

I have a database that has tables, contact event and last date of
contact.  Then I have a report where I can print current contact and
event. If the last date of contact is less than 3 months previous I
want to ignore this event.  Is it possible to make the dbase go look at

I have 5 different fields setup on my report to be =Count([field name
1]), etc.  How do I go about adding the 5 counts together to get one
total?  I do not want the data that are in my fields for this report.
I just need an overall count of how many there are in all 5 fields

I have an image control in a report's detail section that gets its
image from an invisible bound textbox (PhotoFile) on the report. The
following code is placed in the report's Detail_Format event.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

I created and distributed an Access 2003 MDE.  When the user opens up
a form he get's an error message :Function is not available in
expressions in query expression 'Trim([city] & ", " &
[stateorprovince])'.

I'm building some reports in Acc97 and using a custom calendar form to
allow users to pick dates with which to report.
I'm wondering if there's an easy way in code to be able to
automatically work out the end-of-week date and end-of-month date from