Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Beginner > B9 > < B8 | X01 >
Back to Access Beginner 9    Comments List
825 of Contact Query B9 Upload Images   Link   Email  
Heather Gunther      
10 months ago
After entering this criteria statement and running it, I don't get any data.  The video says I should get an error message because I haven't declared the [Enter Date] parameter. I don't get the message until after declaring the parameter.  I'm wondering if this is a glitch with the version of Access that I'm using, which is MS 365.  

Any assistance you could give to helping me determine the issue would be greatly appreciated.  

Thank you,
Heather Gunther
Richard Rost              
10 months ago
I don't remember this specifically because it's been a while but did you finish the entire lesson? Sometimes there's errors in the lesson that I leave in there intentionally and they're fixed by the end of the lesson. If not let me know. As far as I can recall everything that's included in this lesson should be valid for any version of access.
Scott Axton            
10 months ago
Heather I think Richard, when he switched over the way the databases are stored in his server,  must have saved an "After the lesson" version / copy.  It used to be that you had to enter a password to open the database zip file.  Now that is taken care of at the web page level.  Times change.  (Keep in mind this course was produced in 2012 but it is still relevant today!)

I just opened my old copy up but it was with out the parameter and comparing it to a download I just did from the website.
The [Enter Date] is already in the Global Parameters up on the tool bar.
Mystery solved.

If you want to test this out, just back up 1 course to the Beginner 8 db.  That should be a clean db.
Or, even easier, just make the the parameter you enter into the query [My Date] instead of [Enter Date] that is in the video. So >=[My Date] And <[My Date]+1
Since [My Date] isn't in the Query Parameters it will error.  Now add in the [My Date] to the Query Parameters and the error will go away as in the video.
The key take away is - it isn't relevant what the parameter name is but how to fix it.
Heather Gunther      
10 months ago
Thank you to you both.  
Richard, I had finished part 3 of lesson 9. I'm getting ready to do part 4.  I believe Scott is on to something though with his explanation about the parameter [Enter Date] already being declared.  (Please see below)  

Scott, you are right.  I did notice that the [Enter Date] parameter appeared to already be declared.  I did try to remove it and rerun the process but that didn't work.  I like your idea of using a different parameter name.  Thank you.  I'll give that a try just so I can see the process in action.  Again, thank you for taking the time to provide such a thorough answer.  
Scott Axton            
10 months ago
Heather -
Glad that helped.  I have been accused of being to wordy at times ;-)

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


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

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
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/22/2024 9:52:20 AM. PLT: 1s