Prev: Printing in Landscape via an Embedded Macro
Next: Can anyone tell me how to Hyperlink in Access?
From: Kaoli on 14 Apr 2010 22:55
May I know what you mean left join Master to Child in the query?



"KARL DEWEY" wrote:

> If I understand what you want I think if you Left Join Master to Child in the
> query it will function like you want.
>
> --
> Build a little, test a little.
>
>
> "Kaoli" wrote:
>
> > Good day everyone.
> > I appreciate any suggestion by all of you.
> >
> > 1st Is possible have Master & Child Link function without adding any
> > subform? If yes, how?
> >
> > Eg: When I selected a customer "ABC Inc" from a combolist (or many more than
> > 1 field; eg this month,sales man A and etc), all transaction record from
> > table tbltransaction will show me all transactions in a ~*SPLITFORM*~
> > according what i selected, when I adding new record in the form the table
> > tbltransaction will automatic adding new record including all
> > selection(customer ABC Inc,sales man A and etc) I make which like how parent
> > form and subform do between master link and child link.
> >
> > I did not use subform for this because I unable to add Splitform in a
> > subform, I search many place but cant found the best solution,
> >
> > I try to mimic splitform in 2 subforms(1 single form and 1 datasheet), I can
> > synchronize between single view subform and datasheet subform, but I facing
> > problem when I adding new record and delete record and other few small
> > problems. What I can say is not a new user can simply done this without a
> > good VBA knowledge, as my problem is very simple so I hope I can mimic
> > subform function in Splitform, so I do not need to write many VBA code for 2
> > subforms(1 single form and 1 datasheet) or maybe someone can teach me how to
> > write the VBA code which allow me mimic splitform in 2 subform.
> >
> > I tried to solve and search solution in internet about 2 months, I really
> > hope anyone can help me this new user to solve this simple problem.
From: PieterLinden via AccessMonster.com on 14 Apr 2010 23:19
Kaoli wrote:
>May I know what you mean left join Master to Child in the query?
>
>> If I understand what you want I think if you Left Join Master to Child in the
>> query it will function like you want.
>[quoted text clipped - 27 lines]
>> > I tried to solve and search solution in internet about 2 months, I really
>> > hope anyone can help me this new user to solve this simple problem.


LEFT join means
"include ALL records in the "Left side" table, and only matching records in
the right side. So say you have the standard Customers and Invoices tables
joined on CustomerID...

SELECT Customer.CustName, Invoice.InvoiceNo
FROM Customer LEFT JOIN Invoice ON Customer.CustomerID = Invoice.CustID

will display ALL Customers regardless of whether they have any invoices, and
any invoices they may have. An INNER join will eliminate all customers from
the result set that have no Invoices.

--
Message posted via http://www.accessmonster.com

From: John Spencer on 15 Apr 2010 08:46
In the underlying query
There should be a link between the two tables ( a line from customer id to
customer id - or whatever you call the field identifying the customer).

Double-click on the line and choose the option that shows all customers in the
customer table and matching records in tblTransaction - option 2 or 3
depending on how the relationship was set up.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Kaoli wrote:
> May I know what you mean left join Master to Child in the query?
>
>
>
> "KARL DEWEY" wrote:
>
>> If I understand what you want I think if you Left Join Master to Child in the
>> query it will function like you want.
>>
>> --
>> Build a little, test a little.
>>
>>
>> "Kaoli" wrote:
>>
>>> Good day everyone.
>>> I appreciate any suggestion by all of you.
>>>
>>> 1st Is possible have Master & Child Link function without adding any
>>> subform? If yes, how?
>>>
>>> Eg: When I selected a customer "ABC Inc" from a combolist (or many more than
>>> 1 field; eg this month,sales man A and etc), all transaction record from
>>> table tbltransaction will show me all transactions in a ~*SPLITFORM*~
>>> according what i selected, when I adding new record in the form the table
>>> tbltransaction will automatic adding new record including all
>>> selection(customer ABC Inc,sales man A and etc) I make which like how parent
>>> form and subform do between master link and child link.
>>>
>>> I did not use subform for this because I unable to add Splitform in a
>>> subform, I search many place but cant found the best solution,
>>>
>>> I try to mimic splitform in 2 subforms(1 single form and 1 datasheet), I can
>>> synchronize between single view subform and datasheet subform, but I facing
>>> problem when I adding new record and delete record and other few small
>>> problems. What I can say is not a new user can simply done this without a
>>> good VBA knowledge, as my problem is very simple so I hope I can mimic
>>> subform function in Splitform, so I do not need to write many VBA code for 2
>>> subforms(1 single form and 1 datasheet) or maybe someone can teach me how to
>>> write the VBA code which allow me mimic splitform in 2 subform.
>>>
>>> I tried to solve and search solution in internet about 2 months, I really
>>> hope anyone can help me this new user to solve this simple problem.
 | 
Pages: 1
Prev: Printing in Landscape via an Embedded Macro
Next: Can anyone tell me how to Hyperlink in Access?