I think I need a macro for this.
 I want to update a last update date field in my main
 customer table anytime the customer table or any other
 support table (payments,order,etc) data is updated.

Do anyone have an idea of the VB code for a enter key?  I
would like to add a line in a memo field via a VB code.
Thank you so much.

I want to do this insert statement, but i get a mysterious error message
that sheds no light on what the problem is. I'm assuming it's the nested
select part.....The value of costPerHour should already be in the Equipment
Assigned Table...in theory it won;t ever be null.

Hello, can I use a Macro to perform a database "relink"?  
I would like to have a button that runs a macro that will
relink all the tables to a back end file set in a folder
on local server.  Can a macro handle this or do I need VB?

Is it possible to set up a query / macro that automatically deletes records
held in a particular query table?
For example, I wanted to have a Yes/No field in my database that would
basically be an Include / Delete option - if ticked, then that record would

Hi there everyone,
I am looking for a way to import all the tables in a
oracle database through a ODBC link to access at a
scheduled time of day.

I would like to have the form complete a record upon entry
of the info in the Primary Key field.  I know this has
been done many times and I am not able to recreate that
particular wheel.

Anyone know how I can easily print around 100 reports
without going in and opening each one, etc.?

I want to run my update query on exit within a form.  It
has too many characters to set it up easily.  Can you
help. See below SQL for the update query.
UPDATE [Programs Tbl] INNER JOIN ([Quote Tracking Tbl]

I have an Access 97 front end with a SQL database backend with linked ODBC
tables.
I want to be able to change all linked tables to switch between the
production SQL server and the test SQL server.

I have a DB with queries based on table resulting from
data entered via forms.  I need to automate the merge of
this data into preformatted Word docs.  I believe that I
can make this happen with a command button on the form or

Is it possible to create a macro that can send an email
of a list of something (e.g. a list of books)
automatically to a list of users stored in a table.
Please could you email me if you have any idea or you

I find alot of help on here, so thanks to everyone for
that!  
I'm just starting out with VBA.  Is there a good book or
resource out there that anyone would like to recommend, or

I need to hide the default menu on start of an Access application.  The check box for the default will not work

Is there any function or other way to have data in a cell
updated automatically from data in Access?
I have a scale program entering records into a table in
Access, and I need access to pass the data it recieves