Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access
Im new to vba, please be patient. Thx I've created command buttons in a spreadsheet to open an access mdb's located on a comman drive. I managed to locate and open the mdb's trhu "GetObject" statement. It works for some mdb's, but not all. ON those it doesn't work i can see access opening and then it closes immediatly after opening. The access versions is 97. ON those it managed to open - How can i make it the active window? It opens it but the focus is still on the spreadsheet. Any help appreciated Thanks -- JohnDK ------------------------------------------------------------------------ JohnDK's Profile: http://www.excelforum.com/member.php...fo&userid=7184 View this thread: http://www.excelforum.com/showthread...hreadid=480430 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access
Sounds like you might have unclosed instances of Access still running. Look
in the Task Manager in Windows and make sure no instances of Access are open. Make sure you release all references to Access in your code. You can look at AppActivate for bringing the instance to the front. You can also look in the Automation help file: http://support.microsoft.com/?kbid=167223 Microsoft Office 97 Automation Help File Available on MSL -- Regards, Tom Ogilvy "JohnDK" wrote in message ... Im new to vba, please be patient. Thx I've created command buttons in a spreadsheet to open an access mdb's located on a comman drive. I managed to locate and open the mdb's trhu "GetObject" statement. It works for some mdb's, but not all. ON those it doesn't work i can see access opening and then it closes immediatly after opening. The access versions is 97. ON those it managed to open - How can i make it the active window? It opens it but the focus is still on the spreadsheet. Any help appreciated Thanks -- JohnDK ------------------------------------------------------------------------ JohnDK's Profile: http://www.excelforum.com/member.php...fo&userid=7184 View this thread: http://www.excelforum.com/showthread...hreadid=480430 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
Access data -work in Excel- save in Access | Excel Programming | |||
Getting Access Error Messages when running Access through Excel | Excel Programming |