Parameter Query Text

  • Thread starter Thread starter Andrea Stimson
  • Start date Start date
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
 
"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
 
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
Click to expand...
Click to expand...
 
Back
Top