Recent content by skiandy

I am looking for a way to print a pdf from a generated location, I am currently using this code to locate the file. Private Sub Form_Click() Me.WebBrowser186.ControlSource = "=""c:\AGI\" & [Document Number] & ".pdf""" End Sub Please could anyone advise.

The data source which my DB is based upon is updated frequently, however I can not link directly to it so the tables are exported as a .csv then appended into the Entries table. Is it possible to create an append query which matches the [Document Number] and then only Updates / Appends if [Rev...

Is there any way the button could be hidden if the file does not exist?

Thanks, I thought it would execute the command on form load.

No problem, thanks. However it is not updating [FileExists] when I checked the table. The link generated is correct as it opens the file if the file exists in the folder.

Thanks Sneuberg, please find file attached.

Hi Sneuburg, OK I added these lines of code: Private Sub UpdateFileExists() strFileName = Dir("C:\AGI\" & Me.[Document Number] & "*") CurrentDb.Execute "UPDATE Entries SET [FileExists] = " & Len(strFileName) <> 0 & "WHERE [Document Number] = '" & Me.[Document Number] & "'" End Sub...

Hi sorry I'm new to this. [Document Number] is the filename without its extension as the files are .pdf, .doc, .dwg etc. As the file path is generated is there any way that conditional formatting can be applied to highlight if the file exists in C:\AGI\ ? i.e. green for exists / red for...

Hi, please could you help. I was looking at your demo sneuberg and it does exactly what I would like it to do. However my table only contains the filename and I generate the link to the file using the following code:- Private Sub Command7_Click() Dim strFileName As String strFileName =...