
AddNew/Update command & field searches
Please help me I have two VB 3.0 problems
PROBLEM 1.) While using the AddNew / Update combination on a dynaset I
recieve a compile error on the line dsDynaSet.Update. Here is the error
msg
"Reserved error (-18261);there is no message for this error"
Can anyone tell me what this means I believe my syntax is correct...here
is the actual src:
'Add service record portion
dsCurrServices.AddNew
dsCurrServices.Fields("ServiceID") = GetNextServiceID()
dsCurrServices.Fields("CarID") = CURR_CAR_ID
dsCurrServices.Fields("Miles") = txtMiles.Text
dsCurrServices.Fields("Part") = cboPart.Text
dsCurrServices.Fields("Action") = cboAction.Text
dsCurrServices.Fields("Notes") = txtNotes.Text
dsCurrServices.Fields("ServiceCenterID")=3
dsCurrServices.Update 'GET THE ERROR On THIS LINE
PROBLEM 2.) I need a very efficient way to do a partial search on a
table/dynaset. For ex. search a table for the first record that begins
with "bro" after the search the current record could be brooks,
brookstein, depending on what was the first rec encountered. Any ideas
on this using the standard VB tools. I want to create a searchable text
box that after every char typed in it does a search for a match in a
table/dynaset... kinda of like the quicken 3.0 quick search fields
please leave me e mail ...Thanks so much