problem with database

dear vbforum,
im writing this thread to ask about updating database automatically

i want the programme to do this:
go to guestinfo(database)> then go to guest id from this get the bigest number and add form this number one and placed it in the updating database
i want

if you want more infomration write it

yours,
paok

Quote:

---

if you want more infomration write it

---

yes need more info, any code u tried and what is the problem?

Take a look at the MAX Function in SQL. eg

Code:

---

SELECT MAX(columnname) AS maxnumber FROM table

---

Code:

---

Private Sub Command1_Click()
   
    ConnectDB
   
        rs.Open "guestinfo", db, 3, 3
             
              rs.AddNew
                    rs(1) = txtFullName
                    rs(2) = txtAddres
                    rs(3) = txtPhoneNo
                    rs(4) = cboGender
                    rs(5) = txtAge
              rs.Update
        Set rs = Nothing
    db.Close: Set db = Nothing
   
    MsgBox "Successfully added new record!", vbInformation, "Save"
    txtFullName = Empty
    txtAddres = Empty
    txtPhoneNo = Empty
    cboGender = Empty
    txtAge = Empty
   
    LoadData 'to refresh records
   
End Sub

---

for this piece of code how and where i have to write it?

Have a look at this section: http://www.vbforums.com/showthread.php?t=337051#ado

Mainly this one: http://www.vbforums.com/showthread.php?t=461226

:wave: