<div>
I think you should bind the recordset's recordsource to a recordset and not a string as you are doing. Try making the following changes:<br />
<br />
<br />
Private Sub Form_Load()<br />
Dim SsqlD &nbsp;As String<br />
SsqlD = &quot;DELETE * FROM Table1”<br />
Me.Adodc1.Recordset.Source<wbr />. = SsqlD<br />
Me.Adodc1.Refresh<br />
End sub<br />
-priya<br />
<br />

</div>


I think you should bind the recordset's recordsource to a recordset and not a string as you are doing. Try making the following changes:


Private Sub Form_Load()
Dim SsqlD  As String
SsqlD = "DELETE * FROM Table1”
Me.Adodc1.Recordset.Source. = SsqlD
Me.Adodc1.Refresh
End sub
-priya



<div>
sorry this line ..<br />
Me.Adodc1.Recordset.Source<wbr />. = SsqlD<br />
<br />
should be..<br />
Me.Adodc1.RecordSource = SsqlD<br />
and then the refresh thing..<br />
<br />
hope this helps<br />
-priya
</div>


sorry this line ..
Me.Adodc1.Recordset.Source. = SsqlD

should be..
Me.Adodc1.RecordSource = SsqlD
and then the refresh thing..

hope this helps
-priya

<div>
If you have connection object <br />
<br />
ConDb.Execute(&quot;DELETE * FROM Table1&quot;) <br />
<br />
will do the needful.
</div>


If you have connection object

ConDb.Execute("DELETE * FROM Table1")

will do the needful.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
<br />
the following code gives me this error: &quot;Object variable or with block variable not set &quot;<br />
<br />
Private Sub Form_Load()<br />
Dim SsqlD &nbsp;As String<br />
<br />
<br />
SsqlD = &quot;DELETE * FROM Table1”<br />
<br />
Me.Adodc1.LockType = adLockOptimistic<br />
Me.Adodc1.Recordset.Source<wbr />. = SsqlD<br />
<br />
please help by amending this code<br />
<br />
asns
</div>
</div>


Hi,


the following code gives me this error: "Object variable or with block variable not set "

Private Sub Form_Load()
Dim SsqlD  As String


SsqlD = "DELETE * FROM Table1”

Me.Adodc1.LockType = adLockOptimistic
Me.Adodc1.Recordset.Source. = SsqlD

please help by amending this code

asns

please amend this code

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.