Trouble Opening Form the correct size

[KrissyB]

Hi!

i was wondering if anyone could lend a hand on how, when the form is opened, to sepcify its size? it keeps maximizing but I want it to leave another application visible. Also, is there a way to open the form while leaving the access backend invisible? It is a simple application for creating and emailing a spreadsheet.

Thanks for any help anyone can offer!

Chris

 

[Rolliee]

YOu can 'plug' the properties of a form. While I have not plugged size, I see no reason why it could not be done. Send me a zipped file and I will write the code for how to do it.

rollie@bwsys.net

 

[humbleprogrammer]

If you set the forms properties Pop Up to Yes (located under the other tab), it will eliminate the form from maximizing. Also set the Auto Center to Yes, which will position the form in the middle.

To hide the backend follow below steps:

Go to Tools - Startup and Uncheck Display Database Window. Also set the Display Form/Page to the form you want the database to open with.

Hope this helps..

 

[judgehopkins]

In the form you want to open, put the following code in the form's on open event procedure.

Private Sub Form_Open(Cancel As Integer)
   DoCmd.OpenForm "Order", acNormal, _
      "", "", , acNormal
End Sub

Judge Hopkins

http://www.psc.state.mo.us/adjudication.asp

There are only two rules for success: (1) Never tell everything you know.