473,320 Members | 2,107 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,320 software developers and data experts.

Parameter Prompt for field, which was deleted from table

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
7 5439
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
"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
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
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
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
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

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

Similar topics

7
by: Marco Simone | last post by:
Hi, What is your opinion about using Lookup field in table. I would like to use lookup field in table 1, so that I can choose data in combo box from table 2. Is this good design of database? ...
1
by: P51D | last post by:
I have a listbox in the headere of a form with the details below. Once the form's open it works properly, allowing me to select a record and see the related details. On opening the form,...
4
by: Stephen Poley | last post by:
I have a pair of tables (Applicaties en Releases) in a 1-to-N relation. I created and tested a report based on Applicaties. I then added a subreport based on Releases using the wizard. This...
0
by: Helen | last post by:
Here's the code: how do I prevent the parameter prompt from appearing during run time? Thanks Imports CrystalDecisions.CrystalReports.Engin Imports CrystalDecisions.Share Public Class Form...
4
by: Bonzol | last post by:
..Net 2003, 1.1, Access database. oledb connection Hey there, I had my program updating to the database with a dataset,,, doing things the easy way, binding the dataset to the text box n such,...
4
by: bdockery | last post by:
Access 2007 I have a table with three columns. Country, State, City What I want to do is have a form where the Country, and State, lookups auto-populate when the city lookup is chosen. It...
10
by: Hugh Middity2 | last post by:
Hello, is there a parameter value field in access that can be passed between queries, forms and reports? For example, we have two companies both selling the same products. To extract data we have to...
6
by: MLH | last post by:
Utilities to recover tbl removed from TABLE tab of database window with the DELETE key?
13
by: jboisa | last post by:
I have the calculated field below, which runs fine by itself. When I put a selection criteria (3) into the query, however, I get these unexplained parameter prompts. I'm running Access 2002 on...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.