A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

PLS HELP~! Simple Question: Master & Child Link without subform



 
 
Thread Tools Display Modes
  #1  
Old April 14th, 2010, 06:44 AM posted to microsoft.public.access.gettingstarted
Kaoli
external usenet poster
 
Posts: 13
Default PLS HELP~! Simple Question: Master & Child Link without subform

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.
  #2  
Old April 14th, 2010, 11:13 PM posted to microsoft.public.access.gettingstarted
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default PLS HELP~! Simple Question: Master & Child Link without subform

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.

  #3  
Old April 15th, 2010, 03:55 AM posted to microsoft.public.access.gettingstarted
Kaoli
external usenet poster
 
Posts: 13
Default PLS HELP~! Simple Question: Master & Child Link without subfor

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.

  #4  
Old April 15th, 2010, 04:19 AM posted to microsoft.public.access.gettingstarted
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default PLS HELP~! Simple Question: Master & Child Link without subfor

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

  #5  
Old April 15th, 2010, 01:46 PM posted to microsoft.public.access.gettingstarted
John Spencer
external usenet poster
 
Posts: 7,815
Default PLS HELP~! Simple Question: Master & Child Link without subfor

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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.