Search results

What happens is the Switchboard loads the subform (frmCreate). The sub form has several dropdowns which allow you to select Quarter, Year, Product line, State etc. The user then clicks a button which executes Access VBA code. This VBA application interacts with Excel (which has its own VBA code...

I have a switchboard which loads a sub form. When I click a button on the sub form, the focus goes back to the switchboard, and stays there. I want to keep the focus on the sub form throughout the entire process, and only go back to the switchboard when the sub form is closed. How do I do this?

I figured the problem out. Here's my solution: I opened the spreadsheet that was having the problem, and the references were the same (other than release levels) between Excel 2007 and 2010. However, when I went into Excel 2010 with a generic workbook (i.e. “Book1” the user’s spreadsheet not...

I have a large Access VBA application which interacts with Excel. My company is in the process of converting to Windows 7 using Office 2010 from XP and Office 2007. My user was testing and got the following error when the Excel spreadsheet tried to run a regression, "Runtime Error 1004...