How to automatically stop a macro

  • Thread starter Thread starter Mogiwitt
  • Start date Start date
M

Mogiwitt

I have a macro that I designed with Access 2003 to open a table, copy one
cell and paste the value to the appropriate blank cell in the next record.
The problem is, the data is derived from a .xls file that is always of
different lengths. One day it will be 140 records, the next 35. As such, I
want to come up with a conditional expression that will tell the macro to
only run if the value of a cell does not equal the word 'End'. Is this
possible? If not, how can I tell the macro to stop once it reaches the last
record (End of File?). Thanks!
 
Mogiwitt,

There is no such thing aqs a "cell" in Access. This may seem like
unimportant semantics, but I think it will help you.

This sounds like a most irregular thing to be doing in a database. Do I
understand you correctly, that the same value is being put into a
particular field for all records in the imported data?
 
Back
Top