Re: Need Help Creating a ID Number

Matt, download http://www.dbtc.org/zipmdb/drawingnumbers.zip
2 tables, a form, a subform and a little VBA
It might serve as a guideline that can help you along.

UpRider

"mattc66 via AccessMonster.com" <u16013@uwe> wrote in message
news:788dce8521c0a@xxxxxx
The numeric part of the drawing number is the autonumber from the main
form
table. So yes we only need to generate and store the Alpha letter in a
related table. No, the most revisions we have on a drawing 4 or 5. If we
get
to Z we got bigger issues.

ID Name: QuoteID
MainForm Name: frmQuotes
TableName: tblQuotes
SubForm Name: sfrmDrawingNumbers
TableName: tblDrawingNumbers

We could store the rev level in it's own feild and then join them in a
query.

We can call that feild: revision

Thank you very much for your help.

Matt

UpRider wrote:
Matt said:
My plan is to have a request button that the user will press to generate
the
Drawing number.

Matt, more procedural info. When the user presses the button, how do we
know whether the new number is for a Rev or an original?
Is the numeric part of the drawing number the PK autonumber for the table?
If so, we need only generate and store the alpha letter, as we already
have
the numeric part.
Will there ever be more than 25 Revs? If so what happens after Z?
Also, the drawing number cannot be stored in a subform. It must be stored
in
a table.
Can you supply the name of that table and the names of the ID and drawing
number letter.

With this info, I think we can begin to see the big picture for the
required
code.

UpRider

Hi All,

[quoted text clipped - 22 lines]
Thanks
Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200709/1



.

Quantcast