Recent content by thisisanemergency

  1. T

    Code to run/rerun progress bar

    and i'm hiding the DB window so they won't see the built-in progress bar.
  2. T

    Code to run/rerun progress bar

    How embarrassing, so simple! Thanks so much :)
  3. T

    Code to run/rerun progress bar

    I'm using a progress bar solution posted by Oldsoftboss: http://www.access-programmers.co.uk/forums/showthread.php?t=130802. The progress bar should indicate progress on a button click event that initiates various queries. The problem I have is that the progress bar only runs once all the...
  4. T

    Bring form to front while hiding main database window

    I finally figured it out! I found the following sources helpful: This shows how to keep your form on top of all other open windows. I used method 3 in the Form Open Event: on vbforums.com - showthread.php?352702-Classic-VB-How-do-i-keep-a-form-on-top-of-others. This shows how to completely...
  5. T

    Bring form to front while hiding main database window

    Thanks for the reply. I have tried Set Focus and still get the same result. The form pops up automatically when the database is opened - I have tried the AutoExec method and also by selecting it as start-up form in database options.
  6. T

    Bring form to front while hiding main database window

    I am trying to achieve opening a form while hiding the main database window (by default). I've got it to work but the form (Pop Up) always opens behind any other non-related windows that are currently open, e.g. when opening the DB from a network folder, the pop-up form sits behind the network...
  7. T

    Export as PDF with variable document name and file path name

    How great is a night in the pub for the brain! I finally got it working, thanks for your help with this. I found though that putting the field on the report didn't work, I had to put a field on the form where my button is located instead.
  8. T

    Export as PDF with variable document name and file path name

    Could it be that while DocSetName is present in my query, I have not used the field in my report?
  9. T

    Export as PDF with variable document name and file path name

    Paul - we're so close I can almost smell it! But now it's giving me "Compile Error: Method or data member not found" and highlights the first instance of Me.DocSetName in the path. I've checked my query and the DocSetName field is there and it has the data in it that I expect to see. I think...
  10. T

    Export as PDF with variable document name and file path name

    Hi Paul Thanks for your response. I have tried your suggestion but I think I'm making an error. This is what I have now after your input. Am I missing something? Private Sub Command6_Click() DoCmd.OutputTo acOutputReport, "RepQryCustName", "PDFFormat(*.pdf)"...
  11. T

    Help with responding to questions posed by update query

    I'm pretty sure it applies to users as well - I've used it in a couple of databases I've deployed and never had anyone come back with questions about warning messages. Though I'm sure the above response will provide a failsafe.
  12. T

    Help with responding to questions posed by update query

    Not sure if I understand you correctly. Are you looking to turn off the warning message you get before something is updated/appended? If so you could go to Access Options > Client Settings > Confirm and untick the boxes.
  13. T

    Export as PDF with variable document name and file path name

    I have searched extensively for a solution but have not come across anything that explicitly refers to my issue and so I've not been able to resolve thus far. I have a query that is filtered through a selection on a combo box and the result populates a report. This works perfectly. I have a...
See more
Back
Top Bottom