#Error

[John]

How can I delete a record in my table that has #Error in
it. I can't find out what the error is for. I think it
was when I was importing data to the table.

Please let me know.

Thanks,

John

 

[Ken Snell]

Often that results when ACCESS could not properly convert/store a value in a
record's field because it didn't match the field's format.

To delete it manually, open the table, navigate to that record, and then
delete that record. Or are you looking for some other process?

 

[John]

I have tried that and it won't let me do it. I keep
getting an error message that says "Invalid Argument" and
when I try to delete the entry that error will pop up
about 4 times (everytime I click OK it will come back) and
the entry will still be there.

John

 

[Ken Snell]

Are you in the table itself, or in a form that is bound to the table? I
would think that that error is occurring with a form's code that is running
in the background, and it suggests that a function in that code can't handle
the #Error value.

 

[Ken Snell]

If you can zip up the database, email it to me at (e-mail address removed) and
I'll take a look. Identify in the email the specific table and record of
interest.