Ignore "Invalid Argument" error message

[tighe]

all,

is there a way to suppress/ignore/not recieve an "invalid argument" from an
import?
i recieve the error but all data is imported. i posted a similar question
to the import section of the board and it is below, since the data comes
through i figured ignoring the errors would suffice.

thanks in advance. AC2007/XP.

tighe, other posts string:

tighe,

Next thing I would check for is Reserved Words, Access 2007 is alot more
picker then previous versions...
http://allenbrowne.com/AppIssueBadWord.html

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[pietlinden]

Only way I can think of doing it (if it works) is to trap for the
specific error number this error raises. You would use an error
handler and then use Resume Next.

Private Sub MySubThatIgnoresError12000()
On Error Goto ErrHandler

' steps for import go here...

Exit Sub

ErrHandler:
If Err.Number = 12000 Then
Resume Next
Else
' handle the error
End If

End Sub

But if the code does not give you an error number, then you can't trap
it. (You might need to turn off/comment out the error handling you
have in the routine to intentionally raise the error once so you know
the #.)