Recent content by THOMASNG

John's answer was the clearest one. Have a star! My manager has decided to have the query done by the second computer (not the one with ADODC and VB6). (Gee, thanks.)

I'm having trouble triggering a query (SQL query?) off of the VB6 event of clicking on a button (Cmd_FindMatchingRecords_Click).

Way too vague to implement.

I'm using VB6 and ADODC to manipulate an ACCCESS 2000 database. From time to time, I wish to check the database for old data. As the database may range up to 30,000, I'd like to see only those that have the same (OwnerCode & SerialNumber) or have LatestScan < a certain date. OwnerCode &...

In my opinion, VB5, is buggy. VB6 is much better at text-file manipulation. See if you can go to VB6 and VB.Net.

Please call me back when you get #1 working.

Yup! After placing a MsgBox, I discovered that I had misnamed &quot;Txt_Owner.Text&quot; to its fullname, &quot;Txt_OwnerCode.Text&quot;. After correcting this error, it now works great! Have a second star!

Nope, I'm calling directly from a form. Checked my spelling, but got the same error message as before.

Modified per your request, but now I'm getting an error message from VB6 compiler &quot;Run-time error '424' : Object required.&quot; Temporarily changed it back to &quot;OOOO&quot;, and didn't get the error message.

As you're using MSComm, I assume you're using VB6 or VBNet. 1) Can you exchange I/O using the free HYPERLINK? (It should be under Start|Programs|Accessories.) This should ensure that you're using the proper type of cable (regular PC-to-modem or PC-to-PC) and...

OK. The Adodc1.Recordset.Delete works 100%. The Cmd_ModifyRecord|Click procedure works only when I pass it a piece of text directly, ie. Adodc1.RecordSet.Update &quot;OwnerCode&quot;, &quot;OOOO&quot; &quot;OwnerCode&quot; is just the name of the field that I wish to alter...

Give the man a star!

Look, let's keep this simple! Using &quot;cmd_ScrollUp_MouseDown&quot; and cmd_Scrolldown_MouseDown&quot;, I have already selected the particular record that I wish to delete or change a field in. I even have stored the value of this particular record in a global variable. Now I wish to...

I've corrected my syntax to uniformly refer to CRTable1.mdb, not &quot;.mde&quot; at times. Also, I don't always want to delete a record, sometimes I just want to change just one of its fields. Tom Ng

I've modified the code to: Private Sub cmd_DeleteRecord_Click Dim cmdDelete As New ADODB.Command Dim str_Conn As String str_Conn = &quot;Provider=Microsoft.Jet.OLEDB.4.0&quot; & DataSource=C:\Access VBA Practice _Files\CCRTable1.mde;Persist Security Info=False&quot...