Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 

Forums     

Microsoft Access Forum
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

 
This forum is for the discussion of Microsoft Access.

Access is my personal specialty. Have questions? Comments? Want to discuss how to do something? Post it here. Also, I get a LOT of questions sent to me in Email from people around the world. I'll post the interesting ones in here. Feel free to comment on them.

Click Here To Subscribe to this forum and receive an email update whenever new posts are added, just scroll down to the bottom of this page and enter your email address in the comment form.

Permanent Link
Keywords: microsoft access forum
Post New Topic

Read Date Picker for Parameter Query by Stephen K @ 2/24/2018
Thank you kindly!
Show Just This Thread        Post Reply
Read Date Picker for Parameter Query by Stephen K @ 2/23/2018
Hi guys,
Is there a way to have a date picker for my query instead of the user typing in the date?


Reply from Alex Hedley:

Use a Form and add a textbox, set the Format to Date and the picker button will show.
Show Just This Thread        Post Reply
Read parameter query by Roderick K @ 2/18/2018
thanks - had to use to "OR" parameter.


Reply from Alex Hedley:

Sorry, I didn't mean and as AND in a Query, I meant having two, bad use of words!
Show Just This Thread        Post Reply
Read parameter query by Roderick K @ 2/17/2018
beginner lesson 5 parameter query.  Is the a way to enter two parameters. Like "NY" and "OH"?


Reply from Alex Hedley:

You could create two inputs [Input1] and [Input2]
Show Just This Thread        Post Reply
Read Getting data from a parameter Query by randy r @ 7/15/2015
I have a Parameter query with a between statement in the date field to capture a date range. Am I able to get that date range to populate itself int a Report header?
Show Just This Thread        Post Reply
Read Getting data from a parameter Query by randy r @ 7/14/2015
I created a parameter query with a "Between [Start Date] and [End Date]" to feed into my report.Is there a way to link the [start Date] and [End Date] also to the report. What I want to see happen, is when I select the dates to generate a report, It would be nice to have that in the report header.


Reply from Alex Hedley:

Add a Textbox to the Report
Set the Control Source to
=Reports![reportname]!parametername]

=Reports![reportname]![Start Date]
And
=Reports![reportname]![End Date]

Or better than create a Form to take the Parameters then reference the Forms Controls
[Forms]![FormName]![ControlName]
Show Just This Thread        Post Reply
Read Adding an automatic end date to a Parameter Query by Greg Beben @ 7/1/2015
Why not just use a criteria such as Between MyDate and DateAdd("d",4,[MyDate])?
Show Just This Thread        Post Reply
Read Adding an automatic end date to a Parameter Query by Matt @ 6/29/2015
Hello,

I am trying to do a query where I ask the user for a date, and then get the results for all the records with that date plus the records that have a date up to the next 4 days that the user entered.

For example, once the query is run the User will be asked to put in a date and they enter 06/29/15. The query will then add 4 days to it to figure out the end date which would be 07/03/15 and show all the records that have a date from 06/29/15 up to and including 07/03/15.

Any help would be greatly appreciated. Is this even possible without using VBA or macros?


Reply from Richard Rost:

You can't specify default values for simple query criteria.

However, you could make a little form with two date values on it, and then an AFTERUPDATE event for Start Date could update End Date for you.
Show Just This Thread        Post Reply
Read Report from parameter query by cam @ 2/26/2015
Yup it has a date field this is what the parameter query is using.  Works fine when I run the query but not sure how to create the report from this .


Reply from Alex Hedley:

Create | Report Design
Set the Record Source to the Query
Add a button on the Form to open the Report.
See this Tip.
Show Just This Thread        Post Reply
Read Report from parameter query by cam @ 2/25/2015
When I create a report from a parameter query all the records show.  Any suggestions?  I have created a daily reporting database (flat file) and want to create a report that just shows today's information when run.  However it always brings up all the records in the database. All of want is information for today to take to management meetings.


Reply from Alex Hedley:

Is it a date field in the table?
Are you wrapping the date criteria in #?
Can you change your Query to SQL view and paste in what you have.
Show Just This Thread        Post Reply
Read Access Parameter Query Syntax by Larry @ 1/2/2011
I have a parameter query that takes a criterion from a form field. I would like that field to pass the following data but am having trouble with the proper syntax:

<> "Not Selected" Or "None"

I am trying to assign this data as follows:

qdf.Parameters("[Forms]![frmName]![frmDataField]") = /the data above/

Thanks for your advice.


From Richard:

Here's a tutorial I have on my web site for the proper syntax:

http://www.599cd.com/tips/access/forms-formname-field-notation/?key=AlXBlog

As far as showing ALL records goes, if you want the user to be able to leave the field blank and have the query return all records, you can set the parameter to something like this:

LIKE "*" & Forms!FormName!FieldName & "*"

This way if they type in "SMITH" they'll get:

Smith
Smithers
Smitherines
BlackSmith

And if they leave it blank, they will essentially get ALL of the records.
Show Just This Thread        Post Reply
Read Parameter Query Question by Richard Rost @ 9/22/2009
The tutorial was to show you how you can use a form to get a field value with Forms!FormName!FieldName into a query as a parameter. Now, knowing this, set up a form with a text box that has the input mask you want, and use this value to supply the query criteria.
Show Just This Thread        Post Reply
Read Parameter Query Question by Joseph @ 9/22/2009
It wasn't really what I was looking for but the tutorial was very interesting! Thanks for your help.
Show Just This Thread        Post Reply
Read Parameter Query Question by Richard Rost @ 9/21/2009
You cannot apply an input mask to a query parameter. You can, however, create a parameter "form" with a text box on it that DOES have your input mask. See this tutorial.
Show Just This Thread        Post Reply
Read Parameter Query Question by Joseph @ 9/21/2009
In my table I have a masked phone number field (!\(99") "9900\ 0000;0;_)
after inputed values (02)1234 5678

I would like to know if there is a way you can mask your parameter query input box?
e.g. prompt ("please input customer phone number") i would like to just input the numbers for the phone number to find the customers record (after inputed values 0212345678) then it corrects it to its correct mask format

or is this not possible?
is there an easier way to do that same kind of thing and with a possible result

Thanks Joseph

P.S. I have some knowledge with visual basic code if it needs it.
Show Just This Thread        Post Reply
Read Importing a Parameter Query into Excel by Joe Nellen @ 8/6/2009
Wow... you should be proud.  I learned Access from your classes and this is the second question I have posted.  Both times I have struggled with an issue, finally posted my question out of frustration.  Then, while I wait for your answer, I have gone back through my notes to try to continue to solve my problem.  And each time I have chosen the exact same solution that you suggest!!  Even though you always answer in a very timely manner, it seems I finally come to the solution just a couple of hours before you answer.  But the validation is great! Thank you again!  You're the best!!
Show Just This Thread        Post Reply
Read Importing a Parameter Query into Excel by Richard Rost @ 8/6/2009
Joe, I would use a MAKE TABLE query to generate a new table that you could then export to Excel (or import from Excel). You could do all of this with one command button for your user.

Make Table queries are covered in Access 222.

To automate the export to Excel, use the TransferSpreadsheet macro action (or VBA command) that I cover in Access 308.
Show Just This Thread        Post Reply
Read Importing a Parameter Query into Excel by Joe Nellen @ 8/5/2009
Richard All Knowing... I would like to be able to import a Parameter Query into Excel that can later be updated by users.  Thanks to taking many or your classes I built a DB for a customer that has a Menu only, I don't let them have access to the Tables or Toolbars etc.  There is a button on the menu that runs a date range Query. So I just want them to run the Query then open the spreadsheet, hit the Red ! to update the data.  In trying to set up the spreadsheet... when I do the 'Import External Data' the only Query that does not show up is the Parameter Query... so I am assuming that is why.  I know I should never assume... so I will say I am 'guessing'. Thanks for any help or direction you can give me.
Show Just This Thread        Post Reply
Read Parameter Query by Richard Rost @ 4/1/2009
Jenni, make a query and split off the month using the MONTH() function. Then add a parameter query for that field.

MyMonth: Month(MyBirthdate)
Show Just This Thread        Post Reply
Read Parameter Query by Jenni Long @ 3/26/2009
Hey Richard -- I guess you've been pretty busy.  I'd still like to find out how to get my database members' birthday listed when I enter their birthday month.
Show Just This Thread        Post Reply
Read Parameter Query by Richard Rost @ 1/22/2009
Jenni, I'll see what I can do. I have another T&T video I have to record for Leroy first before he gets mad at me. :)
Show Just This Thread        Post Reply
Read Parameter Query by Jenni Long @ 1/22/2009
Richard, I think you're going to have to go ahead and do the Tips & Tricks video...I couldn't make it past step one of your suggestion!
Show Just This Thread        Post Reply
Read Parameter Query by Richard Rost @ 1/21/2009
Jenni, can you build the query with NO parameters and see a list of people with the right month numbers? That's step one. Step 2 would be to then add the parameter for the month. Make sure that works. Then step 3 would be to add your other "primary" criteria and see if that works. Hopefully this will show you where the problem is. If you can't figure it out, let me know. This would make a good short video for my Tips & Tricks section.
Show Just This Thread        Post Reply
Read Parameter Query by Jenni Long @ 1/19/2009
Well, I tried the function (and I understand how it's supposed to work), but when I run the query and enter, say, a '3' for March birthdays, I get NO members listed.  The only other criterion I have set is that the field "primary" needs to be "true."
Show Just This Thread        Post Reply
Read Parameter Query by Richard Rost @ 1/19/2009
Use the Month(DOB) function in a query to show the month each user was born. That will give you a number from 1 to 12. Now base your parameter query on that number. Easy as pie.
Show Just This Thread        Post Reply
Read Parameter Query by Jenni Long @ 12/13/2008
I want to run a list of birthdays for a certain month (they get their name in the newsletter) and obviously that month changes for each newsletter, so I want to create a parameter query. Each club member's DOB is in a mm/dd/yyyy form but I only want it to show me the day from the month I give it.  How would I go about doing that?
Show Just This Thread        Post Reply

Collapse All Topics

 

Post Your Comments or Subscribe
    If you would like to be notified of new posts on this forum,
    just enter your email address below. It will be kept private.
 
If you just want to subscribe to get email updates when this forum is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
 
  Your Name:  Required
  Your Email:  NOT Public
  Subject:
  Comments:

 

Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 6+7:
  
  Notify me when the this forum is updated
  Remember Me for my next comments
  
 
 
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard

 

 

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

3/23/2018Microsoft Access Developer 7
2/22/2018Microsoft Access Developer 6
2/22/2018Access Assistance Available
2/21/2018Putting Access Databases Online
2/18/2018Microsoft Access Developer 5
2/10/2018Microsoft Access Developer 4
2/1/2018Access Tip: Salary History
7/19/2017Access Developer 2 and 3 Released
7/19/2017Microsoft Access Developer 3
7/19/2017Microsoft Access Developer 2
 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP