Re: opening a form in a new window (access 2007)
- From: "Joe" <joe90026@xxxxxxxxxxxxx>
- Date: Wed, 7 Mar 2007 20:59:09 -0800
Hi,
You can set the Border Style to Dialog in the form properties.
In the Form_Load event you can set the size and location of the
form:
Me.Move 200, 100, 4000, 6000
HTH,
Joe
"dlazenby" <dlazenby@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5B2674EE-B4EA-4EAB-8F28-C320069F7C54@xxxxxxxxxxxxxxxx
Joe,
Thanks for your response.
I don't want a resizable window.
I don' t understand why I there is not some option/code for the
form to:
1. open in a new window
2. set that window size (horiz, vert)
3. designate the screen location that the window opens in (X,
Y).
"Joe" wrote:
dlazenby,
To save the size of your pop up form you need to restore the
window size. Then make it the size you want and make sure
that
you save the form before you close it (Access won't ask you if
you want to save the changes).
To have the form open in a particular spot you can use the
[Form].move method.
I will whip up some sample code on it if you want.
HTH,
Joe
"dlazenby" <dlazenby@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:7E763267-7A4F-4866-860B-285A2697D296@xxxxxxxxxxxxxxxx
I have several lookup tables used for drop-down choices in
other
tables. I
would like to be able to add records/"choices" to the lookup
table on the
fly. My question has to do with opening that form in a new
window of a
defined size and location.
The lookup table is MedsNameLookupTbl. It consists of only
one
field:
MedsNameChoices (records- e.g., aspirin, tylenol,
penicillin,
etc.).
I have created a form MedsNameLookupFrm to add to/populate
the
lookup table
(i.e., add new drugs to the list on the fly without having
to
go directly to
the table). It contains the single field MedsNameChoices. No
header/footer.
View is continuous; Auto center-no, auto resize no, fit to
screen-no; Border
style- resizable; Form width 4 inches.Detail height 0.2.
When I set the form to pop up, it will give me a narrower
screen in a new
window but the height is full screen. If I don't set it to
popup it gives me
full screen-vert and horizontal.
I know I can resize the form in form view, close the window
and
the next
time I open that form it will be that size (but not a new
position if
repositioned), but it can also be resized and sometimes the
size changes
without apparent (to me) reason. I don't like this approach.
I would like to be able to set the popup window to a fixed
size, say 4
inches wide by 5 inches high, and position it at a certain
place on the
screen.
Please advise.
.
- Follow-Ups:
- Re: opening a form in a new window (access 2007)
- From: dlazenby
- Re: opening a form in a new window (access 2007)
- References:
- Re: opening a form in a new window (access 2007)
- From: Joe
- Re: opening a form in a new window (access 2007)
- From: dlazenby
- Re: opening a form in a new window (access 2007)
- Prev by Date: Re: Is there a way to move the expand "+" sign?
- Next by Date: Re: Default value for a check-box
- Previous by thread: Re: opening a form in a new window (access 2007)
- Next by thread: Re: opening a form in a new window (access 2007)
- Index(es):
Relevant Pages
|
