Can anyone advise please,
I have a word document defined in the variable newfile, this has the following assigned to it: "C:\misc\" & Me![Car_reg].Value & " - " & Me![user_id].Value & "\" & " Change Request " & Me![Car_reg].Value & " - " & Me![user_id].Value
This goes away and copies and existing document and places it in the misc directory, what I now want to do is place some code behind a button to open the copied document, I have been trying the .open method. I just cannot get this to work.
So basically all I would like to be able to achieve is that a user clicks on a button and this button will open the file assigned to the variable newfile.
Once again all help is appreciated
Thanks
K3ith
I have a word document defined in the variable newfile, this has the following assigned to it: "C:\misc\" & Me![Car_reg].Value & " - " & Me![user_id].Value & "\" & " Change Request " & Me![Car_reg].Value & " - " & Me![user_id].Value
This goes away and copies and existing document and places it in the misc directory, what I now want to do is place some code behind a button to open the copied document, I have been trying the .open method. I just cannot get this to work.
So basically all I would like to be able to achieve is that a user clicks on a button and this button will open the file assigned to the variable newfile.
Once again all help is appreciated
Thanks
K3ith