Search results

  1. C

    VBA and corrupt PDFs

    It seems I can download and run .net framework on a server that IT gave us (and has Access/VBA installed)... now what? Thanks!
  2. C

    VBA and corrupt PDFs

    Thanks - I'll ask IT guys...
  3. C

    VBA and corrupt PDFs

    I am first converting regular scanned pdfs to searchable PDFs (using 3rd party software) and then searching for certain words. During the conversion process every once in a while, it will create a corrupted PDF. Out of my control, but I do want to be able to test for it before searching for the...
  4. C

    VBA and corrupt PDFs

    Any other suggestions very welcome please! Thanks!
  5. C

    VBA and corrupt PDFs

    Thanks. Any non-native things (like I’m guessing Python might be) would be hard to get approval for @ my company.
  6. C

    VBA and corrupt PDFs

    Hello - I have a process that manipulates PDFs in Access VBA using the Adobe reference, etc. The problem is that when a PDF file is corrupt, it doesn't "crash" normally... rather Adobe will prompt me regarding the bad file and then only when I manually close the file / Adobe, Access will THEN...
  7. C

    Form design in accde

    I change item sizes and visible settings mostly I think.
  8. C

    Form design in accde

    Hi - rather than have 2 versions of a form depending on the type of project we're running, in my accdb file, I modify the design of the form in VBA ( I open the form in design view) and then open the form in normal view. But accde doesn't allow form design in VBA (I think). Is there any way...
  9. C

    Convert PART of PDF page to jpeg?

    EDIT: I think maybe Acrobat DC (the pro version) is not recognizing the code I'm using. Here's a link to similar code that's also not now working: https://myengineeringworld.net/2013/03/vba-macro-to-convert-pdf-files-into.html Here's some code that used to work for me but now I get an error...
  10. C

    Convert PART of PDF page to jpeg?

    Actually, for now, I'll even take just saving out a PDF page to a jpeg
  11. C

    Convert PART of PDF page to jpeg?

    Anyone have code to convert just a part of a PDF page to a jpg file? I know the PDF coordinates within the page I want to save. Thanks!!!
  12. C

    On Event Click Error 400

    Good to know!!!
  13. C

    On Event Click Error 400

    That seems to be it - it was stopping and ACCDE didn't know what to do. Sorry!!!
  14. C

    On Event Click Error 400

    Hold on... it might be the STOP in the code that I meant to add more logic to...
  15. C

    On Event Click Error 400

    Can't walk the code in accde file unfortunately. Just accdb where I can't (yet) re-create the error.
  16. C

    On Event Click Error 400

    Things get as far as "Call subShowMessage("Running report: " + pReportName, "Report")" at least I know that - because that calls a pop-up that does show up just fine.
  17. C

    On Event Click Error 400

    Thanks. Option Explicit I always add. Compiles fine too. I recompiled accde file and the code ran fine one time. I click on another record and go back to original record, click the button, and it fails again. On event... Private Sub btnCreateReport_Click() Dim sReportName As String...
  18. C

    On Event Click Error 400

    Hi - getting the above error but only in the accde version (so I don't know where VBA is broken). In full accdb file, no problem. I confirmed all References are good. Suggestions please?
  19. C

    Hiding Navigation

    Hi - using this code below which works for me, but only partially works for others on my team (ribbon and system objects are hidden, but navigation pane is still visible). Any suggestions? DoCmd.ShowToolbar "Ribbon", acToolbarNo 'hides ribbon DoCmd.SelectObject acMacro, "AutoExec", True...
  20. C

    The data has been changed error

    Thanks - I had some SQL but commented it out for now... still getting the error. Edit: I rechecked and cleaned out some other SQL and I think that may be it!
Back
Top Bottom