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
Printable View
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
Hi, there.
You can get this error if you did not set RecordSource property of Data control.
Larisa
Grr..
OK, I wrote:
Data1.RecordSource = Data1
Data1.Recordset.AddNew
Sorry, I really am new to
DataBases.. Wanna Help??
(
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
Thankyou so much!
Ill look up to you forever. lol.
:)