Invalid argument error with creatingdatabase in vb6

Hello,

For some reason I get an invalid argument error with attached code or attached pic.
Error line is marked with : ERROR LINE

Could someone help me out?
Regards,
Dennis
Function Create_Database()
 
Dim dbnewDB As Database
Dim tdnewtable As tabledef
Dim fld As field
Dim idx As Index
 
 
Set dbnewDB = createdatabase("c:\structure\Dennis.mdb", dblanggeneral)
Set tdnewtable = New tabledef
Set fld = tdnewtable.createfield("Title", dbtext, 20)
tdnewtable.fields.append fld
Set fld = tdnewtable.createfield("Open", dbMemo, 20)
tdnewtable.fields.append fld
Set fld = tdnewtable.createfield("High", dbMemo, 20)
tdnewtable.fields.append fld
Set fld = tdnewtable.createfield("Low", dbMemo, 20)
tdnewtable.fields.append fld
Set fld = tdnewtable.createfield("Close", dbMemo, 20)
tdnewtable.fields.append fld
Set fld = tdnewtable.createfield("Signal_1", dbMemo, 20)
tdnewtable.fields.append fld
Set fld = tdnewtable.createfield("Equity_1", dbMemo, 20)
tdnewtable.fields.append fld
Set idx = tdnewtable.createindex
With idx
.Name = "idxTitle"
.fields.append.createfield ("Title") 'ERROR LINE
 
End With
tdnewtable.indexes.append idx
tdnewtable.Name = "tblcollection"
dbnewDB.tabledefs.append tdnewtable
 
Set dbnewDB = Nothing
 
 
 
End Function

Open in new window

invalid.jpg
SchuttendAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
change:

.fields.append.createfield ("Title")

into (not the SPACE between append and .createfield:

.fields.append  .createfield ("Title")  
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
SchuttendAuthor Commented:
Thanks for the great help!

Regards,
Dennis
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.