opening a form in a new window (access 2007)

[Guest]

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.

 

[Joe]

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

 

[Guest]

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).

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

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.

 

[Joe]

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

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).

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



message

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.

 

[Guest]

Joe,
That is what I needed. Thank you very much for your kind help.

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

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).

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



message
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.

 

[Joe]

dlazenby,

Glad to help.

Joe

Joe,
That is what I needed. Thank you very much for your kind help.

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

message

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).

:

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



message
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.