Parameter Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am using a parameter query to locate records in a table. when i enter the
criteria to do the search i get an error message: numeric overflow! and only
#Name# is displayed under each column in the search result. can someone help
please
 
i am using a parameter query to locate records in a table. when i enter the
criteria to do the search i get an error message: numeric overflow! and only
#Name# is displayed under each column in the search result. can someone help
please
Click to expand...

Yes, if you'll let us see what you're doing. Your query is not visible
from here!

Please open it in SQL view and post the SQL text here.

John W. Vinson[MVP]
 
SQL text:

SELECT [Cross Reference Table].DESCRIPTION, [Cross Reference Table].[SEARCH
DESCRIPTION], [Cross Reference Table].[PART NUMBER], [Cross Reference
Table].[Level 1], [Cross Reference Table].[Level 2], [Cross Reference
Table].[Level 3], [Cross Reference Table].[Level 4], [Cross Reference
Table].[Level 5], [Cross Reference Table].[Level 6], [Cross Reference
Table].[Machining Drawing Number]
FROM [Cross Reference Table]
WHERE ((([Cross Reference Table].[Machining Drawing Number])=[Enter Number]));

thank you.
 
SQL text:

SELECT [Cross Reference Table].DESCRIPTION, [Cross Reference Table].[SEARCH
DESCRIPTION], [Cross Reference Table].[PART NUMBER], [Cross Reference
Table].[Level 1], [Cross Reference Table].[Level 2], [Cross Reference
Table].[Level 3], [Cross Reference Table].[Level 4], [Cross Reference
Table].[Level 5], [Cross Reference Table].[Level 6], [Cross Reference
Table].[Machining Drawing Number]
FROM [Cross Reference Table]
WHERE ((([Cross Reference Table].[Machining Drawing Number])=[Enter Number]));

thank you.
Click to expand...

And you get this error just by opening this query as a query
datasheet?? Odd, and probably worrisome.

Try turning off Name Autocorrect in Tools...Options... General; it can
cause wierd errors like this. Then use Tools... Database Utilities...
Compact and Repair Database. Can you open [Cross Reference Table] and
see the data without getting errors?

John W. Vinson[MVP]
 
o.k thank you i'll try doing that.

John Vinson said:
SQL text:

SELECT [Cross Reference Table].DESCRIPTION, [Cross Reference Table].[SEARCH
DESCRIPTION], [Cross Reference Table].[PART NUMBER], [Cross Reference
Table].[Level 1], [Cross Reference Table].[Level 2], [Cross Reference
Table].[Level 3], [Cross Reference Table].[Level 4], [Cross Reference
Table].[Level 5], [Cross Reference Table].[Level 6], [Cross Reference
Table].[Machining Drawing Number]
FROM [Cross Reference Table]
WHERE ((([Cross Reference Table].[Machining Drawing Number])=[Enter Number]));

thank you.
Click to expand...

And you get this error just by opening this query as a query
datasheet?? Odd, and probably worrisome.

Try turning off Name Autocorrect in Tools...Options... General; it can
cause wierd errors like this. Then use Tools... Database Utilities...
Compact and Repair Database. Can you open [Cross Reference Table] and
see the data without getting errors?

John W. Vinson[MVP]
Click to expand...
 
Back
Top