Parameter Query Text

A

Andrea Stimson

Hello,

I have a query set up which relies on the user entering a date. When it
prompts the user to enter a date the message (Now) comes up to enter the
current date, is there any way I can change the prompt text to read "Enter
date"?

Thanks
Andrea
 
J

John Spencer MVP

"Now" is a reserved word in Access and the function Now() returns the current
system date and time. I suspect that you might have a references problem with
your database.

As a first step, please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

When you do that perhaps we can help. By the way, the Date() function returns
just the date.

You might want to take a look at
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
which discusses library reference problems and how to fix them.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
D

Duane Hookom

IMO, parameter prompts are not good practice. Apps should be built using
forms and controls for criteria http://www.tek-tips.com/faqs.cfm?fid=6763.
--
Duane Hookom
Microsoft Access MVP


golfinray said:
[Please Enter Date]
--
Milton Purdy
ACCESS
State of Arkansas


Andrea Stimson said:
Hello,

I have a query set up which relies on the user entering a date. When it
prompts the user to enter a date the message (Now) comes up to enter the
current date, is there any way I can change the prompt text to read "Enter
date"?

Thanks
Andrea
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top