Benny Wong
Registered User.
- Local time
- Today, 05:36
- Joined
- Jun 19, 2002
- Messages
- 65
Hello All,
I am using Access 2000. I currently have a form that has three buttons. The three buttons are:
cmdClickme = TransferSpreadSheet
cmdstep1exit = Quit Application
cmdReturnToMainMenu = Return to Main Menu
The purpose of the form is to allow the user either click the cmdClickme button to transferspreadsheet to C:\tblclientblank.xls or click cmdReturnToMainMenu to return to Main Menu.When the process is done another button shows up which allows the user to exit the application. The last button allows the user to return to main menu if the button cmdClickme is not depressed.
My problem is when the cmdClickme is depressed the TransferSpreadSheet works and the cmdstep1exit does show up but the cmdclickme with the cmdstep1exit. I would like the cmdclickme to be invisible however VBA says the cmdclickme has the focus. How can I correct this problem? Thanks in advance for your assistance or advice.
I am using Access 2000. I currently have a form that has three buttons. The three buttons are:
cmdClickme = TransferSpreadSheet
cmdstep1exit = Quit Application
cmdReturnToMainMenu = Return to Main Menu
The purpose of the form is to allow the user either click the cmdClickme button to transferspreadsheet to C:\tblclientblank.xls or click cmdReturnToMainMenu to return to Main Menu.When the process is done another button shows up which allows the user to exit the application. The last button allows the user to return to main menu if the button cmdClickme is not depressed.
My problem is when the cmdClickme is depressed the TransferSpreadSheet works and the cmdstep1exit does show up but the cmdclickme with the cmdstep1exit. I would like the cmdclickme to be invisible however VBA says the cmdclickme has the focus. How can I correct this problem? Thanks in advance for your assistance or advice.