Recent content by Father Branigan

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

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?

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

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?

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?

Thanks a lot. That worked for me.

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