MS Access

andy5179 · #1 Jun 28, 2005, 05:54 AM

I set up users in a database on a daily basis. There has been a recent change where I need to assign each of them to a number between 800 and 899, in sequential order. How can I do this, using VB or ACCESS, so that the variable isn't lost when the application is closed? In other words, if I add a user today and it's assigned 820, when I close the program, and reopen it tomorrow, I need it to pick up where it left off with 821 as the next assigned number.

andy5179 · Jun 28, 2005, 06:14 AM

Can I just use a query to update the field? Its still a little fuzzy.

andy5179 · Jun 28, 2005, 06:24 AM

But when the number gets to 899, I need the next one to reset at 800. How can I accomplish this?



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!