I have created a request form and have a button that runs
a macro to open a table in data entry mode to set the
values of four fields based on the data entered on the
request form. I am not using the "=" sign in the

I have an access databse with lined ODBC tables from SQL
server.
I create a autoexec macro in the Access database to run
nightly to do some updates.

I am dealing with the following problem (it's actually a problem of a friend
of mine, so bear with me, I'm no access expert).
There are two database, say DB1 and DB2. In a macro defined in DB1 a
function is called, say f2, defined in DB2. f2 uses various macro's defined

This is the first time I got this problem.  I was running
my macros to update my queries as usual.  But this time,
I got an error message that says, "The Microsoft Jet
database engine stopped the process because you and

is there a way to rename a field in a table using a
macro?  i would like to run a macro and change the name of
one of the fields in the table is this possible

I have a macro which will print out a report for me.  I
want it to do this without any user intervention at all.  
However it will print out the report & then display a
dialog box about "print definitions" if I click Ok it

How do I convert a text in Acess 2000.
ie I have a numeric Field called Line_no  content is 12, I
want to Convert the content to a text.
I see in access there is a function  Text(Field,Format of

How would I write a macro to automatically import data
from a excell spreadsheet?

Ken
Thank you to responding to the message, would you know whether I will need
to get specialist equipment for the Macros or VBA programming and where
would I go to find the code to achieve this.

I built a db that generates a report from a query, then
attaches the report, via a macro>SendObject, to an Outlook
e-mail message. Within the db is a table of names (email
addressees) which the user selects to initiate the report

Hi, your help is much appreciated.
I'm writing an Access 2002 db that has it's own mdw user/group definitions.
After a user logs on and is using one of the forms, they have the option to
check a box.

I would like to solve an issue. I have two macros
that I would like to run automatically at various times
of the day. The first I want to run every 3 hours and the
second every morning at 9:00 am. I've been searching

I'm trying to automate the synchronisation of a master and replica db in
order to give simple users (of the master db) the opportunity to update
their database at any time.
What is the best way to do this, using macro's or VBA ? And how do I do

i am opening my main menu form on startup, how can i
maximise this window when the programme starts please.