Free Lessons
Fast Tips
Topic Index
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Access Search Seminar
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   10 years ago

Back to Access Search Seminar

Search Seminar 34 Reports Upload Images   Link  
Stephen Southcombe 
12 months ago
As requested I am transferring this question from my post on Facebook -

"Richard, God bless ya, but I am totally not getting Lesson 34 of the Search Seminar.
I have all this vba allowing me to search a large table just about any way anyone could want and view it in a form.....but I can't translate that search method into a report?
Your example of "Wh2" has left me stumped..... I've not been successful getting that to work. Where can I get more insight and understanding on selectable data reports?"
Richard Rost
12 months ago
Hi Stephen. I'm not sure what you don't understand. Explain to me the problem, please. Do you need more help understanding string concatenation?
Stephen Southcombe
12 months ago
Hello Richard;

No, I'm having trouble understanding / programming my reports to show the data I want.

I have a complex search form with more than 30 different combo box fields for which I have vba written to look up data according to the values selected (additionally with tri-state conditions). Everything works great for showing the desired data in a form when I run the vba.

My trouble lies in trying to translate that into a report.

I am able to get a "start date" and an "end date" to work together for a report. But when I go beyond that I start getting parameter query boxes popping up on the screen asking me for values that it should be getting from the search form.

I know you state in the Search Seminar 34 Lesson that reports don't function the same as forms and then you go into creating "Wh2" as a means to work around this but I am not understanding how to code it.

Stephen Southcombe
11 months ago

Stephen Southcombe
11 months ago

Stephen Southcombe
11 months ago
Figured it out. Sometimes you get so in depth into complicated coding that you forget basic things. So, in this instance I had forgotten to add the correct fields to the query...resulting in multiple parameter boxes popping up.

Send me back to remedial MS Access.....
Richard Rost
11 months ago
That'll do it, every time. That or misspellings. :)

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Access Search Seminar

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

5/16/2022Referential Integrity
5/15/2022Invoicing Member Discussion
5/12/2022Number Field Size
5/11/2022Create Word Document
5/11/2022Export to Word
5/10/2022On Click Event Timing
5/9/2022Invalid Use of Null
5/7/2022Event Handler
5/6/2022Database Title & Icon

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn