I have several databases in different directories. I would like to create a
macro which would open 1st database, compact it and then save it, then
repeat the same for the next database and so on.
Let's assume this type structure:

I'm developing an application on my Win2000 system and when
I run it on a target Win98 system running Access 2000 it stops
in a function on the line:
   newStr= str(curRecord)

I would like to create a macro to run three querries together. But i dont
want the user to see the results of the querries so I don`t want to use the
OpenQuerry macro. So how i create this macro?

I need to create a macro that will conver dollar amount (lets say $110) into
text so I can insert it as part of a text field (lets say "What you need to
pay is $110).
Can I do this? Can anyone help me with this? THANKS!!!

Is there any way I can have the data I want to send to a user using the
SendObject Action appear in the body of the message as opposed to being an
attachment?
I have an app where I am sending a user a small piece of data to follow-up

I have designed a database for a taxi co.  I need to add driver invoicing to
it, but I am a bit puzzled as to how  to do it correctly.  They need a driver
receipt for payments made.  Each driver keeps the vehicles for an indefinite
period of time..being charged a weekly/ daily ...

I want to check for duplicate records AFTER the customers "Last Name" is
entered into my form.  I tried doing this with a macro, but can't make it
work. Any help is appreciated!  I want the employee entering the information
to be able to type in the last name, have the database ...

We currently have a field in a form that is updated each time a user enters
the form. The field has Me!FIELDNAME = Date. in the before update event.
I would like to do the same thing, but to another table. I was hoping to
create a table that had Date, Name of person logged in, and ...

I use a macro to save a query as an excel spreadsheet into a folder, the
spreadsheet is named using a formula, i.e. = format(Date(), "dd mm yy") & " -
" & [Type] & ".xls", however if two spreadsheets are saved on the same day
the second overwrites the first. Does anyone know of a ...

I am using access for video library purposes. I want to input the TIMECODE
from my tapes which looks like:
01:02:30
and I don't want it to look like:      01:02:30AM

What Access macro command (or SQL syntax) would initiate deleting an Excel
spreadsheet?
Any help is appreciated,
Thank you.

I have created a macro that outputs the results of a query to a .txt file.
Its transfer type is export delimited.  Ideally however, I should be
outputting to a .dat file.  When I specify the .dat extension, and then
attempt to run macro, I get the following error - "Cannot update.  ...

DON'T KNOW HOW TO ENABLE MACROS

Good day!
I need to run 43 queries each day, which has traditionally been performed
manually.  I'm working on autonomating the process.  Here is what needs to
happen:

I am trying to schedule a report to run from access at a particular time
each month - i am using schedule tasks to open access, but i'm not sure what
to do with the server user name and password - currently the database is
Access 2000 format it has a password for the database but ...