creating job numbers automatically

B

Barb

Hi there guys,
I am currently the poor dodo assigned at work to update a database....and
have only basic understanding of access..

We work on job numbers and what I need to do is have dataentry in a form
that has the next sequential number to be allocated automatically to save
having to manually look it up.

This auto field would have to have text and numbers and has the following
example: DUB06 then the next number (dub is the allocated town which doesnt
change, 06 is the year)
any help most appreciated
Barb
 
K

KARL DEWEY

Here is one solution. Use a totals query to find the maximum number. Parse
it and increment by one. Use this query as record source for an unbound text
box on your form and label 'Next number.'

In the regular text box have DoubleClick call a macro to SetValue from
unbound text box to the regular text box.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top