I am trying to stop my macro from continuing to run if I get an error, but am
not able to write a condition in the condition field to make this happen.  I
have tried using "on error" but it doesn't like that syntax.  Can you help?

I want to write a Macro that will recognize a ID number and open another
excel spreadsheet that contains that ID number and a corresponding Labratory
number, and automatically enter that Lab number on the intial spreadsheet.  
Is this possible, if so how do I build that?

I need to create a macro that copies a table and exports it but also saves
the table as a new table name each time the macro runs.  Bascially, I need to
be able to maintain the historical tables.

Hi Everyone..
Im just wondering if I can get some help on the above subject.
I inherited a database (from a co-worker who left the company), with macros
within macros and it keeps on halting on the GoToRecord.Form.<FormName>.Next  

If I am trying to go into a specific file that someone else is using how can
I set it up for me to know who is in that file without having to get out of
my seat and ask everyone?  I want the program to let me know who is i that
file at the time I try to access it.  What is it ...

Is there a way to export a table from Access to excel and add Bold, Centering
and wrap text in the excel spreadsheet

I am trying to use a macro in Access to highlight expired date entries in the
database. I can do this by calling up a report in a macro and notifying the
user, but I don't want the report to show if there is no detail. Currently, I
can't get the macro to work without calling up ...

i have a macro that when you update any of the fields/control it then puts
the date and time when last updated. does anyone know how to tell which
field/control has been updated?

I need to know if Access can be set up like Excel whereas if I am trying to
get into a file the program will let me know who is already in that file.

Based on the code Albert (Access MVP) provided I implemented VBA code
to read a table ACTStage and insert the data from ActStage into
ActFact please do not ask me why I am doing it this way I am just
practising the code for a more complex scenario please do not drive

I want to run some Access-reports automatically (monthly) and I have written
a macro that calls a procedure that writes my Access reports to a file. The
macro performs beautifully when I run it manually from inside Access. But
when I try to schedule a task to do the same thing on ...

I want to read a table ActStage which as the following fields -
Customer, Store, Fiscalyearperiod & Sales all fields except Sales are
text fields and Sales is a numeric field and sales can sometimes have
null values.

Jeff
Sorry, there is a problem is posting back to the newsgroup I have to
post as a new messsage everytime I reply back.
Albert first of all many thanks for your help I admit your posting

Jeff
I have a scaled down application running on SQL Server. I SQL we are
using cursors in stored procedures in many places to things like the
following:

Have been trying to use "setvalue" for the action, table and column heading
for item and Right(column heading, 5) for the expression.  What a i doing
wrong or not doing?
Thanks