Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access Automation from Excel
Cannot Do that. The Requirement is very clear on this. Need to run with existing Access code i.e either by user running form or by automated through excel.- aniphilip
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access Automation from Excel
The command button has the click event coded to import an Excel sheet into the table. The most trickier is closing the MsgBox. it is a modal dialogue and code will hang there for user input. How to close it automatically ?- aniphilip
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access Automation from Excel
The Requirement in Simple Terms is 1) Open Access from Excel (Done) 2) Open Access Form (Done) 3) Initiate a Command Button Click Event( To be done) 4) The Command Button Will pop open a MsgBox Dialogue. This need to be close from Excel( HandsFree) 5) Close Access (Done)- aniphilip
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access Automation from Excel
Hi All, I have a requirement to automate Access functionality from Excel. I need to open Access, trigger button events and close Access from Excel. I Achieved opening Access from Excel. I cannot find a way to trigger a button click event from Excel for an Access form. To be more precise, I...- aniphilip
- Thread
- Replies: 8
- Forum: Microsoft: Access Modules (VBA Coding)
