Any MS Access gurus in here - please help
AsSiMiLaTeD
Posts: 11,728
Oh my God I'm going insane trying to figure this out...if anyone here knows Access really well, I'm in desparate need of help. I'm gonna look around online and see if I can find an Access forum also...
If you don't know Access really well, then don't waste your time reading this because it won't make any sense to you. I'm just hoping that out of everyone on here we have one or two Access gurus...
So here's the issue at hand. When I run a query, I want my users to be able to select the criteria from a drop down box, instead of having to type it in the typical "Enter Parameter Value" box. So I did some research online and found the following information, that helps a little bit, in which you can build a form with drop down boxes and command buttons and use that to run the query.
http://www.fontstuff.com/access/acctut08.htm
That works well, except for one HUGE problem - you have to run the query from the form itself, you can't just run the actual query. So I run the query via the form and get accurate results, but the results are just listed out in a table. I need the results to be able to be pulled into a report or another form, but you can only build forms or reports based on a table or query, not another form.
So when I build a report based on the query I create, it won't run because it's trying to run the query - and remember you can't run the query directly...it has to be run from the form.
Is there a way I can make Access format the data generated by the query (generated by the form with drop downs) differently than just displaying in the standard table format?
This is absolutely insane! I can't believe that Microsoft has made it so difficult to use a drop down box linked to a lookup table as a means for running a query...absolutely ludicrous!!
If you don't know Access really well, then don't waste your time reading this because it won't make any sense to you. I'm just hoping that out of everyone on here we have one or two Access gurus...
So here's the issue at hand. When I run a query, I want my users to be able to select the criteria from a drop down box, instead of having to type it in the typical "Enter Parameter Value" box. So I did some research online and found the following information, that helps a little bit, in which you can build a form with drop down boxes and command buttons and use that to run the query.
http://www.fontstuff.com/access/acctut08.htm
That works well, except for one HUGE problem - you have to run the query from the form itself, you can't just run the actual query. So I run the query via the form and get accurate results, but the results are just listed out in a table. I need the results to be able to be pulled into a report or another form, but you can only build forms or reports based on a table or query, not another form.
So when I build a report based on the query I create, it won't run because it's trying to run the query - and remember you can't run the query directly...it has to be run from the form.
Is there a way I can make Access format the data generated by the query (generated by the form with drop downs) differently than just displaying in the standard table format?
This is absolutely insane! I can't believe that Microsoft has made it so difficult to use a drop down box linked to a lookup table as a means for running a query...absolutely ludicrous!!
Post edited by RyanC_Masimo on
Comments
-
Damn I'm a genius...I figured it out!!!:D
Ah, nothing like figuring it out on your own...
Woo Hoo, I'm excited now! Man I'm such a nerd!!!!:D
-
Aw man. I just finished typing up a 3 page explaination as to how to get it to work. I was just about to copy and paste it.
No really....what is access?Setup:
Adcom GFA-545 amp
Nad 1600 pre
Dual 704 TT
Pioneer 707 R2R
Pioneer DV-578A Multi-format
Polk SDA-2 Mains -
Originally posted by Spawndn72
Aw man. I just finished typing up a 3 page explaination as to how to get it to work. I was just about to copy and paste it.
No really....what is access?
ROFL!!!!
:eek: :eek:
In UseGeorge Grand wrote: »
PS3, Yamaha CDR-HD1300, Plex, Amazon Fire TV Gen 2
Pioneer Elite VSX-52, Parasound HCA-1000A
Klipsch RF-82ii, RC-62ii, RS-42ii, RW-10d
Epson 8700UB
In Storage
[Home Audio]
Rotel RCD-02, Yamaha KX-W900U, Sony ST-S500ES, Denon DP-7F
Pro-Ject Phono Box MKII, Parasound P/HP-850, ASL Wave 20 monoblocks
Klipsch RF-35, RB-51ii
[Car Audio]
Pioneer Premier DEH-P860MP, Memphis 16-MCA3004, Boston Acoustic RC520 -
Originally posted by Spawndn72
No really....what is access?
It's too much in Texas.
