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

Ty John, that was an excellent summary.

In my continuation of this issue, I have found some isolated reported incidents of the popups doing similar unpredictable behavior.

I realize that trying to chase and trap this is more a moot point, and what I really want is a technique that will prevent my popups from going into that rectangle thingy.

Once solution of course would be to place code in the "On Load event to force size".

These particular forms may well be used on tablets which I have no control over resolution, orientation or dimension. It is therefore most desirable that I allow sizing to take place.

This will probably be my last post on this particular issue, as Size code in the On Load should do the trick. However! I personally am convinced, that there is still something unknown, or odd, or perhaps not CERTAIN, that in access 2007 windows 7, that a popup form will resort to its most recent sizing and placement......Its just not something I would bet on.

TY John, Crystal, and the others who have assisted me in this one....If I find more substantive info I will write again on this subject.

Thanx
terence

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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
>