development of report number

[johnpolg]

the image below shows the image below in excel. i was just wonder if it was possible in access. maybe it is just be beyond my access skill level.


what i am trying to do is when you select the all components you get a documented identifier. once a person has there identifier they will get a unique number, which is there selected series number, then the next available number in the series.

in the excel i have use VBA, if there is a value in the table of XXXX0783-ZZZ-10-XXXX-RD-S-BR201 the number given is XXXX0783-ZZZ-10-XXXX-RD-S-BR202.

Once all combined this should be a unique document number cant be used for by anyone else.

is there an easy way to do this?


i just had an idea but not sure how to do. can person try and write the number but if its alright use a note should state number already take? is this easier?

or is what i am trying a high level skills.

[davegri]

BIm number_rev B-davegri-v01.zip

Some major changes in attached DB include removing all table lookups and replacing with PK - FK relationships.


Then modifying form code to allow the automatic creation of DrawingSheetNumber and updating t00_record with document identifier and document number.
All necessary portions of the document number are verified present before allowing any updates.



These changes, along with Micron's suggestions should get you well advanced.

[johnpolg]

sorry for the delay reply. thanks very much for this.

[davegri]

sorry for the delay reply. thanks very much for this.

I have a revised version that fixes a couple of problems in the original if you'd like to have it. It has main form with 2 tabs. One tab to create the doc number revs and another tab (shown) that allows reviews.
I assume that edits to doc numbers would not be allowed, too much chance to get things screwed up.

[johnpolg]

wow, that would be great. thanks.
still trying/working on getting database to count number of time a document identifier and series to automatic the number. I have in a query just trying to add to the form, given the overall document number.

[davegri]

wow, that would be great. thanks.
still trying/working on getting database to count number of time a document identifier and series to automatic the number. I have in a query just trying to add to the form, given the overall document number.

Ok. This version does that. As a matter of fact, the user cannot type in the new document suffix, it is calculated based on prior entries.

Blm number_rev B-davegri-v02.zip

[johnpolg]

hi that great, i can see it has work for you but the create new record button doesnt work for me. is there something i am doing wrong?

[davegri]

hi that great, i can see it has work for you but the create new record button doesnt work for me. is there something i am doing wrong?

I have sent you a PM.