PC Review


Reply
Thread Tools Rate Thread

Can't hide Property Sheets

 
 
James
Guest
Posts: n/a
 
      23rd Mar 2010
Software: Access 2007 with 2002/2003 file format.

Goal: Do not show report property sheet during visual basic editing of
report.

Problem: Report property sheet is still appearing when open a report in
design mode in Visual Basic even though use both Echo False and SetWarnings
False

Review of Office Help: The help for “Echo Macro Action” indicates
“The Echo action doesn't suppress the display of modal dialog boxes, such as
error messages, or pop-up forms, such as property sheets. You can use dialog
boxes and pop-up forms to gather or display information, even if echo is
turned off. To suppress all message or dialog boxes except error message
boxes and dialog boxes that require the user to enter information, use the
SetWarnings action.

If taken literally the above indicates that SetWarnings will not hide pop-up
forms such as property sheets. What does?

Example of Code resulting in Undesired Result:
....
DoCmd.Echo False
DoCmd.SetWarnings False
DoCmd.OpenReport "rpt_BO-AllBDActivity", acDesign
....

--
Thanks, James
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Property Sheets Kevin Microsoft Dot NET Framework Forms 0 29th Nov 2007 09:05 PM
Hide all sheets but selected sheets - an example aztecbrainsurgeon@yahoo.com Microsoft Excel Programming 1 7th Apr 2006 06:29 PM
MMC and Property Sheets =?Utf-8?B?c3RldmU=?= Windows XP General 6 21st Jul 2004 01:20 AM
The controls on this property sheet are disabled because one or more other Network property sheets are already open. To use these controls, close all these property sheets and then reopen this one. =?Utf-8?B?Um9iZXJ0?= Microsoft Windows 2000 Networking 1 11th Apr 2004 12:22 AM
property sheets gone! kh Microsoft Windows 2000 0 18th Dec 2003 07:12 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:44 AM.