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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Show plus sign in form
Hi. I am trying to create a form containing a parent / child relationship. I
would like the form contain 2 subforms in datasheet view (the parent table - POSITION - and the child table - CANDIDATE -). This is not a problem. The problem I am having is that I would like the tables to have the plus / minus sign displayed as they do in the table. How can I get the plus / minus sign to be displayed in the form? Thanks. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201003/1 |
#2
|
|||
|
|||
Show plus sign in form
For what purpose?
You're describing a "how", but not much about the "what" ... what business need are you trying to solve by showing that "+"? Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "BenEl via AccessMonster.com" u56454@uwe wrote in message news:a5314a60e6733@uwe... Hi. I am trying to create a form containing a parent / child relationship. I would like the form contain 2 subforms in datasheet view (the parent table - POSITION - and the child table - CANDIDATE -). This is not a problem. The problem I am having is that I would like the tables to have the plus / minus sign displayed as they do in the table. How can I get the plus / minus sign to be displayed in the form? Thanks. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201003/1 |
#3
|
|||
|
|||
Show plus sign in form
It's a HR dbase. There is a table of Job Positions, a table of General
Candidates. One Position can have many Candidates and one Candidate can apply to many positions. I would like both of these tables displayed on the form. I would like the user to be able to see the key identifying fields of the two tables and click onto the "+" to quickly see who has applied for a position or vice versa. I will set the code so that the user can double click on the Candidate or Position ID and open the detail form. Thanks. Jeff Boyce wrote: For what purpose? You're describing a "how", but not much about the "what" ... what business need are you trying to solve by showing that "+"? Regards Jeff Boyce Microsoft Access MVP Hi. I am trying to create a form containing a parent / child relationship. I [quoted text clipped - 8 lines] Thanks. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201003/1 |
#4
|
|||
|
|||
Show plus sign in form
It sounds like you are trying to work directly in the tables ... that's how
you'd do it with spreadsheets, but it's neither necessary nor a good idea when using Access. Have you looked into using main form/subform construction? Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "BenEl via AccessMonster.com" u56454@uwe wrote in message news:a563637ada4a4@uwe... It's a HR dbase. There is a table of Job Positions, a table of General Candidates. One Position can have many Candidates and one Candidate can apply to many positions. I would like both of these tables displayed on the form. I would like the user to be able to see the key identifying fields of the two tables and click onto the "+" to quickly see who has applied for a position or vice versa. I will set the code so that the user can double click on the Candidate or Position ID and open the detail form. Thanks. Jeff Boyce wrote: For what purpose? You're describing a "how", but not much about the "what" ... what business need are you trying to solve by showing that "+"? Regards Jeff Boyce Microsoft Access MVP Hi. I am trying to create a form containing a parent / child relationship. I [quoted text clipped - 8 lines] Thanks. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201003/1 |
#5
|
|||
|
|||
Show plus sign in form
Yes - I think I'm going to end up doing a main form for positions and a sub
with Candidates and a main form with Candidates and a sub with positions... Not exactly how I envisioned it, but it will work. Jeff Boyce wrote: It sounds like you are trying to work directly in the tables ... that's how you'd do it with spreadsheets, but it's neither necessary nor a good idea when using Access. Have you looked into using main form/subform construction? Regards Jeff Boyce Microsoft Access MVP It's a HR dbase. There is a table of Job Positions, a table of General Candidates. One Position can have many Candidates and one Candidate can [quoted text clipped - 27 lines] Thanks. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201003/1 |
Thread Tools | |
Display Modes | |
|
|