Prompt for date

  • Thread starter Thread starter PBISMaryland
  • Start date Start date
P

PBISMaryland

Hello.

I am using Access 2007 and have a question about a query. Currrenty my
query prompts for a beginning date and an end date that the user has to type.
Is there a way to make the prompts a "date picker" rather than have the user
type numbers and dashes?

Thanks for your time.
 
I am envisioning a form that submits data to the query using the calendar
control that is in the toolbox. You can find the calendar control in the
toolbox under the icon in the bottom right-hand corner of the toolbox.
 
I apologize I missed that you were on 2007. With 2007 it automatically sets
up a calendar control for date/time fields. You will have the queries
criteria populate via whatever in those date fields, basically passing the
variable or input into the query.
 
That only works for forms. It does not work for queries. When a query
prompts, it is not using a form control, it is using an Input Box.

If you want the user to select dates using calendar controls, put two
calendar controls on your form and reference them from the query.
 
hello how would i reference them in the query

Klatuu said:
That only works for forms. It does not work for queries. When a query
prompts, it is not using a form control, it is using an Input Box.

If you want the user to select dates using calendar controls, put two
calendar controls on your form and reference them from the query.
Click to expand...
 
Sorry I was formerly known as querying for a latest revision. My name got
corrupted somehow due to setting up account in Firefox. ;)

You will click in the criteria field within the query and have it reference
your drop-down list fields within your form to pull in the data from them
when they submit the form. Try these two posts here for help with it:
http://forums.techguy.org/business-applications/558847-access-2003-import-data-one.html

http://forums.techguy.org/business-applications/577672-access-help.html
 
Back
Top