hi! can someone help me with my problem, I'm using msaccess2003 and vb6. I've been trying to determine how can I save data using one form to two database. the scenario is like this, I have one form, the details of some information of the customer will be input in the info table while the his payment will be saved in the bill table.
Here is my proposed code for saving
Dim RS As Recordset Set RS = New Recordset Set RS = cn.Execute("select * from weddingrecords leftjoin payment on weddingrecords.NameofBride = payment.Bride where TransactionNumber '" & tn.Text & "'") If RS.EOF Then MsgBox "Transaction Not Found", vbExclamation End If
I will also take the opportunity to ask for the search, delete and update buttons :)
I hope someone can help me. Thanks in advance!