G
Guest
I am trying this code in VBA and i am gettting this erro
"data type mismatch"
Please help!!!!!
"data type mismatch"
Please help!!!!!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J. Steele
What line is causing the error?
G
Guest
If Right(dbCurr.TableDefs(intLoop), 6) = "Errors" Then
G
Guest
If Right(dbCurr.TableDefs(intLoop), 6) = "Errors" Then
M
Marshall Barton
dimpie said:If Right(dbCurr.TableDefs(intLoop), 6) = "Errors" Then
Check the name of the table"
If Right(dbCurr.TableDefs(intLoop).Name, 6) = "Errors" Then
G
Guest
the name of one of the table is "Summary$_ImportErrors". this is the name
generated by access when i import.
generated by access when i import.
D
Douglas J. Steele
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!)
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
G
Guest
you are a great!!!!! IT WORKS!!!!!!!! Thanks a bunch guys. Dont know what i
would do without your help.
would do without your help.