I have a database that is basicly a list of files in a directory. I want the user to enter in a model number(one of my fields) then click a button and a form opens with the records that match, The format of these files are pdf. I have a button on the results form that opens Adobe reader. But even when I hard code a file name it will not open, it says “file does not exist” I know it exists(if I go to the folder and click on the file it opens just fine. I need to tell Acrobat reader to open aspecific file. Below is my code for what I have
Private Sub cmdOpenGram_Click()
Dim strGram As String
strGram = “\\Mee_pdc\Home\Dennis\gram program\grams\a-a-092.pdf”
Call Shell(“D:\Program Files\adobe\reader\acrord32 & strGram”, vbMaximizedFocus)
End Sub