Split Form Issue

[Skip Bisconer]

I have a form to input to a table with only three columns of data and when I run this form it opens in full screen. I tried to use the docmd.movesize to no avail. Then I set the popup property to yes with the docmd. movesize and I get an "Invalid outside procedure" noticeon loading which, when bypassed, opens the form in full screen. Am I missing something or does the split form always open in full screen?

 

[rainman89]

Are you using tabbed forms or overlapping windows?

 

[Skip Bisconer]

No just a regular single split form.

 

[boblarson]

No just a regular single split form.

Skip:

In Access 2007 you are either using overlapping windows or tabbed document format. See here on how to change from tabbed format to overlapping windows (like the older versions).

 

[rainman89]

What are these "split forms" that people keep saying? I'm confused

 

[boblarson]

What are these "split forms" that people keep saying? I'm confused

Ray:

A split form is one new 2007 creation where it will, based on your recordsource, have it show two views of your data. The first is a datasheet which shows all records of your recordset. The other is a single view of whichever record has been selected, so you can edit it.

The benefit also includes that you don't have to have all of the fields showing in the datasheet and then you do your update in the single form view for the individual record. And it is all synched automatically by Access.

 

[rainman89]

Ray:

A split form is one new 2007 creation where it will, based on your recordsource, have it show two views of your data. The first is a datasheet which shows all records of your recordset. The other is a single view of whichever record has been selected, so you can edit it.

The benefit also includes that you don't have to have all of the fields showing in the datasheet and then you do your update in the single form view for the individual record. And it is all synched automatically by Access.

Had been using access 2007 for over a year, 2010 now, and have never noticed that before.. Thanks Bob..

 

[boblarson]

Had been using access 2007 for over a year, 2010 now, and have never noticed that before.. Thanks Bob..

I have this on my quick tutorials too, that might interest you.

 

[rainman89]

I have this on my quick tutorials too, that might interest you.

Yeah I can see it has some major advantages and it would have been great for one of the older databases that I built..... oh well!!

 

[Skip Bisconer]

I had my database set to tab view and changed it to Overlapping widows rebooted the database and it still opens to full screen. I have my min/max property enabled but it will not minimize, just stays maximized. I have now set it back to tab documents.

 

[boblarson]

tabbed documents will open basically full screen.

In order to change to the other not full screen, you need to set overlapping windows, then go into form view and resize your window to the way you want it (make sure that auto resize is set to NO) and then click the SAVE button so it will save the size of the window.

 

[Skip Bisconer]

Thanks Bob,

I am now able to use the docmd.movesize so the form is looking good. I have another problem with vba so will go to that forum. Thanks to all of you for your valuable input.