Search results

Still having a problem with that. Same error message - failing to connect with OLE or Active X. How do I approach getting rid of all the brackets?

Hello, This is the code: Private Sub Command472_Click() Dim sFilePath As String sFilePath = "W:\Production Documents\1970\" & [Me.[Document Number]] & [Me.[Current Revision]] & [.pdf] \ "" Debug.Print sFilePath Application.FollowHyperlink sFilePath On VBA, it says there is no problems...

Thanks for your help - With that debug it has cleared the issue up. However, I am still having the same problem when I click on the button: "The expression On Click you entered as the event property setting produced the following error: A problem occurred while Microsoft Access was...

Firstly, apologies: I will delete the other one straight away. I've uploaded the error message I am receiving This is the code I have entered: .......................................................... Private Sub Command472_Click() Dim sFilePath As String sFilePath = "W:\\Production...

Hello all, I have 1900+ records, of where each record is represents a PDF Document in my folders. Each document in my folders is named in the same format "2014-001a" for example. This is the combination of two fields in my Access Database - Document Number and Current Revision. I am looking...