how to set a certain format

  • Thread starter bhrosey via AccessMonster.com
  • Start date
B

bhrosey via AccessMonster.com

I have what I believe to be a very simple problem for all of you who know
Access better than me. I am using Access 2007 and have a field in my table
where an operator would enter a job number. I want to force them to use a
certain number/text format to insure continuity. Here is a sample of what
some of the job numbers could look like,
09-7654 P/1
10-9076 JD/2.3
09-3425 DS/10.2
10-2579 P/10.12

Thank you for the help. I already figured out how to make sure that caps get
used instead of lowercase.
 
J

Jerry Whittle

It looks like that job number has different 'parts' that have meaning. If so
you'd be much better of having them broken down into 3 or 4 different fields.
Then recombine them afterwards. Then you could use things like input masks
and validation rules to ensure that the data entered is most likely correct.
 
S

Steve

What would be best is when the job is first created a job number is assigned
and recorded in a job table. Then when any operator needs to add a job
number he selects the job number from a combo box based on the job table.

Steve
(e-mail address removed)
 
B

bhrosey via AccessMonster.com

The job number is already assigned ahead of time. It follows the job from
department to department. I have a field on my form where the job number
gets entered and I just want to make sure that the way it gets entered is
uniform, i.e. the space between the job and the lot #.
What would be best is when the job is first created a job number is assigned
and recorded in a job table. Then when any operator needs to add a job
number he selects the job number from a combo box based on the job table.

Steve
(e-mail address removed)
I have what I believe to be a very simple problem for all of you who know
Access better than me. I am using Access 2007 and have a field in my
[quoted text clipped - 10 lines]
get
used instead of lowercase.
 
B

bhrosey via AccessMonster.com

The job number is already assigned ahead of time. It follows the job from
department to department. I have a field on my form where the job number
gets entered and I just want to make sure that the way it gets entered is
uniform, i.e. the space between the job and the lot #.
What would be best is when the job is first created a job number is assigned
and recorded in a job table. Then when any operator needs to add a job
number he selects the job number from a combo box based on the job table.

Steve
(e-mail address removed)
I have what I believe to be a very simple problem for all of you who know
Access better than me. I am using Access 2007 and have a field in my
[quoted text clipped - 10 lines]
get
used instead of lowercase.
 
B

bhrosey via AccessMonster.com

Jerry, I like your suggestion. I wish I would have thought of that. So to
make sure I follow you, you are basically saying enter the job # (09-8478)
and the lot # (P/1.2) seperately, then I can always concatenate them later on
a report if I want. Thanks for the idea. That should work.

Jerry said:
It looks like that job number has different 'parts' that have meaning. If so
you'd be much better of having them broken down into 3 or 4 different fields.
Then recombine them afterwards. Then you could use things like input masks
and validation rules to ensure that the data entered is most likely correct.
I have what I believe to be a very simple problem for all of you who know
Access better than me. I am using Access 2007 and have a field in my table
[quoted text clipped - 8 lines]
Thank you for the help. I already figured out how to make sure that caps get
used instead of lowercase.
 
S

Steve

<<The job number is already assigned ahead of time. >>
Perfect! Put it in a table.

I'll bet the lot number is already assigned ahead of time too!! So put it in
a table also.

You can then use a combobox to select the job number and another combobox to
select the lot numer. Once you have these, you can concatenate the two of
them with a space between them.

Viola!!! Your combined job number and lot number gets entered uniformly
one-hundred percent of the time!!!!!

Steve
(e-mail address removed)




bhrosey via AccessMonster.com said:
The job number is already assigned ahead of time. It follows the job from
department to department. I have a field on my form where the job number
gets entered and I just want to make sure that the way it gets entered is
uniform, i.e. the space between the job and the lot #.
What would be best is when the job is first created a job number is
assigned
and recorded in a job table. Then when any operator needs to add a job
number he selects the job number from a combo box based on the job table.

Steve
(e-mail address removed)
I have what I believe to be a very simple problem for all of you who know
Access better than me. I am using Access 2007 and have a field in my
[quoted text clipped - 10 lines]
get
used instead of lowercase.
 

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