LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Automating MS-Access DB to open correctly

Using Office 2003 and Windows XP.

I have a loading program that is designed to open an Access DB and then
Excel closes itself. It works, but when Access opens, the initial window is
small, then it maximizes, but the Main Menu remains the size of the small
window that initially opened.

So every time this runs, the users will have to resize this tiny menu so
they can see everything.

Does anyone have a clue how to fix this?

My code:

Dim oAccessApp As Object
Set oAccessApp = GetObject(csFullNameDestin, "Access.Application")
oAccessApp.Visible = True
oAccessApp.DoCmd.RunCommand 10 '10 = acCmdAppMaximize

Thanks much.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel 2007 doesn't open correctly DBF file blasito Setting up and Configuration of Excel 0 March 1st 11 01:52 PM
Open HTML file, but doesn't copy correctly Kmason5727 Excel Worksheet Functions 0 October 24th 08 04:47 AM
Macro to open files isn't updating correctly telewats Excel Discussion (Misc queries) 2 February 21st 06 09:04 PM
Automating Access / Excel with batch file Art Excel Programming 2 July 1st 05 11:02 PM
Automating Access from Excel quartz[_2_] Excel Programming 2 May 11th 05 09:36 PM


All times are GMT +1. The time now is 11:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"