mgrygorczuk
New member
- Local time
- Yesterday, 20:39
- Joined
- Feb 25, 2008
- Messages
- 6
Dear All;
I'm putting a DB for stored documentation. Files are being stored on a server, my db will capture info about those files plus a hyperlink to them.
Now, whenever I add a new file, I have to give it a code number first. So my actions now are:
1. copy file to work folder (ToDB in my case)
2. input information into db about the file(like project number, doc type etc)
3. generate file number(based on selected: project no, stage, type - f.ex. 045-2-ANNX-sequencial no. (001, 002, etc)-I kind of done that by usind DefaultValue, but it doesn;t check for already existing no. in db so it gives a 001 by default to every file)
4. rename the file by adding generated no in front (so it keeps the original file name, just adds that generated no in front+space)
5. copy file name into db as file title(copy file's original name into text box on form)
6. move renamed file into server(delete from /ToDB, move to /DBFiles on server)
7. create a hyperlink to that file(which is done manually and takes too much time)
My question is:
Is there any way to automate this process?
Ideally, I'd click on a button "Add file", dialog box would pop-out asking for a file, I'd press
"OK" and the file would be moved to target folder, and updated with a number from db, also hyperlink to that file would be created and inserted into db.
Q1: Would I have to write a code for that from scratch or are there any buid-in "file add wizzards" ?
Q2: Could all and each of my steps be achieved using VB? Or is there a step that can't be done in Access at all?
I'm not an expert, and the last thing I want to do now is to try to find an answer to an impossible to solve problem. So. if anyone could just confirm that my steps mentioned above can be transformed into VB or macros and I could achieve the state in which I'm able to upload and rename a file by means of few simple clicks - then at least I'd know that it can be done and I'd go for a search for answers.
Any help greatly appreciated as I'm wasting too much time on creating hyperlinks from scratch everytime I add a file.
Regards,
Maciej
I'm putting a DB for stored documentation. Files are being stored on a server, my db will capture info about those files plus a hyperlink to them.
Now, whenever I add a new file, I have to give it a code number first. So my actions now are:
1. copy file to work folder (ToDB in my case)
2. input information into db about the file(like project number, doc type etc)
3. generate file number(based on selected: project no, stage, type - f.ex. 045-2-ANNX-sequencial no. (001, 002, etc)-I kind of done that by usind DefaultValue, but it doesn;t check for already existing no. in db so it gives a 001 by default to every file)
4. rename the file by adding generated no in front (so it keeps the original file name, just adds that generated no in front+space)
5. copy file name into db as file title(copy file's original name into text box on form)
6. move renamed file into server(delete from /ToDB, move to /DBFiles on server)
7. create a hyperlink to that file(which is done manually and takes too much time)
My question is:
Is there any way to automate this process?
Ideally, I'd click on a button "Add file", dialog box would pop-out asking for a file, I'd press
"OK" and the file would be moved to target folder, and updated with a number from db, also hyperlink to that file would be created and inserted into db.
Q1: Would I have to write a code for that from scratch or are there any buid-in "file add wizzards" ?
Q2: Could all and each of my steps be achieved using VB? Or is there a step that can't be done in Access at all?
I'm not an expert, and the last thing I want to do now is to try to find an answer to an impossible to solve problem. So. if anyone could just confirm that my steps mentioned above can be transformed into VB or macros and I could achieve the state in which I'm able to upload and rename a file by means of few simple clicks - then at least I'd know that it can be done and I'd go for a search for answers.
Any help greatly appreciated as I'm wasting too much time on creating hyperlinks from scratch everytime I add a file.
Regards,
Maciej