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
|
|||
|
|||
Parameter Query
Hi All,
Here's what I have: TABLE1(tbl_MAIN_DISC) with the following fields: DISC_ID=PK DATE USER_ID USER DISC_TYPE_ID DISC_TYPE TABLE2(tbl_DISC_TYPE) with the following fields: DISC_TYPE_ID=PK DISC_TYPE The relationship I have is a 1 (tbl_DISC_TYPE) to many (tbl_MAIN_DISC). I created a form with two combo box that populate two txt fields(USER_ID & DISC_TYPE_ID). I created a parameter query based on the txt fields from the form and it works great on pulling that specific USER_ID and DISC_TYPE_ID Is there a way to use the same form and only select the USER_ID and pull all related records? In other words disable the DISC_TYPE_ID field so that the parameter query is only using the USER_ID as the criterion? Is this even possible? Or is creating two forms that pull two differnt parameter quries the eaiset way to get this done? Is there a way to group all the DISC_TYPE_ID into an "all" type? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200912/1 |
#2
|
|||
|
|||
Parameter Query
Well, I'm assuming you currently have a form that shows one record and you
now want a form that shows multiple records. So I dont see how you can use the same form. Your design depends on what the users of this system want it to do. Should you not ask the users what they want? Or are you the user? Possibly you could have a form with search criteria at the top and a scrolling list (in a listbox) of matching records at the bottom. You can change the search criteria and click a button to refresh the search results list. Then you can click a record in the search results to go to another form that lists all the details. I use this set-up in many applications I have designed and it works very well. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "AccessUser777 via AccessMonster.com" wrote: Hi All, Here's what I have: TABLE1(tbl_MAIN_DISC) with the following fields: DISC_ID=PK DATE USER_ID USER DISC_TYPE_ID DISC_TYPE TABLE2(tbl_DISC_TYPE) with the following fields: DISC_TYPE_ID=PK DISC_TYPE The relationship I have is a 1 (tbl_DISC_TYPE) to many (tbl_MAIN_DISC). I created a form with two combo box that populate two txt fields(USER_ID & DISC_TYPE_ID). I created a parameter query based on the txt fields from the form and it works great on pulling that specific USER_ID and DISC_TYPE_ID Is there a way to use the same form and only select the USER_ID and pull all related records? In other words disable the DISC_TYPE_ID field so that the parameter query is only using the USER_ID as the criterion? Is this even possible? Or is creating two forms that pull two differnt parameter quries the eaiset way to get this done? Is there a way to group all the DISC_TYPE_ID into an "all" type? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200912/1 . |
#3
|
|||
|
|||
Parameter Query
Hi Dorian, thank you for your reply. I should have mentioned that the form
I'm using for the parameter criteria has a button to open a report based on the parameter query. My intention was to see if there was a way to use only that form and be able to have the user eiter select a specific "DISC_TYPE" or view all the "all". Any other ideas? Any help is appreciated. Thanks again. Dorian wrote: Well, I'm assuming you currently have a form that shows one record and you now want a form that shows multiple records. So I dont see how you can use the same form. Your design depends on what the users of this system want it to do. Should you not ask the users what they want? Or are you the user? Possibly you could have a form with search criteria at the top and a scrolling list (in a listbox) of matching records at the bottom. You can change the search criteria and click a button to refresh the search results list. Then you can click a record in the search results to go to another form that lists all the details. I use this set-up in many applications I have designed and it works very well. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". Hi All, Here's what I have: [quoted text clipped - 24 lines] the eaiset way to get this done? Is there a way to group all the DISC_TYPE_ID into an "all" type? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200912/1 |
#4
|
|||
|
|||
Parameter Query
"AccessUser777 via AccessMonster.com" u44103@uwe escribió en el mensaje de noticias:a0a45e831719a@uwe... Hi All, Here's what I have: TABLE1(tbl_MAIN_DISC) with the following fields: DISC_ID=PK DATE USER_ID USER DISC_TYPE_ID DISC_TYPE ByHostByHostByHost TABLE2(tbl_DISC_TYPE) with the following fields: DISC_TYPE_ID=PK DISC_TYPE The relationship I have is a 1 (tbl_DISC_TYPE) to many (tbl_MAIN_DISC). I created a form with two combo box that populate two txt fields(USER_ID & DISC_TYPE_ID). I created a parameter query based on the txt fields from the form and it works great on pulling that specific USER_ID and DISC_TYPE_ID Is there a way to use the same form and only select the USER_ID and pull all related records? In other words disable the DISC_TYPE_ID field so that the parameter query is only using the USER_ID as the criterion? Is this even possible? Or is creating two forms that pull two differnt parameter quries the eaiset way to get this done? Is there a way to group all the DISC_TYPE_ID into an "all" type? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200912/1 |
Thread Tools | |
Display Modes | |
|
|