Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Courses > Access > Expert > X11 > < X10 | X12 >
Back to Access Expert 11    Comments List
Explicit Query Parameters Upload Images   Link   Email  
Ruth Muthoga        
9 months ago
In the Employee Work Log lesson, we reviewed querying dates. Back in Beginner 9 we learned about Explicit Query Parameters. When I used them to get HoursWorked for day, it worked just fine. The challenge came when trying to use an explicit query parameter and criteria supplied by a form--that just did not work.

The question: is there a way to input the data for the explicit query parameter and the query criteria simultaneously?
Ruth Muthoga        
9 months ago
The dates would be inputted with a form as shown in the class.
Kevin Robertson            
9 months ago
Can you post a screenshot of your query in Design View please, clearly showing your criteria?
Ruth Muthoga        
9 months ago

Ruth Muthoga        
9 months ago
I tried it again, this time a got the too complicated error message
Ruth Muthoga        
9 months ago

Ruth Muthoga        
9 months ago
As a simple query, the explicit parameter works. The challenge comes when using the form to fill the query parameters.
Kevin Robertson            
9 months ago
Instead of a Parameter why don't you use the form field?

Value From a Form
Ruth Muthoga        
9 months ago
With the explicit query parameter I was able to get around training issue regarding about end dates--as in, if we are query HoursWorked for just 8/1/2013, there is only one date to enter.

Using the form, we have to use the CDate function with the training challenge that comes with it. I am hoping there was another way around this training issue using the explicit query parameters. But alas.
Kevin Robertson            
9 months ago
You can still just specify one date (see screenshot).
Kevin Robertson            
9 months ago

Ruth Muthoga        
8 months ago
I tried this way and still didn't work.
In any case Richard tells us end users should not have access to queries and tables, this process gives them a query to manipulate.
But now we've learned how to create reports, whatever information we need can be obtained using another method.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 11.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/19/2024 2:47:09 AM. PLT: 0s