Im pretty new to Access Databases and am trying to create a form where a user can "upload a file" into access, by upload i envisage a table with the below fields (i may need more) that actually store the path to the file, when the toggle button is pressed and the user browses to and selects a file and clicks ok then Access will move the file to a location on our network (mapped network Drive)
DocumentID (Priimary key)
ClientID
DocumentPath
the form contains the following combo boxes cboCLientName, cboFileType and cboVendor the values selected in these combo boxes are to be used to create the path of where i want the document to be uploaded i.e if
cboClientName.value = Client1234
cboFiletype.value = Licenses
cboVendor.value = Microsoft
this would transpose to J:\Client1234\Licenses\Microsoft\ the file name would be whatever is select when a toggle button labelled "upload and Link" is pressed
As well as this table being populated the file will physically be COPIED from its source location to the above location determined by the combo boxes.
Once i have this form working the next stage is to be able to click on these files paths from other forms as if they are hyperlinks as such
I hope there is someone out there that can help me with this as unfortunately this is not within my skill set at this stage
Thanks in advance
Rhys