Can not open my form or query - invalid argument

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

Guest

Hello,

I can not open my Form or Query. I got an error message 3001 Invalid
argument. What can I do to fix this problem. I was in the form - then an
errors # popup in every field. I did a compact and repair, and rebooted my
system, and still can not open the form or query.

This database is on the server.

Bessie
 
Hello,

I can not open my Form or Query. I got an error message 3001 Invalid
argument. What can I do to fix this problem. I was in the form - then an
errors # popup in every field. I did a compact and repair, and rebooted my
system, and still can not open the form or query.

This database is on the server.

Bessie
Click to expand...

Fix the error in the query. It's got an invalid argument, probably to
some function call.

If you would like help solving the problem, please remember that we
are not telepathic and we cannot see your computer screen. It would
help if you opened the query in SQL view and posted the SQL text here.

John W. Vinson[MVP]
 
John Vinson said:
Fix the error in the query. It's got an invalid argument, probably to
some function call.

If you would like help solving the problem, please remember that we
are not telepathic and we cannot see your computer screen. It would
help if you opened the query in SQL view and posted the SQL text here.

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

Hi John,

This is my SQL
SELECT [AV Services].AVID, Customer.CFirstName, Customer.CLastName,
Customer.EmailAddress, Customer.Department, [AV Services].Entrydate, [AV
Services].CustomerID, [AV Services].[AVID#], [AV Services].employeeID, [AV
Services].Account, [AV Services].Building, [AV Services].Room, [AV
Services].AVOption, [AV Services].Site, [AV Services].AVNotes, [AV
Services].[Invoice Notes], [AV Services].OKtoBill, [AV
Services].ProjectionistName, [AV Services].Hour, [AV Services].HourlyRate,
[hour]*[hourlyrate] AS PCost, [AV Services].Start, [AV Services].End, [AV
Services].Time, [AV Services].Production, [AV Services].ClosingDate,
Customer.Company, Customer.PhoneNumber, Customer.FaxNumber, Customer.Address,
[AV Services].VendorName, [AV Services].VenInvoice, [AV
Services].VenDescription
FROM Customer INNER JOIN [AV Services] ON Customer.CustomerID = [AV
Services].CustomerID;

How can I fix the problem.
 
Bessie said:
John Vinson said:
Fix the error in the query. It's got an invalid argument, probably to
some function call.

If you would like help solving the problem, please remember that we
are not telepathic and we cannot see your computer screen. It would
help if you opened the query in SQL view and posted the SQL text here.

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

Hi John,

This is my SQL
SELECT [AV Services].AVID, Customer.CFirstName, Customer.CLastName,
Customer.EmailAddress, Customer.Department, [AV Services].Entrydate, [AV
Services].CustomerID, [AV Services].[AVID#], [AV Services].employeeID, [AV
Services].Account, [AV Services].Building, [AV Services].Room, [AV
Services].AVOption, [AV Services].Site, [AV Services].AVNotes, [AV
Services].[Invoice Notes], [AV Services].OKtoBill, [AV
Services].ProjectionistName, [AV Services].Hour, [AV Services].HourlyRate,
[hour]*[hourlyrate] AS PCost, [AV Services].Start, [AV Services].End, [AV
Services].Time, [AV Services].Production, [AV Services].ClosingDate,
Customer.Company, Customer.PhoneNumber, Customer.FaxNumber, Customer.Address,
[AV Services].VendorName, [AV Services].VenInvoice, [AV
Services].VenDescription
FROM Customer INNER JOIN [AV Services] ON Customer.CustomerID = [AV
Services].CustomerID;

How can I fix the problem.
Click to expand...

I think I found the problem: I have one record that is effective with
#Error that is causing the problem, I can not delete or fix it.

How can I fix it?
 
I think I found the problem: I have one record that is effective with
#Error that is causing the problem, I can not delete or fix it.

How can I fix it?
Click to expand...

Your database is corrupt!

Make a backup *right away* before doing anything else. You may need it
later.

Check the suggestions at Tony Toews' website:

http://www.granite.ab.ca/access/corruptmdbs.htm

What you'll probably need to do is create a new, empty database;
import all the tables and other objects EXCEPT for this one. Create
this table anew, empty. Link to the damaged database's instance of the
table and run an Append query selecting all but this one #Error#
record; you'll need to use a criterion on the primary key to
specifically select the good records (otherwise you'll just import the
corruption).

John W. Vinson[MVP]
 
Back
Top