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

Error problem

P: n/a
Hi,
I have built a small database and have incorporated a number of large
forms with multiple textboxes,listboxes,comboboxes etc. On completion it was
pointed out to me that I had mispelled one of the key fields in the main
table, and I set about finding any instances and editing them to the correct
spelling. Now when I open the main form a small error pops up first with
"Enter value" on it. If I cancel it the error goes away untill the next time
I open the form.

How do I search for the source of this problem and correct it. Is there some
way of searching for the incorrect spelling and finding any instances of it.
At present its more of an irritation than a reall problem, but I would like
to fix it. Tia, John
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Wed, 9 Mar 2005 10:20:18 -0800, "John" <lk*******@jhk.net> wrote:

Sounds like your form is using a query that is asking for a parameter.
This could be the query for the form.recordsource, or one of the
listboxes, comboboxes, subforms.

-Tom.

Hi,
I have built a small database and have incorporated a number of large
forms with multiple textboxes,listboxes,comboboxes etc. On completion it was
pointed out to me that I had mispelled one of the key fields in the main
table, and I set about finding any instances and editing them to the correct
spelling. Now when I open the main form a small error pops up first with
"Enter value" on it. If I cancel it the error goes away untill the next time
I open the form.

How do I search for the source of this problem and correct it. Is there some
way of searching for the incorrect spelling and finding any instances of it.
At present its more of an irritation than a reall problem, but I would like
to fix it. Tia, John


Nov 13 '05 #2

P: n/a
Late versions of Access have their own built-in "Track name changes" (under
the Tools-Options menu) but most developers elect to turn it off and use a
third-party tool; my favorite:

Find & Replace -shareware http://www.rickworld.com

-Ed
"John" <lk*******@jhk.net> wrote in message
news:W2*******************@news.indigo.ie...
Hi,
I have built a small database and have incorporated a number of large
forms with multiple textboxes,listboxes,comboboxes etc. On completion it
was
pointed out to me that I had mispelled one of the key fields in the main
table, and I set about finding any instances and editing them to the
correct
spelling. Now when I open the main form a small error pops up first with
"Enter value" on it. If I cancel it the error goes away untill the next
time
I open the form.

How do I search for the source of this problem and correct it. Is there
some
way of searching for the incorrect spelling and finding any instances of
it.
At present its more of an irritation than a reall problem, but I would
like
to fix it. Tia, John

Nov 13 '05 #3

P: n/a
John wrote:
Hi,
I have built a small database and have incorporated a number of
large forms with multiple textboxes,listboxes,comboboxes etc. On
completion it was pointed out to me that I had mispelled one of the
key fields in the main table, and I set about finding any instances
and editing them to the correct spelling. Now when I open the main
form a small error pops up first with "Enter value" on it. If I
cancel it the error goes away untill the next time I open the form.

How do I search for the source of this problem and correct it. Is
there some way of searching for the incorrect spelling and finding
any instances of it. At present its more of an irritation than a
reall problem, but I would like to fix it. Tia, John

Is the recordsource of the form a query? If so take a look at that
query and see what fields it's keying on. Perhaps one of those needs
updating.
Nov 13 '05 #4

P: n/a
That was the problem folks...........and the Find and Replace AddIn worked a
treat. Give yerselves a round of applause, and thanks loads.

"Deano" <ma**********@gmail.com> wrote in message
news:xn***************@usenet.plus.net...
John wrote:
Hi,
I have built a small database and have incorporated a number of
large forms with multiple textboxes,listboxes,comboboxes etc. On
completion it was pointed out to me that I had mispelled one of the

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.