Spanish beginne Posted January 14, 2003 Posted January 14, 2003 Hi all! Well, I'm working on a personal application to manage one of my personals Access databases. In particular, the problem I'm having is related to a SELEC MAX. I need to do this in order to add 1 and have the index of the row I want to insert. But I do not know how to perform this in Visual Basic.Net Does anybody knows how to handle this situation? Is that possible to have two diferent "statements" in the same form to the same table (one for the MAX statement and another for selecting/updating/deleting rows)? Thanks to all and greetings from Spain! Quote
Moderators Robby Posted January 14, 2003 Moderators Posted January 14, 2003 I would place them into two different functions, and make them very generic so that you can use them troughout the application. Quote Visit...Bassic Software
*Experts* Nerseus Posted January 14, 2003 *Experts* Posted January 14, 2003 Is it possible to use Access's AutoNumber column type? It would work pretty much the same but you wouldn't have to run a separate query to generate the next number (which might also have issues with timing). -Nerseus Quote "I want to stand as close to the edge as I can without going over. Out on the edge you see all the kinds of things you can't see from the center." - Kurt Vonnegut
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.