?
Solved

Query by form - display results in form

Posted on 2013-02-07
11
Medium Priority
?
283 Views
Last Modified: 2013-02-08
When I hit the search button on my form I get an error. What is causing the error and how do I fix it? See attached database.
FFWS.accdb
0
Comment
Question by:Coaster_brook_trout
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 38865654
You have it all wrong there.
Do you want to use VBA or A macro?
You have Macro Actions in a VBA Function...?


Try it like this:
FFWS-1--2013-02-07.accdb
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38865662
In other words by using just a macro as I did above, no VBA code is needed...
0
 

Author Comment

by:Coaster_brook_trout
ID: 38865676
boag2000 how do I see what you did? When I click on your example a bunch of symbols pop up...
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Coaster_brook_trout
ID: 38865682
I was trying to do this...http://support.microsoft.com/kb/304428
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38865753
<When I click on your example a bunch of symbols pop up... >
Not sure what you are doing then...

I type in "Barry" as the county.
Then I click the button and get this:
results
Try Downloading the sample again and let me know
0
 

Author Comment

by:Coaster_brook_trout
ID: 38865767
That's EXACTLY what I was trying to do. Except I don't know how to download your file. I click on the link and a browser page pops up with all this gibberish. I can't find another place to click or an option that says download or save file...
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38865792
Oh...

That is because the site does not know the .accdb extension...

Right-click on the link and select "Save Link As", and point to a location on your disk.
(for example:, My Documents)
Then you can go to that location and open the file
0
 

Author Comment

by:Coaster_brook_trout
ID: 38867698
Oh geeze boag2000 you are the best, like the best, I love it when you answer my questions!!! Thank you so much!
0
 

Author Closing Comment

by:Coaster_brook_trout
ID: 38867699
Boag2000 is the best!
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38868206
<Oh geeze boag2000 you are the best, like the best, I love it when you answer my questions!!! Thank you so much! >
Thanks, But I am only one of the many Experts here.

But give yourself some credit.
You made a valiant try at taking a complex articular and trying to get it to work for your purposes.
Many people would have simply "asked" for a solution, but you sought one out on your own.

The fact that you were able to show me what you did, enabled me to target my solution.
;-)
This is why I always try to post sample files.
Many times you go through all the trouble of following a complex set of steps, ..only to find out that it does not work in the way you expected (or does not work at all!)

But as a bonus, I will also say that you could have created code on the click event of the button that was simply this:
Docmd.OpenQuery "QBF_Query"
See the new sample

Other notes:
You should also have a table of distinct Counties
You also need a table of Distinct Waterbodies
Then a third "Junction" table: CountyWaterbodies, ...to join the two
(I guess the same thing would go for "Species...? and the other tables as well)
This will allow you to build a drop down box on your form to "select" a county (or Waterbody, or whatever), instead of relying on the user to spell it correctly.
But you should perhaps post a separate question on this topic. (Many-To-Many relationships)

In otherwords, before you start designing complex interfaces for your application, make sure the data is properly normalized and related.

;-)

JeffCoachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38868208
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question