Hello all,
I've been asking for a few final questions to get this database up and running. I'm very new to VBA, but imagine this feature will have to be done VBA.
So, under the "Scheduling" form, when a new record is selected, I'd like for the REQ# to auto generate the next F#. The F# goes in order based off newest entry. For instance, the newest entry would be F15-090, since the previous one was F15-089... and so on once a new entry is submitted. The F# will change every year on October 1. So next October, it will start with F16-001. Is this possible?
My next question is, the F# needs to be a hyperlink, with an attached new empty folder (for drawings, etc.) with that same F# as the file folder name. This folder will be placed in a certain location, for now we could say just to store these new folders on desktop. Is this possible?
I appreciate the help in advance! Please see database.
I've been asking for a few final questions to get this database up and running. I'm very new to VBA, but imagine this feature will have to be done VBA.
So, under the "Scheduling" form, when a new record is selected, I'd like for the REQ# to auto generate the next F#. The F# goes in order based off newest entry. For instance, the newest entry would be F15-090, since the previous one was F15-089... and so on once a new entry is submitted. The F# will change every year on October 1. So next October, it will start with F16-001. Is this possible?
My next question is, the F# needs to be a hyperlink, with an attached new empty folder (for drawings, etc.) with that same F# as the file folder name. This folder will be placed in a certain location, for now we could say just to store these new folders on desktop. Is this possible?
I appreciate the help in advance! Please see database.
Generating a new F# and creating an empty folder on new data entry
0 commentaires:
Enregistrer un commentaire