I have a OLE Object field named oleFile. It is used to store all kinds of application files (I know it is not a good idea to store file in Access, but it is business needed)
I have a button(command 14) when click it activates the file. It does well with all Microsoft products(Word, Excel, Powerpoint, Access, etc.), the PDF files from Adobe Acrobat Reader will stall and require one more click in order to activate it. Does any one know how to detect it is a PDF file in codes? or any other suggestions will be appreciated. Thank you very much!
The code of the click button to activate the file.
Private Sub Command14_Click()
With oleFile
.Locked = False
.Enabled = True
.SetFocus
.Verb = acOLEVerbOpen
.Action = acOLEActivate
End With
I have a button(command 14) when click it activates the file. It does well with all Microsoft products(Word, Excel, Powerpoint, Access, etc.), the PDF files from Adobe Acrobat Reader will stall and require one more click in order to activate it. Does any one know how to detect it is a PDF file in codes? or any other suggestions will be appreciated. Thank you very much!
The code of the click button to activate the file.
Private Sub Command14_Click()
With oleFile
.Locked = False
.Enabled = True
.SetFocus
.Verb = acOLEVerbOpen
.Action = acOLEActivate
End With
