Got it... was actually much simpler than I thought it would be. I was able to eliminate the query, and hyperlink table, all together.Private Sub cmdOK_Click()
'Opens Groundwater Trend Charts, first checking if PDF exists
Dim strDocument As String
Dim txtWellID As String
Dim FSO
Set FSO =...
Thanks, it looks like it is working now. I added Dim FSO
Set FSO = CreateObject("Scripting.FileSystemObject")to the declaration section of code, but also had to add a "/" to the end of the file path, being that I did not add a FindFolder or Dir method. But, instead of using a table to open...
Thanks MintJulep. It is giving an error on the lineSet FSO = New FileSystemOBject stating "Compile Error: User Defined Type not defined". This is part of code I copied / pasted from the thread I referenced in my first post. Do I need to declare FSO as something possibly?
thread766-141175
Working off of the thread above, I am trying to have VBA code
1. Open a Select Query, on a Hyperlink field, based on a list box selection ("txtWellID")
2. Check if a PDF file exists for the item in "txtWellID" then
a. Open the hyperlink, or else
b. Display a MsgBox and...
