Ok, so I have a database I designed and have been working on for 2 and a half years. I think I am fair at what I do, though I still need nudging. Since I am working on updating things in the system to enhance performance, I had an individual ask me a question that I have no idea about. Part of what my database does is collect the testing that is requested throughout the year. Subsequently, it also creates a folder on the server with a pdf of the test request. What my co-worker asked is if it possible to put additional paperwork into the folder, when they are submitting a request. When the user clicks on the submit button, it is at this point that folder and pdf are created. Personally, since they get an email that gives them a hyperlink to the folder I don't know how much easier it is to do things through access vs just coping the file manually, but I said I would investigate into this all the same. At this moment the only idea that I have is to create a pop up form that asks for the location of the file and other information so I can copy the file. I realize this could be a coding nightmare, but I am just looking for insight at the moment.
To summarize what I am looking for, I want the user to be able to be able to select a file they desire to be copied into a folder on the server. The folder on the server is information that is stored in my database already, the part I need advice on is the user selecting a file or being able to input all the information needed to transfer a file.
Uncharted Territory
To summarize what I am looking for, I want the user to be able to be able to select a file they desire to be copied into a folder on the server. The folder on the server is information that is stored in my database already, the part I need advice on is the user selecting a file or being able to input all the information needed to transfer a file.
