delete error tables

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

Guest

I am trying this code in VBA and i am gettting this erro

"data type mismatch"

Please help!!!!!
 
dimpie said:
If Right(dbCurr.TableDefs(intLoop), 6) = "Errors" Then
Click to expand...


Check the name of the table"

If Right(dbCurr.TableDefs(intLoop).Name, 6) = "Errors" Then
 
the name of one of the table is "Summary$_ImportErrors". this is the name
generated by access when i import.
 
As Marsh correctly pointed out, I left off the name of the property (which
happens to be Name):

If Right(dbCurr.TableDefs(intLoop).Name, 6) = "Errors" Then


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


dimpie said:
If Right(dbCurr.TableDefs(intLoop), 6) = "Errors" Then
Click to expand...
 
you are a great!!!!! IT WORKS!!!!!!!! Thanks a bunch guys. Dont know what i
would do without your help.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date w/ Access & SQL Server 1
Data type issue when importing from excel to access 1
PivotTable: Type Mismatch 0
runtime error 3075 - missing operator 1
Compile Error: Type Mismatch 3
"%" character 1
Word VBA for deleting Selected Row 0
Runtime Error 3157 1

Back
Top