minimize

[daneo2k3]

hi i have a link in my database which takes you to a file in word. when you close this access is minimized how can i have it permanantly maximized??? any help much appreciatted. dane

 

[rockman]

Dane, I too have an Access database that opens a Word file (actually a Word template), but my Access window doesn't minimize upon closing the Word document.

I would check to see if there is any code in the Word VBA that might be causing this.

Also, does the Access window minimize when you open the Word document or only upon closing the Word document? If it is upon closing I would also check your MS Access VBA to see if there is a minimize command under the Got Focus, Current, or Activate events.

Good Luck,
Jeff

 

[Mile-O]

It's not something I do with Access (meaning: I haven't tried it ) but if you are using the Shell command then you can specify the WindowStyle when you open another application.

 

[daneo2k3]

as soon as i open the word document access is minimised? how do i view the whole access VBA and wrod VBA?

 

[rockman]

View Word VBA by: Tools->Macro->Visual Basic Editor

View Access VBA by: Tools->Macro->Visual Basic Editor

Since Access minimizes upon opening the word document, I suspect there is a minimize code in your Access VBA. When you said "i have a link in my database" I presume this means you have a button that opens the word document. Put a break point on the first line of the OnClick of the button and step through the procedure looking for the minimize command.