473,554 Members | 3,115 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Adding forms on tab control

Dee
I have a form which contains basics of a customer's order from table
[CustMain].

I placed a tab control on this form which is still empty. I'm trying
to design a project management database and would like to enter one
form for each sub project on each tab page.

[CustMain]

[Financial] [Survey] [Framing] [Siding] [Windows] [Roofing] ...=>

I have all the sub project forms designed. Each time I try to enter
one of them onto a tab page, they don't work. I have tried to copy and
paste the fields but then don't know how to hook them up to their
source data(table or query). Is it possible to do this and then
somehow point them to a source table or query? Could someone either
give me specifics on how to do this or where to go for specifics?

I have tried inserting them as sub forms, but then they display in
datasheet format. I need to these sub project pages to look like the
individual form I designed.

Under what circumstances is it best to use tables instead of queries
as a data sources for forms. My application will have only about 300
orders per year. Each sub project has an average of 45 fields.
Nov 12 '05 #1
2 10176
Dee wrote:
I have a form which contains basics of a customer's order from table
[CustMain].

I placed a tab control on this form which is still empty. I'm trying
to design a project management database and would like to enter one
form for each sub project on each tab page.

[CustMain]

[Financial] [Survey] [Framing] [Siding] [Windows] [Roofing] ...=>

I have all the sub project forms designed. Each time I try to enter
one of them onto a tab page, they don't work. I have tried to copy and
paste the fields but then don't know how to hook them up to their
source data(table or query). Is it possible to do this and then
somehow point them to a source table or query? Could someone either
give me specifics on how to do this or where to go for specifics?
These steps work for Access 2000; don't know about other versions (always a
good idea to post which version you are using).
Make sure the Control Wizards icon is clicked on in the Toolbox toolbar.
Use the Subform/Subreport control. Drop this onto the page of your tab
control. The subform wizard will run and you can tell Access how the
subform will get it's data.

The Access web has good info on subforms and referencing them in code.
http://www.mvps.org/access/

I have tried inserting them as sub forms, but then they display in
datasheet format. I need to these sub project pages to look like the
individual form I designed.
You have to add them as subforms. The Default View property in the Format
tab of each form allows you to control whether it's displayed as Continuous,
normal or datasheet.

Normally inserting a subform implies that you are displaying child records
in the subform which are related to the parent records of the main form.
Access help should explain this in more detail.
Under what circumstances is it best to use tables instead of queries
as a data sources for forms. My application will have only about 300
orders per year. Each sub project has an average of 45 fields.


It depends. Once you've normalised your data you may find that the data you
require for a form is spread over a number of tables. The only way to piece
this together is by using a query and using this as the datasource.
OTOH a simple database may just need one table.

So make sure you have normalised your tables first.

hth
Martin
Nov 12 '05 #2
"Dee" <wo********@com cast.net> wrote in message
news:35******** *************** ***@posting.goo gle.com...
Answering my own question

Subform must be based on an existing form. If the source is a table or
query, the the resulting display seems to always result in datasheet
view. This seems to be the case even when datasheet view is disabled
and only form view is chose in properties for the subform. I don't
know if this is a bug in 2k, but hope others will find this info
useful.


A subform *control* is merely a container on a form that points to another form. So
yes, you have to have an existing form for the control to point at. Not a bug.
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

16
3165
by: Picho | last post by:
Hi all, Is there any .NET way (I am not rulling out API usage) to add button(s) to a form's title bar? I found some non-.NET solutions that did actually work in VB6 but not in the ..NET forms... I tried painting, but the paintaing area provided by the form is only the client area - no visible way to paint on the title bar.
5
8145
by: Codemonkey | last post by:
Hi, When I first installed Visual Studio 2003, I noticed I was getting the follow error when showing a form: A first chance exception of type 'System.ArithmeticException' occurred in system.drawing.dll Additional information: Overflow or underflow in the arithmetic operation It is being thrown on the line that attempts to add the...
1
1715
by: Jonas L | last post by:
I have created a derived version of a normal form, e.g. called MyForm (public class MyForm : System.Windows.Forms.Form). The form is simply specifing a standard icon that we use within the company. This fairly straight forward and not a problem. We have planed to use this form as the base form to all other forms in our application. The...
0
1913
by: Chris Millar | last post by:
I have a user control that i wish to extend to change the date when the user selects the numeric up down button. The code explains itself, hope someone can help. any ideas appreaciated.. Chris. code :
1
1850
by: mccoyn | last post by:
I am having trouble adding a control to ControlCollection in a class I have derived from GroupBox. Here is what I've got __gc class RowColumn : public System::Windows::Forms::GroupBo public RowColumn() ignoredcontrols = new System::Windows::Forms::Control::ControlCollection(this) void IgnoreControl(System::Windows::Forms::Control*...
3
4860
by: Jim Heavey | last post by:
Trying to figure out the technique which should be used to add rows to a datagrid. I am thinking that I would want an "Add" button on the footer, but I am not quite sure how to do that. Is that the best method? Do you have a sample of how to do this?
1
15865
by: Brian Conklin | last post by:
Hello Eneryone, I am having a problem. I have written a little app that will take a text "pipe" delimited file and place all of the values in to an Excel spreadsheet. It works great on any of my XP Pro machines. When I install the app on a Win2K Pro machine, I get the following error message: ************** Exception Text **************...
26
2801
by: Simon Jefferies | last post by:
Hello, I am trying to add an item to a checked list box, like: clbList.Items.add("Hello",true) I get an error back: Run-time exception thrown: System.ArgumentOutOfRangeException - Specified argument was out of the range of valid values. Parameter name: '-1' is not a
6
6399
by: dbuchanan | last post by:
Hello, Is this a bug? Is there some kind of work around? I want to add default values for a few columns in my datagridview I found the "DefaultValuesNeeded" event for the datagridview I gave it a try using the example given in
11
18096
by: Pete Kane | last post by:
Hi All, does anyone know how to add TabPages of ones own classes at design time ? ideally when adding a new TabControl it would contain tab pages of my own classes, I know you can achieve this with ListView columns so it should be doable, thanks
0
7512
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8022
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7546
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6128
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5424
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5143
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3546
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2007
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
827
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.