Search results

  1. D

    Weird Problem (to me anyway)

    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...
  2. D

    Weird Problem (to me anyway)

    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...
  3. D

    Stop Users Closing Access when a form or report it open.

    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.
  4. D

    View a PDF from Access

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

    View a PDF from Access

    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.
  6. D

    View a PDF from Access

    Thanks for all the help everyone.
  7. D

    View a PDF from Access

    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.
  8. D

    View a PDF from Access

    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
  9. D

    View a PDF from Access

    It reads D:\MDF Database\Images\strPDFfile
  10. D

    View a PDF from Access

    I have no idea how to find that out.
  11. D

    View a PDF from Access

    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.
  12. D

    View a PDF from Access

    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.
  13. D

    View a PDF from Access

    Variable is strPDFfile and control is just PDFfile.
  14. D

    View a PDF from Access

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

    View a PDF from Access

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

    View a PDF from Access

    I noticed that but the code still didn't work. I can add the file as a hyperlink and that does work.
  17. D

    View a PDF from Access

    I have several records that I would like to add a pdf file to. On clicking a button I can get the file to open externally (Adobe reader) but only if the file name is in the code. How would I get it to open the filename that is stored in a form control? This code works Private Sub...
  18. D

    Question Export To Pdf And Copy To Clipboard?

    Never used it, used Cutepdf for so long now it's become a habit so never looked for another way.
  19. D

    Question Export To Pdf And Copy To Clipboard?

    There's a small program available free called CUTEPDF. You run the program and it sets its self up as a printer. Then anytime you want you 'print' the document selecting CUTEPDF instead of your physical printer, a box pops up in which you name the file and where you want it saved. Simple to use...
  20. D

    Creating a text box similar to a combo box

    I'm new to Access and I started using Dlookup/Lookup which worked. Then I was shown how to use combo boxes and found them so much more flexible and easier. They can be set so that the user can only select data that is in the list or by using a NotInList event you can add a new item to the list...
Top Bottom