Recent content by Dangerous

I had used it many times but then had no call to. That was maybe 3 months ago. I have no need to upgrade Access as this does all I need. DB isn't coded very well, I'm new to it but it worked. Windows 10 etc goes through the normal MS updates. I can only assume that doing the minor alteration to...

I created a database a while back, not needed to use it for a while. It worked really well but for some reason if I run the database and go to the main data entry page I use and click on one of the predefined search buttons, or the goto last/first record buttons Access will cease to respond...

If you can disable the Close Access X then write a bit code assigned to a button tucked away elsewhere on the form which when clicked calls up a msgbox asking if they wish to close the DB. If Y then run the close routine and any other key cancels the close action.

Wouldn't have without your help. Thanks and thanks for the input from everyone else.

I spotted the errors by adding a hyperlink field and assigning the strPDFfile variable to it. I then saw what was happening and corrected the errors. I'm learning, slowly but learning. Thanks again.

Thanks for all the help everyone.

Yeah realised that but it still didn't work till I change it to Private Sub Label1689_Click() Dim strPDFfile As String strPDFfile = "D:\MDF Database\Images" & PDFfile Application.FollowHyperlink strPDFfile End Sub PDFfile (controlname) instead of strPDFfile. Works fine now.

Got you now. Private Sub Label1689_Click() Dim strPDFfile As String strPDFfile = "D:\MDF Database\Images" & "strPDFfile" Application.FollowHyperlink "d:\MDF Database\Images\FileName.pdf" End Sub

It reads D:\MDF Database\Images\strPDFfile

I have no idea how to find that out.

The reason I wanted to do it this way is so I could search the directory, select the file, and have it automatically store the file address. I wonder if I could do that in to a hyperlink control. Will have a go.

Yes, this works fine Application.FollowHyperlink "d:\MDF Database\Images\FileName.pdf" but any record that needs a pdf linked to it will have its own specific file so hard coding not an option.

Variable is strPDFfile and control is just PDFfile.

Testing with a file called FileName.pdf so the control contains FileName.pdf

Didn't work, runtime error 490, couldn't open file.