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 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
"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
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"!
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
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
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 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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?
...
|
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,...
|
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...
|
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...
|
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,...
|
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...
|
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...
|
by: MLH |
last post by:
Utilities to recover tbl removed from
TABLE tab of database window with
the DELETE key?
|
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...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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...
|
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...
| | |