Search results for query: *

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...

I'm using VB6 and ADODC to manipulate an ACCESS 2000 database. I can already scroll up (or scroll down) through the database, and have the selected portions of the current record displayed in textboxes. I wish to use the correct syntax to specify (and delete) a particular record. Much of the...

Serial ports are slow, can you use a network port on both devices. The keyword is WINSOCK.

I can already get the AbsolutePosition of a record by clicking on it with my mouse. I'd just like to go a bit further and use it to access each field.

I would prefer not to use the EDIT|Go TO|Next procedure, because it could take many iterations if there are several hundred records.

I'm using VB Professional 6.0 and Access 2000. With much help, I've got the Access 2000 database (on my desktop) to work with VB6 and the ADO DC (on my mobile PC). To ease changing the Access 2000 database, I'd like a simple mouse-based technique, to select the record I'd like to...