Access keeps asking to enter parameter value
11,947
Your query doesn't have anything in it about "Death: duplicate account numbers.Acc Number", so there must be some code elsewhere looking for that parameter. As long as its in the code somewhere, you will get the prompt.
NOTE: Make a copy before making doing the below.
Here is a way to find the rouge code:
- Open the VBA window, (Alt+F11).
- Then use Ctrl+H to open the Replace window.
- Type
Acc Number
in the "find what" window. - Type
AccountNumber
in the "replace with" window. - Choose
Current Project
- Use the "Find Next" button to find any missed references.
- If you find a reference needing changed, click "replace".
- After changing all found references debug the code, run it to see if it works as you desire.
Related videos on Youtube
Author by
Aaa
Updated on September 18, 2022Comments
-
Aaa over 1 year
I have the following query in Access:
SELECT Death.AccountNumber, Count(*) AS NumberOfRecords FROM Death GROUP BY Death.AccountNumber HAVING (((Count(*))>1));
The field AccountNumber has previously been [Acc Number] but this has been updated in both the source Excel spreadsheet to which the Access table is linked and the SQL code in the query.
Nevertheless, every time I run the query Access still prompts me to "Enter Parameter Value" with the description: "Death: duplicate account numbers.Acc Number".
How do I get Access to stop displaying this prompt?