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

Parameter Prompt for field, which was deleted from table

P: n/a
Access 2003

Several days ago, I deleted a field from a table, which was no longer
required. Additionally, all associated elements for this field were also
removed from the database, i.e. from Forms, Queries, Reports.

However, every time I open my main form, or any form associated with the
main form, I receive a Prompt: Enter Parameter Value -
tblPersonnel.PCivilianSIN

The table was: tblPersonnel, and the field was called: PCivilianSIN

I have performed a search on my entire database, I have imported my database
into a new database, I've recompiled, and I can't find, nor get rid of this
Prompt.

Any suggestions are most welcome!

Thanks in advance,

Cheers,

Dave
Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
On Fri, 04 Feb 2005 16:16:53 GMT, "Dave Brydon"
<db*****@ns.sympatico.ca> wrote:
Access 2003

Several days ago, I deleted a field from a table, which was no longer
required. Additionally, all associated elements for this field were also
removed from the database, i.e. from Forms, Queries, Reports.

However, every time I open my main form, or any form associated with the
main form, I receive a Prompt: Enter Parameter Value -
tblPersonnel.PCivilianSIN

The table was: tblPersonnel, and the field was called: PCivilianSIN

I have performed a search on my entire database, I have imported my database
into a new database, I've recompiled, and I can't find, nor get rid of this
Prompt.


Oh, it's there, alright. You just can't find it.

SpeedFerret? Hex editor?

The most likely cause, IMO, is the inclusion of this field in the
query of a rowsource.

DJ
Nov 13 '05 #2

P: n/a
"Morning DJ" wrote:
The most likely cause, IMO, is the inclusion of this field in the
query of a rowsource.


The wee nat was in a combo-box rowsource.

You've just saved my hair from turning grey(er), not to mention you have
made my day.it's these little things in life, I've come to appreciate.

Many thanks!

Dave
Nov 13 '05 #3

P: n/a
Also...

.... I've seen prompts for deleted fields show up in reports. It took
me a while before I found it still hidden in the "Sorting and
Grouping"!

Nov 13 '05 #4

P: n/a
On 4 Feb 2005 09:32:51 -0800, "st**********@gmail.com"
<st**********@gmail.com> wrote:
Also...

... I've seen prompts for deleted fields show up in reports. It took
me a while before I found it still hidden in the "Sorting and
Grouping"!


Yeah, that's a good hiding place, as well.

DJ
Nov 13 '05 #5

P: n/a
Per Dave Brydon:
I have performed a search on my entire database, I have imported my database
into a new database, I've recompiled, and I can't find, nor get rid of this
Prompt.

Any suggestions are most welcome!


If it's in a linked table, delete and then re-create the link
--
PeteCresswell
Nov 13 '05 #6

P: n/a
I appreciate all the suggestions, and have, or am in the process of checking
them all. This is one of those lessons I will indeed remember.very
frustrating.

Again, Many thanks to all!!

Cheers,

Dave
Nov 13 '05 #7

P: n/a

st**********@gmail.com wrote:
Also...

... I've seen prompts for deleted fields show up in reports. It took
me a while before I found it still hidden in the "Sorting and
Grouping"!


THANK YOU!!! I was about to kill myself over the same problem.. owe
you one, strauss

Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.