Hi All,
I have created vba based user form. Form opens by command button click placed in same excel sheet. I have created text box in form in which I want alphanumeric form ID to be displayed such as "DRLL-0001". Once the form is closed and opened again, next number should be displayed in same text box that is "DRLL-0002".
I want unique Form ID so that I can retrive data back to form based on this ID from database.
Thanks in Advance.
I use the built-in document properties to store the 'invoice' number in, say, the author field. When you close the form, store the number in the author field. When you open the userform, in the Initialize event, fetch the number, split it, add one to the right hand part, and put it back together on the form.
The reason I use the author field is that it's easily accessible if it gets screwed up.
I use a label, too, instead of a textbox to prevent tampering.
David
(*) Reputation points appreciated.
Hi Tinbendr,
Sorry but I am not that familiar with VBA. If you dont mind, can you please illustrate with an example.
Thanks in Advance.
If you can upload a sample file, I'll be glad to.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks