By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,293 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

Enter Parameter Value....Help

P: n/a
I have a data base that I am reusing for a slightly different customer. I
copied alot of my original product into the new database. I had to rename
some fields in some tables and now get enter parameter value when I work on
forms. I have already set Name and Track Autocorrect to active...to no avail

Dec 13 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Sounds like one or more of your forms has a recordsource (query/table) that
is missing one or more fields. Look for "Exp1" in the underlying query
design grid and correct any missing names.

The Access autocorrect feature works, but must be turned on before objects
are created. Try "Find & Replace"

http://www.rickworld.com/

to change existing object names.
-Ed
"DavidS" <u30192@uwewrote in message news:6ab4a64137cb4@uwe...
>I have a data base that I am reusing for a slightly different customer. I
copied alot of my original product into the new database. I had to rename
some fields in some tables and now get enter parameter value when I work
on
forms. I have already set Name and Track Autocorrect to active...to no
avail

Dec 13 '06 #2

P: n/a
David, my experience is that Name AutoCorrect does not work reliably, does
not work in all contexts, works incorrectly (confusing the names of fields,
controls, aliases, and captions), can crash Access (shut down by Windows),
and has a high likelihood of corrupting your database.

I don't even bother keeping this article up to date any more:
Failures caused by Name Auto-Correct
at:
http://allenbrowne.com/bug-03.html
as there are just too many associated bugs.

Disable Name AutoCorrupt, compact the database, and then rename the cases
where Access asks for parameters so it is using the correct field names.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"DavidS" <u30192@uwewrote in message news:6ab4a64137cb4@uwe...
>I have a data base that I am reusing for a slightly different customer. I
copied alot of my original product into the new database. I had to rename
some fields in some tables and now get enter parameter value when I work
on
forms. I have already set Name and Track Autocorrect to active...to no
avail

Dec 13 '06 #3

P: n/a
"Ed Robichaud" <ed*********@wdn.comwrote in message
news:45***********************@news.wdn.com...
>
The Access autocorrect feature works,
That's debatable since it causes many problems, see this:

http://allenbrowne.com/bug-03.html
Dec 13 '06 #4

P: n/a
I agree, do not use that feature myself and do not recommend it. I just
wanted to point out that you can't switch it on after the fact and expect it
to track and change "old" objects.
-Ed

"Keith Wilby" <he**@there.comwrote in message
news:45**********@glkas0286.greenlnk.net...
"Ed Robichaud" <ed*********@wdn.comwrote in message
news:45***********************@news.wdn.com...
>>
The Access autocorrect feature works,

That's debatable since it causes many problems, see this:

http://allenbrowne.com/bug-03.html

Dec 14 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.