473,471 Members | 1,995 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

For split form, how to I add a Text Box with label in form & control in datasheet?

14 New Member
For a Split Form, how do I add a Text Box with the label in form above & the control in the datasheet below?
I can start over and use the wizard, but to edit an existing split form, to add a field from the field list, I drag and both label and control end up above the split or both below. MS Help says one goes one place and the other goes the other, but it doesn't seem to work. Any help would be appreciated

thx
cb
Apr 19 '11 #1

✓ answered by mshmyob

Chris you probably won't like this answer but here goes...

As you know split forms were introduced in AC2007. They are simply a form with a "special" type of subform that is always set to datasheet mode and moves the main form data to match the selected "subform" data.

As you may have noticed there are major limitations to the split form:

1. You have no control over the appearance of the subform
2. You cannot edit the subform (it doesn't even show in the form or in the object list)
3. The "Me" reference does not work in this type of subform and you must always fully reference any control in the subform or Access pops up an error.
4. Adding coding behind the subform is next to if not impossible.

To accomplish the exact same thing with no limitations you can just use a standard subform.

The only reason I can think why M$ even included splitforms was so a beginner developer wouldn't have to answer 3 or 4 questions in the standard subform wizard.

cheers,

3 4396
mshmyob
904 Recognized Expert Contributor
Chris you probably won't like this answer but here goes...

As you know split forms were introduced in AC2007. They are simply a form with a "special" type of subform that is always set to datasheet mode and moves the main form data to match the selected "subform" data.

As you may have noticed there are major limitations to the split form:

1. You have no control over the appearance of the subform
2. You cannot edit the subform (it doesn't even show in the form or in the object list)
3. The "Me" reference does not work in this type of subform and you must always fully reference any control in the subform or Access pops up an error.
4. Adding coding behind the subform is next to if not impossible.

To accomplish the exact same thing with no limitations you can just use a standard subform.

The only reason I can think why M$ even included splitforms was so a beginner developer wouldn't have to answer 3 or 4 questions in the standard subform wizard.

cheers,
Apr 20 '11 #2
Chris Brown
14 New Member
mshmyob
Thanks. Better to know the truth than to wallow in frustration. Seemed like quite a bit of erratic behavior but I am new to this so I always question myself first.
Apr 21 '11 #3
mshmyob
904 Recognized Expert Contributor
You're welcome. If you need help emulating the split form functionality with a standard subform just let us know.

cheers,
Apr 21 '11 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: pizzy | last post by:
PROBLEM: I CAN'T GET THE LAST RESUTS TO WORK CORRECTLY. I WOULD PROVIDE THE CODE (AND WILL IF REQUESTED). BUT IN MY OWN WORDS I AM TRYING TO HAVE THE FIRST FORM DYNAMICALLY CREATE INPUT BOXES...
2
by: Hareth | last post by:
i got the idea "form.textbox.text = label.text" from vb... i tried it in C# but it generated errors i found a diff example from :...
1
by: Luminal | last post by:
greetings is it possible to change the back color of text on the groupbox control? I change the back color property of groupbox but the label's text back color stay the same (grey). If it is...
0
by: Ron | last post by:
Hi All, If utilized as a sub-form, the ControlTip Texts of all the labels (you know...you can hover the mouse over either the control itself, or the label for that control) flickers like crazy. ...
3
by: sheenaa | last post by:
Hello friends, I m using ASP.NET with C# 2005 and SQL SERVER 2005 for the ASP.Net Website. I m using sqldatasource to connect and retrieve the data from database and then it displays the data...
5
by: Yohan Blurp | last post by:
Hi, Here is sample page to show you the problem : <html><body> <form action="/cgi-bin/test.cgi" method="post"> Data Path : <input type="text" size="50" value="C:\Test Data\May 2007.xls"...
3
by: bhanubalaji | last post by:
hi, I am unable to disable the text(label) in javascript..it's working fine with IE,but i am using MOZILLA.. can any one help regarding this.. What's the wrong with my code? I am...
2
by: nduerr | last post by:
I am looking for the VB code to switch the way a form opens on click event. Specifically I have a form created with a default split view setting. I would like to open this form in single form...
9
by: =?Utf-8?B?RnJhbmsgVXJheQ==?= | last post by:
Hi all I have a MDI Container Form, with one label control on the Background of this container form. When I now open a child form, this form is behind the label ... and this looks ugly ... :-))...
1
by: metalforever | last post by:
How do you redirect a form after submit(form sends email) ? This is pretty urgent for me. I have included the code in a pastebin. http://pastebin.org/249014 process_form sends the email. ...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.