Z
Zetony
Please I need a help from you all. I have an MS-Access Database Program that
I wrote by converting from Lotus Application into Access. This program is now
working very well
My problem now is that my boss wants me to add an Auto generated Field in
the program. But this field will be partly generated from three other fields
that is the puzzling aspect of this program. In essence, he does not want me
to use the inbuilt auto generate, date and year that is in the system, rather
the ones the user will enter in other fields in the program.
TO BRIEF YOU:
I have a field called (1) DateRec, another (2) Municipality and another (3)
Type. These three fields invariably will automatically generate a string of
number for another field that will be called FileNumber. This FileNumber is
already the Primary Key in the program. The (1) is the date received, that is
the date the application of the client was received. (2) being the
Municipality will have one or two letter characters of each Municipality
within the County where the applicant is from. And (3) which is the type is
the state of the application, it will only be involved in the FileNumber,
when it is an "EXEMPT", then, the nomenclature will be; an 'E'.
Here comes the drill! When the user enters the date received, it will be a
complete date, with day, month and year. The only thing that will go to the
FileNumber will be the year, like 2006. When a Municipality is chosen by the
user, for instance Atlantic City, it will generate a nomenclature like 'AC',
if it is for Brigantine it will be a 'B'. Then the program will run a query
that will check for the last FileNumber entered under that Municipality
chosen and update it with one number. So the FileNumber will be something
like AC-2-2006, for another entry on this same Municipality it will be
AC-3-2006, AC-4-2006 etc. Then, when there is an Exemption in the
application, the user will select EXEMPT from Type, it will emerge the 'E'
with the middle number; like AC-5E-2006. This is all that is needed.
I definitely, need a help to get this working. The purpose for this is to
debar the user from entering wrong Filenumbers.
Thanks in anticipation for your help.
Anthony
I wrote by converting from Lotus Application into Access. This program is now
working very well
My problem now is that my boss wants me to add an Auto generated Field in
the program. But this field will be partly generated from three other fields
that is the puzzling aspect of this program. In essence, he does not want me
to use the inbuilt auto generate, date and year that is in the system, rather
the ones the user will enter in other fields in the program.
TO BRIEF YOU:
I have a field called (1) DateRec, another (2) Municipality and another (3)
Type. These three fields invariably will automatically generate a string of
number for another field that will be called FileNumber. This FileNumber is
already the Primary Key in the program. The (1) is the date received, that is
the date the application of the client was received. (2) being the
Municipality will have one or two letter characters of each Municipality
within the County where the applicant is from. And (3) which is the type is
the state of the application, it will only be involved in the FileNumber,
when it is an "EXEMPT", then, the nomenclature will be; an 'E'.
Here comes the drill! When the user enters the date received, it will be a
complete date, with day, month and year. The only thing that will go to the
FileNumber will be the year, like 2006. When a Municipality is chosen by the
user, for instance Atlantic City, it will generate a nomenclature like 'AC',
if it is for Brigantine it will be a 'B'. Then the program will run a query
that will check for the last FileNumber entered under that Municipality
chosen and update it with one number. So the FileNumber will be something
like AC-2-2006, for another entry on this same Municipality it will be
AC-3-2006, AC-4-2006 etc. Then, when there is an Exemption in the
application, the user will select EXEMPT from Type, it will emerge the 'E'
with the middle number; like AC-5E-2006. This is all that is needed.
I definitely, need a help to get this working. The purpose for this is to
debar the user from entering wrong Filenumbers.
Thanks in anticipation for your help.
Anthony