Solved

Is using of  "Split Form" in Access 2010 a good idea?

Posted on 2014-04-23
4
2,397 Views
Last Modified: 2014-04-23
Split form behaves unpredictable in its size (not to mention sudden "OLE communication error" messages). It seem to completely disregard width / height properties and always displays very large form with unnecessary scrollbars.
-Desgn.bmp
-form.bmp
0
Comment
Question by:midfde
  • 2
4 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 40017732
is the form in Design view when you are making changes?

see this as reference
http://office.microsoft.com/en-us/access-help/create-a-split-form-HA010341582.aspx
0
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
ID: 40017807
I played around with the form style back in 2007 when it first appeared and decided that it was more trouble than it was worth.  The only advantage I can see of using the "official" format is that you get the splitter which can come in handy.  I just make the form manually by using either two bound subforms or a main form in single record view and a subform in continuous view.

The problem with this technique in a client/server application is that it assumes your form is bound to an open ended query or directly to a table and both are poor practice when your tables are linked ODBC.  You need to pre-filter the records so the user enters selection criteria to reduce the list of records returned.  With that requirement in mind, I find it easier to use two subforms.  One to control the list and the second to edit the record selected in the list subform.
0
 
LVL 1

Author Closing Comment

by:midfde
ID: 40017874
To the point (and without "First turn your computer on").
Thanks, PatHartman.
0
 
LVL 1

Author Comment

by:midfde
ID: 40018096
Although terribly intractable, the Split Form does "understand" the following (unlike Width=...):
DoCmd.MoveSize , , 1440 * 10

Open in new window

This is just in case MS puzzled anybody else with this bug(?).
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now