Search results

  1. V

    Comparing two tables to see if there is any match

    You don't understand what was explained. Table A to match Table B Table A has the following policy numbers: 1234 1234 1879 6766 1234 Table B also has the following duplicate policy numbers: 12340000 12340000 67660000 12340000 45900000 98000000 Get the unique/distinct policy numbers in...
  2. V

    Why there's a Type-Mismatch?

    I suspect that Shape_Sheet is not a normal worksheet so you will need to use the Sheets collection, not Worksheets: SourceFile.Sheets(SlideNshapes!Shape_Sheet)
  3. V

    Export from MS access to PDF with set variables from a the opened form

    You're welcome!
  4. V

    Export from MS access to PDF with set variables from a the opened form

    Replace the blue bits with the correct name of the field that uniquely identifies each record: Private Sub Save_to_PDF_Click() Dim myPath As String Dim strBookmark As String With Me myPath = "Z:\(P) Maintenance\Hamilton Jet Planned Maintenance\Jobs\" myPath...
  5. V

    Export from MS access to PDF with set variables from a the opened form

    Is the button on the same form from which the pdf is generated?
  6. V

    Show/Hide navigation pane via VBA?

    You missed the VBA part ;) http://lmgtfy.com/?q=access+show+navigation+pane+%2B+vba&l=1
  7. V

    Export from MS access to PDF with set variables from a the opened form

    Ok, I see the problem. There's a typo: Public Function StripInvalidChars(TheString As String) As String Dim varChars As Variant Dim x As Integer Const INVALID_NAME_CHARS As String = "\ / : * ? "" < > |" varChars = Split(INVALID_NAME_CHARS, " ") For x =...
  8. V

    Export from MS access to PDF with set variables from a the opened form

    Defeats the whole purpose.
  9. V

    Export from MS access to PDF with set variables from a the opened form

    Good to hear! What was the slight tweak?
  10. V

    Export from MS access to PDF with set variables from a the opened form

    It would indicate that none of those textboxes are returning values. And I hope you didn't remove the "Me." reference that I put in there?
  11. V

    Export from MS access to PDF with set variables from a the opened form

    You're printing to a pdf, hence the word "print". One doesn't only print to a printer. Whether you print to a pdf or print to a printer, a report is best placed for this type of job. Have you tested the code I sent?
  12. V

    Export from MS access to PDF with set variables from a the opened form

    In the future, always mention all of the following: * the full error message * which line it highlights * and where the code was placed. Private Sub Save_to_PDF_Click() Dim myPath As String Dim myFormName As String myPath = "Z:\(P) Maintenance\Hamilton Jet Planned...
  13. V

    Export from MS access to PDF with set variables from a the opened form

    Where's it being used?
  14. V

    Export from MS access to PDF with set variables from a the opened form

    What whole line? Be more descriptive.
  15. V

    Runtime error on changing selection

    I understand that. Can you see a pattern? Does it stop when an "Enabled" property is called? Or when a property of a particular type of control is called?
  16. V

    Runtime error on changing selection

    Going back to your code, it errors/stops at this line right: Me.SubFrmDepositTransactions.Enabled = False Comment out this line and the line after it, then re-run the code step-by-step by putting a breakpoint at the first line.
  17. V

    Runtime error on changing selection

    Ok, it's still worth splitting it but it's not a big issue for single use. Try the above without missing a step and let me know how it pans out.
  18. V

    Runtime error on changing selection

    And how many users do you have? Is your db split?
  19. V

    Runtime error on changing selection

    Similar structure or the same structure? Here's another suggestion: 1. Create a new blank db 2. Use the Import/Export wizard to import all the objects from the problem db into the new db - don't copy and paste. 3. Debug > Compile... fix any reference issues 4. Save 5. Compact & Repair and re-test.
  20. V

    Abort filter that results in empty recordset

    @Andy.T, You could also look into the Filter event as well. I don't remember which one comes first, the ApplyFilter event or the Filter event. But of course try all the suggestions above before looking into this.
Back
Top Bottom