|
 |
access thread: Pull Down Boxes on Queries
Message #1 by rick.dolson@n... on Tue, 24 Sep 2002 16:07:44
|
|
Does anyone have any ideas on a solution to the following problem:
I have several "view-only" forms that run off a queries. The forms cannot
be updated, they are used only to view information already stored. The
forms pull information from a query. The query gets information from a
table by asking for an ID# as the parameter.
This requires the users to know the ID# of record they wish to view. My
users would like to be able to choose the ID# from a pull down menu,
rather than having to know and type the ID# in themselves.
Any ideas on how to get a query parameter to be a pull-box instead of an
input box, or any other ideas that may help solve my problem would be
greatly appreciated. Thank you for your time.
Message #2 by "Carnley, Dave" <dcarnley@a...> on Tue, 24 Sep 2002 10:12:29 -0500
|
|
This is possible there are any ways to implement it, but I would ask first,
how many ID numbers are there to choose from? More than about 20, and the
users will find a drop-down list very difficult to use.
-----Original Message-----
From: rick.dolson@n... [mailto:rick.dolson@n...]
Sent: Tuesday, September 24, 2002 11:08 AM
To: Access
Subject: [access] Pull Down Boxes on Queries
Does anyone have any ideas on a solution to the following problem:
I have several "view-only" forms that run off a queries. The forms cannot
be updated, they are used only to view information already stored. The
forms pull information from a query. The query gets information from a
table by asking for an ID# as the parameter.
This requires the users to know the ID# of record they wish to view. My
users would like to be able to choose the ID# from a pull down menu,
rather than having to know and type the ID# in themselves.
Any ideas on how to get a query parameter to be a pull-box instead of an
input box, or any other ideas that may help solve my problem would be
greatly appreciated. Thank you for your time.
Message #3 by rick.dolson@n... on Tue, 24 Sep 2002 16:30:51
|
|
Yeah, there are about 15. Could possibly grow, but not by very many.
Thanks.
> This is possible there are any ways to implement it, but I would ask
first,
how many ID numbers are there to choose from? More than about 20, and the
users will find a drop-down list very difficult to use.
-----Original Message-----
From: rick.dolson@n... [mailto:rick.dolson@n...]
Sent: Tuesday, September 24, 2002 11:08 AM
To: Access
Subject: [access] Pull Down Boxes on Queries
Does anyone have any ideas on a solution to the following problem:
I have several "view-only" forms that run off a queries. The forms cannot
be updated, they are used only to view information already stored. The
forms pull information from a query. The query gets information from a
table by asking for an ID# as the parameter.
This requires the users to know the ID# of record they wish to view. My
users would like to be able to choose the ID# from a pull down menu,
rather than having to know and type the ID# in themselves.
Any ideas on how to get a query parameter to be a pull-box instead of an
input box, or any other ideas that may help solve my problem would be
greatly appreciated. Thank you for your time.
Message #4 by "Carnley, Dave" <dcarnley@a...> on Tue, 24 Sep 2002 10:28:07 -0500
|
|
Well that should be fine...
You could make a small dialog box that has the drop down list of IDs, on its
"After Update" event you could have it show your existing form with the
selected ID as a Open Args parameter, then your form_open uses the OpenArgs
ID number to find the data it needs. The form_open can also close the
dialog box, and you can add a "search" button to the main form that closes
the main form and shows the dialog box.
-----Original Message-----
From: rick.dolson@n... [mailto:rick.dolson@n...]
Sent: Tuesday, September 24, 2002 11:31 AM
To: Access
Subject: [access] RE: Pull Down Boxes on Queries
Yeah, there are about 15. Could possibly grow, but not by very many.
Thanks.
> This is possible there are any ways to implement it, but I would ask
first,
how many ID numbers are there to choose from? More than about 20, and the
users will find a drop-down list very difficult to use.
-----Original Message-----
From: rick.dolson@n... [mailto:rick.dolson@n...]
Sent: Tuesday, September 24, 2002 11:08 AM
To: Access
Subject: [access] Pull Down Boxes on Queries
Does anyone have any ideas on a solution to the following problem:
I have several "view-only" forms that run off a queries. The forms cannot
be updated, they are used only to view information already stored. The
forms pull information from a query. The query gets information from a
table by asking for an ID# as the parameter.
This requires the users to know the ID# of record they wish to view. My
users would like to be able to choose the ID# from a pull down menu,
rather than having to know and type the ID# in themselves.
Any ideas on how to get a query parameter to be a pull-box instead of an
input box, or any other ideas that may help solve my problem would be
greatly appreciated. Thank you for your time.
Message #5 by rick.dolson@n... on Tue, 24 Sep 2002 17:23:08
|
|
Thank you very much for your help. I almost have it working. I have a
simple form with the pull down menu. And I have a variable which captures
the ID # that I'm looking for. Then, my main form closes the simple
form. But, somewhere in between, I need to pass that value from the
simple form to the main form.....and I suspect this is what you are
alluding to as my open Args parameter. I'm just not sure how to do this.
Thanks again, I really appreciate the help.
> Well that should be fine...
You could make a small dialog box that has the drop down list of IDs, on
its
"After Update" event you could have it show your existing form with the
selected ID as a Open Args parameter, then your form_open uses the OpenArgs
ID number to find the data it needs. The form_open can also close the
dialog box, and you can add a "search" button to the main form that closes
the main form and shows the dialog box.
-----Original Message-----
From: rick.dolson@n... [mailto:rick.dolson@n...]
Sent: Tuesday, September 24, 2002 11:31 AM
To: Access
Subject: [access] RE: Pull Down Boxes on Queries
Yeah, there are about 15. Could possibly grow, but not by very many.
Thanks.
> This is possible there are any ways to implement it, but I would ask
first,
how many ID numbers are there to choose from? More than about 20, and the
users will find a drop-down list very difficult to use.
-----Original Message-----
From: rick.dolson@n... [mailto:rick.dolson@n...]
Sent: Tuesday, September 24, 2002 11:08 AM
To: Access
Subject: [access] Pull Down Boxes on Queries
Does anyone have any ideas on a solution to the following problem:
I have several "view-only" forms that run off a queries. The forms cannot
be updated, they are used only to view information already stored. The
forms pull information from a query. The query gets information from a
table by asking for an ID# as the parameter.
This requires the users to know the ID# of record they wish to view. My
users would like to be able to choose the ID# from a pull down menu,
rather than having to know and type the ID# in themselves.
Any ideas on how to get a query parameter to be a pull-box instead of an
input box, or any other ideas that may help solve my problem would be
greatly appreciated. Thank you for your time.
|
|
|
View Cart
