|
|
|
#1
04-06-2009, 07:11 AM
|
|||
|
|||
Assign A Sequential Number To A Table Row
I have a table that has four fields and 39k rows. The first field is for the sequential number. The fourth field has a different entry varing from the 177th to 185th row. Using VBA how can I seqentially insert a number from 1 to n based on the fourth field entry. Please help.
|
|
#2
04-06-2009, 08:37 AM
|
||||
|
||||
|
I would look into Stephan Lebans solution.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
#3
04-06-2009, 10:00 AM
|
|||
|
|||
|
Assign A Sequential Number To A Table Row
Thanks RG for you reply. I am not that versed in VBA, but will the code I looked at in the Lebans' site serialize all the row's start to end or will the 'keyname' be used for my 4th field condition to restart the serialize function. (ex. Serial # 1-177, field 4 = xxyyxx // Serial 1-177, field 4 = zzxxyy,,etc.)
|
|
#4
04-06-2009, 10:11 AM
|
||||
|
||||
|
Serialize the Recordset from beginning to end. I guess I do not understand what you need. I don't understand this:
Quote:
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
#5
04-06-2009, 11:48 AM
|
|||
|
|||
|
RG - (Field-1) Serial # 1-177, field 4 = xxyyxx // Serial 1-177, field 4 = zzxxyy,,etc.)
Field-1 Field-2 Field-3 Field-4 1 xx xx xxyyxx . xxyyxx 177 xxyyxx 1 zzxxyy . zzxxyy 177 zzxxyy ......and so on sorry for the confusion and not explaining clearly. Does this help. Thanks,
|
|
#7
04-06-2009, 11:54 AM
|
|||
|
|||
|
|
#8
04-06-2009, 03:24 PM
|
||||
|
||||
|
I think you will need to roll you own on this issue using the DMax() function.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
#10
04-07-2009, 03:56 PM
|
||||
|
||||
|
Post back here it you are still having difficulties.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
#11
04-08-2009, 06:38 AM
|
|||
|
|||
|
Unfortunetly yes...I even posted on the MS Office Forum, EXCEL but haven't received any replies. I"'ve been just digging through manuals and just not getting any responses from other forums. You would think this would not be such an envolved issue: creating sequential number for a number of rows conditioned on a value in another cell and continue the process for x number of rows.
|
|
#12
04-08-2009, 06:48 AM
|
||||
|
||||
|
It is not difficult. A DMax() with a WhereClause is all it takes.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| need query to assign sales leads to reps?? | RickM | Queries | 0 | 03-12-2009 12:44 PM |
| Combox box returns ID number in table instead of names | JP_101 | Forms | 3 | 02-20-2009 11:28 AM |
| How can I get a calculated field to return the number back to the table? | FestoAccessBuilder | Access | 1 | 02-05-2009 01:53 PM |
| help creating a sequential number for records in a table or query | rthomas | Access | 1 | 01-31-2009 07:43 AM |
| create sequential id | proudestmnky1 | Programming | 0 | 12-15-2008 09:10 PM |
Windows XP 
Access 2003 (version 11.0)
Linear Mode
