Thanks- Stuart and Jma for your guidance. I understood the method and got the desired results.
Regards,
Kumar
--- In MS_Access_Professionals@yahoogroups.com, "Stuart Aitchison" <saitchison@...> wrote:
>
> Kumar, Hi:
>
>
>
> I'm not one the Access gurus, but I have done this in several situations
> now, involving stock, contacts and one or two other things.
>
>
>
> One caution. The more tabs you have on a form, the longer it takes for the
> form to open.
>
>
>
> You can use either the main form as the controlling form, or include a list
> sub form which can be used as the controlling form.
>
>
>
> Whichever you use, do not forget to requery the linked forms from the main
> form whenever the user changes whatever record it is on the main form that
> is the main item being looked up.
>
>
>
> Regards,
>
>
>
> Stuart Aitchison.
>
>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of sw@...
> Sent: Sat, 29 September 2012 17:44 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Tab control form
>
>
>
>
>
> 1) main form -> main table as source.
> 2) make solo form for each sub-table and name it as like as subformXY.
> 3) in main form put on each tab one sub-form as subform-control.
> 4) in properties of each subform control set LinChildFields and
> LinkMasterFields property.
> More you find sure by google
> -jma-
>
> ----- Original Message -----
> From: "access_kri" <access_kri@... <mailto:access_kri%40yahoo.com> >
> To: <MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> >
> Sent: Saturday, September 29, 2012 4:06 PM
> Subject: [MS_AccessPros] Tab control form
>
> > Dear Group,
> > Can tabbed control editable form can have data from only one table or
> multiple tables can be used? I am trying to make an
> > tabled form for Equipment specification. As equipment specification can
> have several sections such as Name plate details, Design
> > parameters, Operating parameters, constructional details, material of
> construction etc. I created separate tables for each of
> > these categories and linked them together with EquipmentID field. Thus all
> tables are having one-to-one relationship with
> > equipmentID in the NamePlate table. I am then basing my form on query that
> pulls information from all the tables. However, the
> > query is not editable and It only displays the records but I cannot add
> new records. How I can create a tabbed form which contains
> > information from all these tables?
> >
> > Thanks and Regards,
> > Kumar
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> > http://help.yahoo.com/help/us/groups/messages/messages-23.html
> >
> >
> >
> >
>
>
>
>
> --
> This message has been scanned for viruses and
> dangerous content by Pinpoint, and is
> believed to be clean.
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar