problem with database

[paok]

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

[seenu_1st]

if you want more infomration write it

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

[Doogle]

Take a look at the MAX Function in SQL. eg

SELECT MAX(columnname) AS maxnumber FROM table

[paok]

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?

[akhileshbc]

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