Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Unanswered: Help with the ADODC data control

    I have placed an ADODC data control on a form (named Adodc1)and I want to link it to either an Access2000 mdb or Access97 mdb whichever one works. I have tried both . I have used the following connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\test\My Documents\Ac2Vb\Order Entry1.mdb;Persist Security Info=False. Tested the connection and Vb says 'Test connection succeeded'.
    Now I have placed a simple textbox on the form and set its data source to the ADODC data control (Adodc1). When I try to click in the data propertys field of the text box I get the message '[ADODC]:no record source specified.[ADO] command text was not set for the command object. I am confused cos I have set the data source to (Adodc1).

    Can any one help


  2. #2
    Join Date
    Nov 2004
    You have to write the sql string for the Adodc control i believe so that the text box gets the value

Posting Permissions

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