ACCESS FEED: RE: [MS_AccessPros] Re: my popup sometime opens in that stupid black minimized rectangle

Terence-

There are a number of things that control the way a form looks when it opens.
First, there are these Form properties:

Pop Up -- If you set PopUp = Yes, the form window "floats" on top of all other
windows, including the Access application window. The window opens to the size
it was when you last saved its design unless you also have AutoResize set to
Yes. If you don't have the Modal property set to Yes, you can move the focus to
other windows "behind" the popup, but the popup window will still be on top and
perhaps will cover other windows.

Modal -- If you set Modal = Yes, the window opens as a Dialog, and you cannot
move the focus to any other window until this windows closes. You would
normally set both PopUp = Yes and Modal = Yes to open the form window as a
dialog box.

Default View -- Use this to define the "normal" view for the window - Single
Form, Continuous Forms, Datasheet, Pivot Table, Pivot Chart, or Split Form.
Setting Modal = Yes will keep you from changing the view of the form when it is
open.

Allow Form View -- Lets the user switch to Form View if that is not the "normal"
view.

Allow Datasheet View -- Lets the user switch to Datasheet View if that is not
the "normal" view.

Allow PivotTable View -- Lets the user switch to PivotTable View if that is not
the "normal" view.

Allow PivotChart View -- Lets the user switch to PivotChart View if that is not
the "normal" view.

Allow Layout View -- Lets the user switch into Layout design mode if that is not
the "normal" view. Note that this property was called Allow Design Changes in
versions prior to 2007.

Auto Center -- Opens the form in the "center" of the Access workspace (if not a
popup form) or the Access window (if a popup form)

Auto Resize -- Effectively does a Window / Size to Fit when the form opens.

Border Style -- Set to None to show no border, and no Close Button, Control
menu, Maximize, and Minimize buttons. The form isn't resizable. Note that the
ONLY way to close a form with a None border is to provide a command button to
issue the DoCmd.Close command.
Set to Thin to show a thin border with all buttons. The
form isn't resizable.
Set to Sizable to provide a "normal" border with all
buttons. The form is resizable.
Set to Dialog to provide a thick border with a Control menu
and Close button. The form cannot be minimized, maximized or resized.

Record Selectors, Navigation Buttons, Navigation Caption, Dividing Lines, Scroll
Bars -- These properties turn the related design elements on and off, but are
not affected by the settings of any of the other properties.

Control Box -- When Yes, shows the "control box" in the upper left corner unless
Border Style is set to None.

Close Button -- When Yes, shows the "X" close button in the upper right corner
unless Border Style is set to None.

MinMax Buttons -- Determines which of the Minimize or Maximize buttons show up
unless Border Style is set to None.

Second, there are options in DoCmd.OpenForm:

View -- You can ask for the form to be opened in Design, Datasheet, PivotChart,
PivotTable, Layout, Normal (Form) views or Print Preview. Note that even if the
form's Default View is something other than Form View, Continuous Forms, or
Split Form, the form will open in "Form" view when you use the Normal default
setting. For example, the only way to use OpenForm to open a form in Datasheet
view is to specifically ask for Datasheet in the command.

WindowMode -- You can ask for the form to be opened as a Dialog, Hidden, a
minimized Icon, or "Normal". Specifying Dialog automatically sets the Popup and
Modal properties to Yes. It also stops all code from running until the form is
closed or hidden. Hidden opens the form with its Visible property set to No.
(You cannot set Visible in Design view - only with OpenForm or in Code.) Icon
opens the window minimized on the desktop unless Border Style prevents
minimizing. Normal honors all the form design settings.

Does that help?

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terence
Sent: Tuesday, August 02, 2011 3:07 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: my popup sometime opens in that stupid black
minimized rectangle

Crystal, My default view is split view.

But hold on a moment, "Dialog view: does not show up in the properties drop down
box as an option for a Default View of a Form Format ...??

I thought this thing would be more akin to minimized, maximized, and weird
rectangle thingy ?
Terence

--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...>
wrote:
>
> Hi Terence,
>
> check the Default View property of the form ;)
>
> Warm Regards,
> Crystal
>
> *
> (: have an awesome day :)
> *
>
>
> --- On Mon, 8/1/11, Terence wrote:
>
> > OK, I am out of the water, my popups
> > seem to be holding, but I probably will put "Size" code in
> > the forms to prevent any mishap. HOWEVER.... as Crystal
> > stated "referring to dialog view", so I guess that is what
> > the stupid rectangle is called. I have to now ask...What are
> > the rules, Under what conditions, under what circumstances,
> > does Windows/Office.... decide to present a window in that
> > fashion ?
> >
> > Terence
> >
> >
> >
> >
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com,
> > "Bill Mosca" <wrmosca@> wrote:
> > >
> > > You're welcome, Crystal.
> > >
> > >
> > >
> > > Looks like I fat-fingered another post.
> > <g>
> > >
> > >
> > >
> > > #1 should have read "Access seems to know how to size
> > a form PROPERLY when you
> > > do that."
> > >
> > > #2 should have read "THEN save it."
> > >
> > >
> > >
> > >
> > >
> > > Regards,
> > >
> > > Bill
> > >
> > >
> > >
> > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com]
> > On Behalf Of Crystal
> > > Sent: Sunday, July 31, 2011 12:12 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: RE: [MS_AccessPros] Re: my popup sometime
> > opens in that stupid black
> > > minimized rectangle
> > >
> > >
> > >
> > >
> > >
> > > hi Bill,
> > >
> > > thanks! ... definitely going into the archives ...
> > >
> > > Warm Regards,
> > > Crystal
> > >
> > > *
> > > (: have an awesome day :)
> > > *
> > >
> > > --- On Sun, 7/31/11, Bill Mosca wrote:
> > >
> > > > Terence
> > > >
> > > >
> > > >
> > > > This is what I do to prevent a form from sizing
> > itself
> > > > weirdly:
> > > >
> > > > 1.    I always design in
> > maximized
> > > > size. Access seems to know how to size a
> > > > form property when you do that.
> > > >
> > > > 2.    If a form opens with
> > the wrong
> > > > size I go to (Acc2003) menu>window>size to
> > > > fit form;(Acc2010) Home>window>size to fit
> > form. Ten
> > > > save it.
> > > >
> > > > To make things even easier, I develop with a
> > macro named
> > > > AutoKeys. There is an
> > > > old one in our files section. With it, all I do
> > is press
> > > > Ctrl+B. It does all the
> > > > work in one motion.
> > > >
> > > >
> > > >
> > > > Regards,
> > > > Bill Mosca,
> > > > Founder, MS_Access_Professionals
> > > > That'll do IT <http://thatlldoit.com> http://thatlldoit.com
> > > > MS Access MVP
> > > > <http://mvp.support.microsoft.com/profile/Bill.Mosca>
> > > > http://mvp.support.microsoft.com/profile/Bill.Mosca
> > > >
> > > >
> > > >
> > > > From: Terence
> > >
> > > >
> > > > Well I just went through opening them all up,
> > there are 12
> > > > I think, I re sized
> > > > them all, and save them properly. Close the DB,
> > then went
> > > > for coffee. I came
> > > > back and they all worked but one. So I re sized
> > it. I will
> > > > drink more coffee and
> > > > try again. I think the pattern has something to
> > do with the
> > > > US Congress raising
> > > > the debt ceiling.
> > > >
> > > > :)
> > > >
> > > > I just wished I had a bit more certainty and
> > confidence
> > > > that these windows will
> > > > act as I want them to. This application is being
> > used for a
> > > > Geriatric Physical
> > > > Therapy clicnic, and some of these forms will be
> > used on
> > > > Tablets. I prefer NOT
> > > > having DOCS throw the tablets at patients :)
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com
> > >
> > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > >
> > <mailto:MS_Access_Professionals%40yahoogroups.com> ,
> > > > "buffalome90210"
> > > > <buffalome90210@> wrote:
> > > > >
> > > > > TY Crystal, my mehtod of open is the
> > standard stuff, I
> > > > am using a Macro
> > > > > OpenForm History 3 Meter Walk Test Fast,
> > Form, , , ,
> > > > Normal
> > > > >
> > > > > as far as the properties for the form named
> >
> > > > > "History 3 Meter Walk Test Fast"
> > > > > I have tried about everything, It's NOT
> > MODAL, and it
> > > > is popup.
> > > > >
> > > > > Default view is split with datasheet at
> > bottom
> > > > > Control Box - yes
> > > > > Scroll bars Yes
> > > > > MIN MAX - NONE
> > > > > Close Button - Yes
> > > > > No Navigation Buttons
> > > > > Border style = Sizable
> > > > > Auto center - No
> > > > > Auto resize - yes
> > > > > Fit to screen - yes
> > > > >
> > > > > These are my current settings......The odd
> > thing is ,
> > > > it does not always
> > > > resort to that weird rectangle thingy.
> > > > >
> > > > > And I am unable to predict it, or determine
> > a
> > > > pattern.
> > > > >
> > > > > My pie in the sky solution wouold be to find
> > the
> > > > property that says:
> > > > >
> > > > > Weird Rectangle Thingy = NO
> > > > >
> > > > > Anything obvious ?
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > --- Crystal <strive4peace> wrote:
> > > > > >
> > > > > > Terence... sorry I spelled your name
> > wrong! I
> > > > fixed it ... so no evidence
> > > > but the original post ;) ~Crystal
> > > > > >
> > > > > > --- On Sat, 7/30/11, Crystal wrote:
> > > > > >
> > > > > > > hi Terence,
> > > > > > >
> > > > > > > sorry you are frustrated ... maybe
> > it is
> > > > time to take a
> > > > > > > break -- sometime that is better
> > than
> > > > working so you can get
> > > > > > > your mind fresh again. I
> > need a break
> > > > too ... maybe I
> > > > > > > will go singing tonight ;)
> > > > > > >
> > > > > > > > "ridiculous rectangle"
> > > > > > >
> > > > > > > are you referring to dialog view
> > which make
> > > > a form appear
> > > > > > > as a popup? Please post the
> > procedure
> > > > that opens your
> > > > > > > form so we can see your parameters
> > to
> > > > DoCmd.OpenForm
> > > > > > >
> > > > > > > also, check the following FORM
> > properties:
> > > > > > >
> > > > > > > Default View
> > > > > > > Popup
> > > > > > > Modal
> > > > > > >
> > > > > > > Warm Regards,
> > > > > > > Crystal
> > > > > > >
> > > > > > > *
> > > > > > > (: have an awesome
> > day :)
> > > > > > > *
> > > > > > >
> > > > > > >
> > > > > > > --- On Sat, 7/30/11, Terence
> > wrote:
> > > > > > >
> > > > > > > > Frustrated.
> > > > > > > >
> > > > > > > > I have a popup form with a
> > button. The
> > > > button uses a
> > > > > > > macro
> > > > > > > > to open another popup from.
> > The macro
> > > > uses "normal". I
> > > > > > > have
> > > > > > > > tried a plethora of options
> > on the
> > > > format of this
> > > > > > > form,. yet
> > > > > > > > time after time this stupid
> > form open
> > > > up in that ugly
> > > > > > > > ridiculous rectangle, that
> > confounds
> > > > most people of
> > > > > > > the
> > > > > > > > world on what the hell to do
> > with it.
> > > > > > > >
> > > > > > > >
> > FRUSTRATED~!!!!!!!!!!!!!!!!!!!
> > > > > > > >
> > > > > > > > I want an option, a WAY, so
> > this form
> > > > can NEVER get to
> > > > > > > that
> > > > > > > > state !
> > > > > > > >
> > > > > > > > Terence
> > > > > > > > sorry for my pontifical
> > rhetoric.
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> > MS_Access_Professionals-fullfeatured@yahoogroups.com
> >
> >
> >
>

------------------------------------

Yahoo! Groups Links