Click to See Complete Forum and Search --> : DB Error I dont Understand
Dayo312
Jan 9th, 2000, 01:46 AM
What did I do wrong??
An Error comes up and says
"Object Variable or Block with variable not set".
It comes up with I try to open my DB,
It highlights this code:
Data1.Recordset.AddNew
LG
Jan 9th, 2000, 03:00 AM
Hi, there.
You can get this error if you did not set RecordSource property of Data control.
Larisa
Dayo312
Jan 9th, 2000, 03:26 AM
Grr..
OK, I wrote:
Data1.RecordSource = Data1
Data1.Recordset.AddNew
Sorry, I really am new to
DataBases.. Wanna Help??
(
LG
Jan 9th, 2000, 03:54 AM
Dayo312!
RecordSource property of data control you can set at design time. It's the name of your table or sql string. When you set DatabaseName property of Data control(at design time) and go to RecordSource property(click on it) it'll automaticly show you all tables for this database. Or you can write your sql statement here.
Larisa
Dayo312
Jan 9th, 2000, 04:46 AM
Thankyou so much!
Ill look up to you forever. lol.
:)
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.