NeoPa,
Thanks for checking back. I'm testing a code to load the records from Excel to the table without the version numbers and then run a update query with the dmax function on the recordset. Thanks again for the help
AkosBeres
Last Activity: Sep 16 '08, 04:29 PM
Joined: Aug 7 '08
Location:
-
Thanks ADezii,
The update query worked. I only had to change was the where criteria to "is null" from "<>1" and moved the description criteria down to the where line. Thanks againLeave a comment:
-
Thanks NeoPa,
I probably wasn't clear that the records would be coming from an Excel sheet and loaded into an Access table. I was hoping that Access could assign the version number based upon the records already in the table when a user loads the new records.
Please correct me if I'm on the wrong path but I haven't used Dmax command before. Would I need to run a SQL query to find the highest version number with Dmax from Excel and...Leave a comment:
-
Version/Sequence control in Access 2003 table
I’m in the process of setting a sample local Access table called "Fruits" to store data in the following sample fileds:
Week
Amount
Description
Version or sequence
The data will be loaded into the MS Access 2003 table from MS Excel 2003 spreadsheets via VBA code. I’m looking for recommendations on how to advance the version number as data is loaded into the table. For example, on day 1 we would...
No activity results to display
Leave a comment: