Search results

  1. F

    What events fire on Access form F5 refresh?

    I have a textbox that is populated with either "File is Available" or "File is Not Available", depending on whether a certain file is present in a specific folder. Since other users can drop the file into the folder without the Access user's knowledge, I would like the Access user to be able to...
  2. F

    What events fire on Access form F5 refresh?

    Do any form events fire when a user presses F5 to refresh? Otherwise, is there a way to capture the user pressing F5 so that I can run some code?
  3. F

    Pop up an Excel MsgBox from Access VBA

    I have been using the method to minimize Excel, show the msgbox, and then maximize Excel. excel_app.WindowState = xlMinimized MsgBox "This Excel file does not fit the standard format." excel_app.WindowState = xlMaximized It's workable, but I just figured there has to be a way to...
  4. F

    Pop up an Excel MsgBox from Access VBA

    Hmm, the problem is that the user is always processing new files that they get from another party so I don't think I'll be able to embed code in the Excel sheet. Can I use Access VBA to embed a macro in the Excel sheet?
  5. F

    Pop up an Excel MsgBox from Access VBA

    I have VBA code in Access to open an Excel spreadsheet, modify, etc... That's all working fine. When I create a MsgBox, the box pops up in the Access window (which is now obscured by the Excel sheet that's now in front). Is there a way to pop up the msgbox in Excel so that the user will see it?
  6. F

    Runtime error: The database has been placed in a state by user ...

    Thanks a lot. That worked for me.
  7. F

    Runtime error: The database has been placed in a state by user ...

    Did you ever find a solution for this? I am experiencing the same thing.
Back
Top Bottom