Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switch to Access
Hi
I need to give access the focus from excel but i also need to load a form, that is not in the startup properties of access. I can do this with hyperlinks but am wondering if there is a nicer way to do this. Thanks Stuart. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switch to Access
Stuart
Another way is to automate Access. Here's an example - you need to set a reference (Tools - References) to the Microsoft Access x.x Object Library. Dim AcApp As Access.Application Sub ShowAccFrm() Set AcApp = New Access.Application AcApp.Visible = True AcApp.OpenCurrentDatabase "C:\Dick\db1.mdb" AcApp.DoCmd.OpenForm "Form1" End Sub -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Stuart" wrote in message ... Hi I need to give access the focus from excel but i also need to load a form, that is not in the startup properties of access. I can do this with hyperlinks but am wondering if there is a nicer way to do this. Thanks Stuart. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Switch First and Last Names | Excel Worksheet Functions | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
How do I switch from one worksheet to the next without using the . | Excel Worksheet Functions | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
Can You Switch Rows | Excel Discussion (Misc queries) |