Setting Parameter values

D

Dave Radziewicz

I have an error message noting to enter a parameter value on the main query.
The entry that it is specifying has been taken off of all tables and queries
and the message is still coming up. I have also ran Compact and Compare
Database and it still has not corrected this issue. Any ideas?
 
A

Allen Browne

Suggestions:

1. In query design view, open the Properties box.
Looking at the Properties of the query (not of a field), is there anything
beside the Filter or Order By properties?

2. What happens if you switch the query to SQL View, copy the SQL statement
to clipboard, then create a new query, switch it to SQL View, and paste the
query statement in?

3. Did you make sure that Name AutoCorrect was off?
Explanation of why:
http://allenbrowne.com/bug-03.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
D

Dave Radziewicz

I tried the below and nothing seems to be working. I even deleted the query
and rebuilt the query. I did have a field with the name on it but I either
deleted it on the main table or over wrote it. I am at lost to were to go any
other suggestions? Thanks
 
A

Allen Browne

Post the SQL statement here.

Indicate the exact name that pops up in the Title Bar of the dialog when
Access asks you for the parameter.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
 
D

Dave Radziewicz

SELECT [A Main table].[Date Called into MCU], [A Main table].[Date of Loss],
[A Main table].[Field Office], [A Main table].Region, [A Main table].[Claim
Number], [A Main table].Insured, [A Main table].[Loss Exposure], [A Main
table].[EGA Cluster], [A Main table].[CAT Code], [A Main table].[Reported
by], [A Main table].[Heavy Equipment], [A Main table].[Reason LIFO], [A Main
table].[Entered by], [A Main table].[Reason Code], [A Main table].Reserve, [A
Main table].[Closing Date], [A Main table].DNR, [A Main table].[Amount Paid],
[A Main table]![Date Called into MCU]-[A Main table]!DNR AS [Age of Claim],
[A Main table].[Time called in], [A Main table].[Completed date and time], [A
Main table].[Field Claim Handler], [A Main table].[Assigned to GA], [A Main
table].Comments, [A Main table].[Date Assigned], [A Main table].[Loss
Address], [A Main table].[Loss Address1], [A Main table].[Loss City], [A Main
table].[Loss State], [A Main table].[Loss Zip Code], [A Main table].[Insured
Mailing address], [A Main table].[Insured Mailing address1], [A Main
table].[Insured City], [A Main table].[Insured State], [A Main
table].[Insured zip code], [A Main table].[Insured contact], [A Main
table].[Insured contact phone number], [A Main table].[Policy Number], [A
Main table].[Date and Time LLN sent], [A Main table].[LLN sent by], [A Main
table].[Marketing indicator], [A Main table].[Type of Claim], [A Main
table].[C&O Assignment], [A Main table].[Misc supporting date], [A Main
table].Advance, [A Main table].[Contact Screen Completed], [A Main
table].Type, [A Main table].[PI Adj List], [A Main table].[Claims
Representative], [A Main table].[PI GA list], [A Main table].[BI GA list], [A
Main table].[BI Cluster List], [A Main table].[PI Cluster List], [A Main
table].[PL Market Code], [A Main table].[CL Market Code], [A Main
table]![Date Called into MCU]-[A Main table]![Completed date and time] AS
[Comp Turn Around Time]
FROM [A Main table]
ORDER BY [A Main table]![Date Called into MCU]-[A Main table]![Completed
date and time];

Here is the enter the parameter value message.

QueryMainTable.new claim
 
Top