A a_20120 tan Local time Tomorrow, 01:04 Joined Nov 21, 2006 Messages 175 Dec 14, 2006 #1 How can I find the Max of a table field in VB, suppose you, when you want to add students, his ID should be automatically added.
How can I find the Max of a table field in VB, suppose you, when you want to add students, his ID should be automatically added.
A a_20120 tan Local time Tomorrow, 01:04 Joined Nov 21, 2006 Messages 175 Dec 27, 2006 #2 Max of Table Field In VB No one is to reply me for the above problem... Please guide me how I can I get the max of a field (ID NO) of Table in VB.
Max of Table Field In VB No one is to reply me for the above problem... Please guide me how I can I get the max of a field (ID NO) of Table in VB.
R Rickster57 Registered User. Local time Today, 13:34 Joined Nov 7, 2005 Messages 431 Dec 27, 2006 #3 increment newidnumber= DMax("[idno]", "thetable") + 1 me.idno=newidnumber or something similar to the above where you have dimensioned the variable newidnumber
increment newidnumber= DMax("[idno]", "thetable") + 1 me.idno=newidnumber or something similar to the above where you have dimensioned the variable newidnumber
