Quote Number

[Tony Ramirez]

I would like for users to go into a form and reserve a quote number. Would
like the quote number to be auto-assigned using mmddyy (then count 01 to xx
for the day) followed by their initials. Basically result would be 02280801TR
for the first then 02280802TR etc....Not mandatory for the Initials if you
could solve the autonumber mixed date field...Initials could be another field
in the database and could combine later.
Thanks

 

[Gina Whipp]

Tony,

I would place the below on the AddNew button:

DoCmd.GoToRecord , , acNewRec
Me.txtQuoteID = StrReverse(Format(Date, "mm")) & Format(Date, "dd") &
Format(Date, "yy") & DMax(Right([qQuoteID], 1), "tblQuote") + 1 & Where you
get the initials from

qQuoteID - should be the name of your Quote ID field
tblQuote - should be the name of your quote table
Me.txtQuoteID - should be the name of the field on your form

HTH
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

 

[Gina Whipp]

Oops, you might not need StrReverse, mine did and I changed it for what you
requested but didn't remove the StrReverse!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

Tony,

I would place the below on the AddNew button:

DoCmd.GoToRecord , , acNewRec
Me.txtQuoteID = StrReverse(Format(Date, "mm")) & Format(Date, "dd") &
Format(Date, "yy") & DMax(Right([qQuoteID], 1), "tblQuote") + 1 & Where
you get the initials from

qQuoteID - should be the name of your Quote ID field
tblQuote - should be the name of your quote table
Me.txtQuoteID - should be the name of the field on your form

HTH
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

I would like for users to go into a form and reserve a quote number. Would
like the quote number to be auto-assigned using mmddyy (then count 01 to
xx
for the day) followed by their initials. Basically result would be
02280801TR
for the first then 02280802TR etc....Not mandatory for the Initials if
you
could solve the autonumber mixed date field...Initials could be another
field
in the database and could combine later.
Thanks