• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

Query by form - display results in form

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
Coaster_brook_trout
Asked:
Coaster_brook_trout
  • 6
  • 5
1 Solution
 
Jeffrey CoachmanCommented:
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
 
Jeffrey CoachmanCommented:
In other words by using just a macro as I did above, no VBA code is needed...
0
 
Coaster_brook_troutAuthor Commented:
boag2000 how do I see what you did? When I click on your example a bunch of symbols pop up...
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Coaster_brook_troutAuthor Commented:
I was trying to do this...http://support.microsoft.com/kb/304428
0
 
Jeffrey CoachmanCommented:
<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
 
Coaster_brook_troutAuthor Commented:
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
 
Jeffrey CoachmanCommented:
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
 
Coaster_brook_troutAuthor Commented:
Oh geeze boag2000 you are the best, like the best, I love it when you answer my questions!!! Thank you so much!
0
 
Coaster_brook_troutAuthor Commented:
Boag2000 is the best!
0
 
Jeffrey CoachmanCommented:
<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
 
Jeffrey CoachmanCommented:
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now