ACCESS FEED: Re: [MS_AccessPros] Need help on a from and its subform (Collection Voucher)

Kamis, 29 Agustus 2013

Re: [MS_AccessPros] Need help on a from and its subform (Collection Voucher)

John,
you are right of asking about it

Table "CollectionVoucher" has following fields:
ConsignmentNo, Text, 9 (Row Source: SELECT [Consignment Number].ConsignmentNo FROM [Consignment Number]; )
Display Control: Combo box

ClientCIN, Number, Double (Row Source: SELECT Clients.ClientCIN FROM Clients ORDER BY Clients.ClientCIN; )
Display Control: Combo box

ClientName, Text, 30 (Row Source: SELECT Clients.ClientName FROM Clients ORDER BY Clients.ClientName; )
Display Control: Combo box

CollectionDate, Date/Time

CartonNo, Text, 4

Grade, Text, 1 (Row Source: SELECT Products.Grade,
Products.ProductName FROM Products; )
Display Control: Combo box

ProductName, Text, 20 (SELECT Products.ProductName FROM Products ORDER BY Products.ProductName; )
Display Control: Combo box

ProductQty, Number, Double

WeightOfCarton, Number, Double

Rate, Number, Double

Amount, Number, Double
------------
In subform i have not put fields "ConsignmentNo", "ClientCIN", "ClientName", "CollectionDate", "Grade"
-------------------------
on the main form i have put fields:
ConsignmentNo
Row Source: SELECT [Consignment Number].ConsignmentNo, [Consignment Number].CollectionDate, [Consignment Number].Grade FROM [Consignment Number] ORDER BY [Consignment Number].ConsignmentNo;)
Event: After Update:
Private Sub ConsignmentNo_AfterUpdate()
CollectionDate.Value = CmbCollectionDate
Grade.Value = CmbGrade
End Sub

CollectionDate (Name:CmbCollectionDate)
Control Source: =ConsignmentNo.Column(1)

Grade (Name: CmbGrade
Control Source: =ConsignmentNo.Column(2)

ClientCIN, Row Source: SELECT Clients.ClientCIN, Clients.ClientName FROM Clients;

ClientName (Name:CmbClientName)
Control Source: =ClientCIN.Column(1)

Hope you got the sceniaro

regards,
Khalid
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Khalid-
>
> That makes no sense to have the same table as the Record Source for both a
> form and a subform. Here are the fields you listed for CollectionVoucher:
>
> 5- CollectionVoucher (table)
> Fields: CartonNo, Text, 4
> ProductName
> ProductQty
> WeightOfCarton, Number, Double
> Rate
> Amount
>
> Nowhere do I see ConsignmentNo, ClientCIN, or any fields to relate to
> Products. Please clarify.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Khalid Tanweer
> Sent: Thursday, August 29, 2013 9:18 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Need help on a from and its subform (Collection
> Voucher)
>
> Thanks John,
> Nice to be in contact with you after a long time.
>
> Record Source of outer form is "CollectionVoucher" and the same is for
> subform. I did'nt meant its edited in subform.
>
> This is what i tried, you may suggest any new table and the way to solve my
> problem, which i have mentioned at the bottom of my question.
> I repeat it again:
> (On the main form "Collection Voucher" i need to enter OR select which ever
> is suitable or required "ConsignmentNo then "CollectionDate", Grade,
> ClientCIN, ClientName
>
> On the subform get inputs for: CartonNo (these would be serial No of Carton
> like 1,2,3....) ProductName (in its dropdown list only those items should
> display which "Grade" is selected on the main form.
> ProductQty
> WeightOfCarton
> Rate
> Amount
>
> What i require is that for a selected "ConsignmentNo" and selected
> "ClientCIN" entries made in subform should save and viewed for
> "ConsignmentNo" and "ClientCIN"
>
> If we select or change "ConsignmentNo" and "ClientCIN" on the main form,
> subform entries be saved for them seperately)
>
> regards,
> Khalid
>
> --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@>
> wrote:
> >
> > Khalid-
> >
> > I don't see how CollectionVoucher is related to any of the other tables.
> > You say that's edited in a subform. What is the Record Source of the
> > outer form?
> >
> > John Viescas, Author
> > Microsoft Access 2010 Inside Out
> > Microsoft Access 2007 Inside Out
> > Microsoft Access 2003 Inside Out
> > Building Microsoft Access Applications SQL Queries for Mere Mortals
> > http://www.viescas.com/ (Paris, France)
> >
> > P.S. Thanks - and always glad to help!
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Khalid
> > Tanweer
> > Sent: Thursday, August 29, 2013 6:30 AM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Need help on a from and its subform
> > (Collection
> > Voucher)
> >
> > Hi all,
> > i have returned to the group after a long period. Previously i gained
> > lot of information, help and knowledge from members and MVP's like
> > John (special thanks to him.) I am using Access 2003.
> > Any suggestions for changing or removing any table already trying to
> > use in the below form would be appreciated with thanks.
> > I have a form "Collection Voucher"
> >
> > Tables are:
> > 1- Consignment Number (table)
> > fields: ConsignmentNo (text,9-input mask: 9999\-A\-99;0;-)
> > CollectionDate
> > (Date/Time) form "Add New Consignment Number" is already made to add
> > new consignmentNo
> >
> > 2- Clients (table)
> > fields: ClientCIN, Number, double
> > ClientName, text, 30
> > other fields for this form are not required for above form Form
> "AddClient"
> > is already made to add new clients
> >
> > 3- ProductGrade (table) (Grade are "A", "B")
> > field: Grade, text, 1
> >
> > 4- Products (table) (These are items which we send through our cargo)
> > Fields: Grade (Lookup Row Source is "ProductGrade"
> > ProductName, text, 20
> > Form "Add New Products" is already made to add new Products
> >
> > 5- CollectionVoucher (table)
> > Fields: CartonNo, Text, 4
> > ProductName
> > ProductQty
> > WeightOfCarton, Number, Double
> > Rate
> > Amount
> >
> > On the main form "Collection Voucher" i need to enter OR select which
> > ever is suitable or required "ConsignmentNo then "CollectionDate",
> > Grade, ClientCIN, ClientName
> >
> > On the subform get inputs for: CartonNo (these would be serial No of
> > Carton like 1,2,3....) ProductName (in its dropdown list only those
> > items should display which "Grade" is selected on the main form.
> > ProductQty
> > WeightOfCarton
> > Rate
> > Amount
> >
> > What i require is that for a selected "ConsignmentNo" and selected
> > "ClientCIN" entries made in subform should save and viewed for
> > "ConsignmentNo" and "ClientCIN"
> >
> > If we select or change "ConsignmentNo" and "ClientCIN" on the main
> > form, subform entries be saved for them seperately
> >
> > Thanks in advance for supporting as my M.D is pressing hard to use
> > this form for our Consignment/collection of 30th August.
> > Khalid Tanweer
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>