473,406 Members | 2,356 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Enter Parameter Value....Help

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
4 1923
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
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
"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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Phil IU Guy | last post by:
I am having 2 issues, both acting very randomly, and for the most part I dont get this message on most computers, but I have had a couple computers get either issue 1, or issue 2. Issue #1: I...
1
by: Stuart E. Wugalter | last post by:
Hello. No one in the queries newgroup answered this question. I hope someone here can. Thank you. Stuart The following Update Query allows my users to substitute a numerical value for the...
1
by: Chuck | last post by:
I have a query that uses the query with the critera set to . We I run the query the msgbox pops up asking for the name information to be entered, but on the top (blue background) of the message box...
9
by: Megan | last post by:
Hi- I'm creating a database of music bands with their cds and songs. I'm trying to program an SQL statement so that I can enter a string of text in a textbox, press the 'Enter' key, and have...
0
by: KGrein | last post by:
Hi. I have a form that contains a combo box with customer number & customer name in it. The form is called F_DeleteUSCust and the combo box is named CB_getUScust It picks up the information for...
11
by: Joe | last post by:
Hello All, I have an ASP.NET page with one Textbox (SearchTextBox) and one ImageButton (SearchButton) server controls. The user can type search text in SearchTextBox and click SearchButton and...
2
by: billtubbs | last post by:
Hi I am getting the common problem of the "Enter Parameter Value" dialog box, which pops up every time I execute a query. I built the query using the Expression Builder in Access. If any of my...
1
by: janekelly111 | last post by:
I have a main form with one subform linked by a one-to-many relationship on one field only. The main form;s recordsource is a query determined and assigned from a command button on a "Find" form...
2
by: Sep410 | last post by:
Hi all, I am using vb.net and Sql2005 and crystal report viewer in my application. the peroblem is when I run a report and I set the value for parameter a Enter Parameter value pops up.I shoudl...
9
by: junaidfaiz | last post by:
How can i get rid of "Enter Parameter Value" check boxes? as when i open my bill section there I have called multiple queries, forms and tables. It works perfectly fine. No error in calculation or...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.