Auto Create a unique number from user data, for input into table.

[Andrew]

Help would be appreciated, even if it cant be done
I have a table[InspectorsMaster] using Fields, ([DR_Date], (Short Date). A
number field (Long Integer [SeqNum])I do not currently use it, and a Field
([Employee], Text field, size set at 3). I would like to know if I could
generate a Unique sequential Value (starting with 0000) and combine it with
values from date, and text field that would automaticly be entered into the
Non used Number field such as on click . This of course would occure at The
Form level before close of the form. (Macro) or after dirty of the Date field.

Like:[Inspectors Master]![Employee] + DatePart(yy)[Insp_Mastr]![DR_Date],
plus the random number, if possible.
Respectfully,
AB

 

[Jeff Boyce]

Andrew

If you already have values in all those fields (except sequence number), why
do you need to (re-)store the same values again, adding a sequence number?
(hint: you don't)

Instead, consider finding out how to generate sequence numbers (search
on-line for "custom autonumber"), then use a query to concatenate together
the fields you want displayed.

That way, you don't need to build yourself several more routines to
guarantee that a calculated sequence number in a field stays in sync with
all the pieces that make it up.

Besides, you're going to need to build that sequence number routine either
way!

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.