W
wellssh via AccessMonster.com
Greetings again,
I convinced the team to shy away from using a combonation of date /
incrementing number for the ID #.
Now we are going a different route for the sake of consistancy in ID numbers
and hopefully for my sanity.
Again my table structure is as follows
Table1
EstimatelogID (autonumber) PK
Estimate number (text field, must remain a text field)
Estimate Type
Date Created
What I need to do, is when they enter data with a form, the "Estimate number
" field needs to be generated, and increment by 1 upon every new entry. With
the following format -
ES-00001
ES-00002
ES-00003 etc etc
I did read one post that suggests that if the "ES" doesnt change, no need to
store it at all, and/or having 2 fields for it, one for text, and one for
serial.
I dont think that will work in this case, the wrinkle is, that my table has
data appended into it from a different database, which I have no authority to
change. The "estimate number" from this OTHER DB is formatted as a TEXT field
and ID'd as follows
CR-56080
CR-56081
CR-56082 etc etc
So as you can see, this is why I need the incrementing number in this form to
generate-
ES-00001, ES-00002 and so on and stored in the Estimate Number field as an ID
number, while leaving the field a "text field"
I searched the archived posts for help with this problem, I found several
solutions that were close, but not close enough to solve my question. I have
basically completed the entire project (less bells and whistles) and am down
to this last problem, once solved I can start testing.
Thanks in advance for any help.It is truely appreciated,
happy holidays to all
I convinced the team to shy away from using a combonation of date /
incrementing number for the ID #.
Now we are going a different route for the sake of consistancy in ID numbers
and hopefully for my sanity.
Again my table structure is as follows
Table1
EstimatelogID (autonumber) PK
Estimate number (text field, must remain a text field)
Estimate Type
Date Created
What I need to do, is when they enter data with a form, the "Estimate number
" field needs to be generated, and increment by 1 upon every new entry. With
the following format -
ES-00001
ES-00002
ES-00003 etc etc
I did read one post that suggests that if the "ES" doesnt change, no need to
store it at all, and/or having 2 fields for it, one for text, and one for
serial.
I dont think that will work in this case, the wrinkle is, that my table has
data appended into it from a different database, which I have no authority to
change. The "estimate number" from this OTHER DB is formatted as a TEXT field
and ID'd as follows
CR-56080
CR-56081
CR-56082 etc etc
So as you can see, this is why I need the incrementing number in this form to
generate-
ES-00001, ES-00002 and so on and stored in the Estimate Number field as an ID
number, while leaving the field a "text field"
I searched the archived posts for help with this problem, I found several
solutions that were close, but not close enough to solve my question. I have
basically completed the entire project (less bells and whistles) and am down
to this last problem, once solved I can start testing.
Thanks in advance for any help.It is truely appreciated,
happy holidays to all