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)

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