eversearching35
October 14th, 2008, 05:34 AM
Hello All,
I have built an access database and I want to reference foxit instead of the adobe reader since multiple people will have access to this database.
I ran into a problem with the vba code. Here is what I have:
Private Sub ViewPDF_Click()
Shell ("\\Office\Program\Workgroups\Configuration Management\Database\foxit\foxitreader " & "Office\Program\Workgroups\Configuration Management\Database\PDFs\" & Me.Authority & ".pdf")
End Sub
This works if I remove the space between "Configuration Management" but I can't change the server structure. Can I reference spaces in the file name and location?
Thanks,
Drew
I have built an access database and I want to reference foxit instead of the adobe reader since multiple people will have access to this database.
I ran into a problem with the vba code. Here is what I have:
Private Sub ViewPDF_Click()
Shell ("\\Office\Program\Workgroups\Configuration Management\Database\foxit\foxitreader " & "Office\Program\Workgroups\Configuration Management\Database\PDFs\" & Me.Authority & ".pdf")
End Sub
This works if I remove the space between "Configuration Management" but I can't change the server structure. Can I reference spaces in the file name and location?
Thanks,
Drew