Results 1 to 5 of 5

Thread: DB Error I dont Understand

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Nov 1999
    Posts
    184

    Post

    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

  2. #2
    Hyperactive Member
    Join Date
    Jun 1999
    Posts
    308

    Post

    Hi, there.
    You can get this error if you did not set RecordSource property of Data control.

    Larisa

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Nov 1999
    Posts
    184

    Post

    Grr..

    OK, I wrote:

    Data1.RecordSource = Data1
    Data1.Recordset.AddNew

    Sorry, I really am new to
    DataBases.. Wanna Help??

    (

  4. #4
    Hyperactive Member
    Join Date
    Jun 1999
    Posts
    308

    Post

    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

  5. #5

    Thread Starter
    Addicted Member
    Join Date
    Nov 1999
    Posts
    184

    Post

    Thankyou so much!
    Ill look up to you forever. lol.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width