Re: Need Help Creating a ID Number

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

"mattc66 via AccessMonster.com" <u16013@uwe> wrote in message
news:7885a343d711b@xxxxxx
Hi All,

I am creating a drawing request tool for my company. The drawing request
number will be the ID number of my record followed by a letter. The first
letter will be A and each revision will follow sequentially B..C..D and
etc.

So if my record ID is 1000 the first drawing number will be 1000A and if
there is a revsions it will be 1000B.

My plan is to have a request button that the user will press to generate
the
Drawing number. I then will want to store these Drawing numbers in a
subform.
Once our cad department has completed the drawing they will save them as
the
drawing number. So using my example the first drawing will be saved as
1000A.
dwf. I will create a hyperlink from my subform to these files.

Can some one help me with the code I would need in order create the
drawing
number and then how to store it in my subform.

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