Open form certain size and certain part

  • Thread starter Thread starter babs
  • Start date Start date
B

babs

I have a command button that opens a given form Employees Schedule-
I only want to see the lower bottom part of this form and show it at the
bottom of the present form(Look ahead list) I am on.

The Employee Schedule has a list of employees and list of jobs that have all
kinds of code in queries that make them specifice to the form they are on but
I want to SEE them - have them showup at bottom of (Lookahead List form)
can't copy and past lists because of query code refrerencing controls on
Employee Schedule(works great for it)

Thinking I should OPEN form with command button - Is there a way to show the
Employee schedule form and have it scrolled down to the lists I care
about(thinking shouldn't open maximized) - is there a way to tell it what
size to open up as and what part of the form to be displaying?????
Thanks,
Barb
 
You could use the MoveSize function on the On Open event of the form or in
your code. That will place the form where you want it and size it. Just make
sure that all your users have the same screen resolution or set it to the
sizing for the user with the least resolution. I'm not necessarily talking
about screen size, but rather the number of pixals they display.

You could then set focus to a text box or something on the form to move to
that part of the form. I've really never tried that so I'm not sure that it
will work. I usually avoid scroll bars on my forms and rather use tabs
instead.
 
I have the code below tied to a command button - I would like the "Jeff
Employee Info with Sched using for weekend" form to open up ON top off the
current form at a cerain size and area of the form - with the below code it
is opening up maximized???

Private Sub Command28_Click()
On Error GoTo Err_Command28_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Jeff Employee Info with Sched using for weekend"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.MoveSize 1440, 2400, 1440, 2000

Exit_Command28_Click:
Exit Sub

Err_Command28_Click:
MsgBox Err.Description
Resume Exit_Command28_Click

End Sub

Jerry Whittle said:
You could use the MoveSize function on the On Open event of the form or in
your code. That will place the form where you want it and size it. Just make
sure that all your users have the same screen resolution or set it to the
sizing for the user with the least resolution. I'm not necessarily talking
about screen size, but rather the number of pixals they display.

You could then set focus to a text box or something on the form to move to
that part of the form. I've really never tried that so I'm not sure that it
will work. I usually avoid scroll bars on my forms and rather use tabs
instead.
Click to expand...

thanks soo much,
Barb
 
Back
Top