dbTalk Databases Forums  

access2007 - change 'document window options' using vba

comp.databases.ms-access comp.databases.ms-access


Discuss access2007 - change 'document window options' using vba in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Roger
 
Posts: n/a

Default access2007 - change 'document window options' using vba - 12-13-2010 , 04:37 PM






I'd like to use application.setOption to change the document window
options from 'overlapping windows' to 'tabbed documents'
but online help only provides these options for 'current database'
Compact on Close
Remove personal information from file properties on save
Use Windows-themed Controls on Forms
Enable Layout View for this database
Check for truncated number fields
Picture Property Storage Format

is there a way to change the 'document window options' with VBA ?

Reply With Quote
  #2  
Old   
Roger
 
Posts: n/a

Default Re: access2007 - change 'document window options' using vba - 12-13-2010 , 05:32 PM






On Dec 13, 3:37*pm, Roger <lesperan... (AT) natpro (DOT) com> wrote:
Quote:
I'd like to use application.setOption to change the document window
options from 'overlapping windows' to 'tabbed documents'
but online help only provides these options for 'current database'
* Compact on Close
* Remove personal information from file properties on save
* Use Windows-themed Controls on Forms
* Enable Layout View for this database
* Check for truncated number fields
* Picture Property Storage Format

is there a way to change the 'document window options' with VBA ?
after more digging, it looks like this byte property will do it

currentdb.Properties("UseMDIMode")
1 = overlapping windows
0 = tabbed documents

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.