Designing a "checklist" of items to select and record data about

Good day,
Have a question regarding a request made of me that goes a little
beyond my Access ability. I've made a fairly basic database for one of our
depts. to record information for each job they perform. The database "Job
Log" currently has just one table, "Job Information Sheet."
One function they'd like to have is: for each job, they have a list of
documents that are to be sent to the client. This is a fixed list, with a
specific amount of items (ie. invoice, certificate, etc.) However, each job
can have any combination of items to be sent. They would "simply" like to be
able to select those items to be sent for that specific job, and sometime
after selecting them, be able to enter the date on which the item was sent.
Not only would they like to use a form to enter this information, but also be
able to include upon the report for each job entry, the list of specific
items to be sent, along with their dates.
I realize a very crude way about this would be to simply enter the
list into the current table "Job Information Sheet" as individual fields
using checkboxes. Then, I could simply have individual "date" fields for the
whole list, and hope that the users would only enter data into those fields
that are selected. However, this seems very crude and cumbersome. I'm sure
one of you has a much more elegant way to go about this. Any ideas?
--
Tony Fotsch

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "MultiSelect.mdb" which shows how to write selected value in a
listbox to a table. Perhaps this would give you some ideas.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"TheQuick" wrote in message
...
Good day,
Have a question regarding a request made of me that goes a little
beyond my Access ability. I've made a fairly basic database for one of
our
depts. to record information for each job they perform. The database "Job
Log" currently has just one table, "Job Information Sheet."
One function they'd like to have is: for each job, they have a list
of
documents that are to be sent to the client. This is a fixed list, with a
specific amount of items (ie. invoice, certificate, etc.) However, each
job
can have any combination of items to be sent. They would "simply" like to
be
able to select those items to be sent for that specific job, and sometime
after selecting them, be able to enter the date on which the item was
sent.
Not only would they like to use a form to enter this information, but also
be
able to include upon the report for each job entry, the list of specific
items to be sent, along with their dates.
I realize a very crude way about this would be to simply enter the
list into the current table "Job Information Sheet" as individual fields
using checkboxes. Then, I could simply have individual "date" fields for
the
whole list, and hope that the users would only enter data into those
fields
that are selected. However, this seems very crude and cumbersome. I'm
sure
one of you has a much more elegant way to go about this. Any ideas?
--
Tony Fotsch

Roger,

I went to your website as I have the same question. I can't seem to find
this sample db. Help.

Thanks,
Michelle K

"Roger Carlson" wrote:

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "MultiSelect.mdb" which shows how to write selected value in a
listbox to a table. Perhaps this would give you some ideas.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"TheQuick" wrote in message
...
Good day,
Have a question regarding a request made of me that goes a little
beyond my Access ability. I've made a fairly basic database for one of
our
depts. to record information for each job they perform. The database "Job
Log" currently has just one table, "Job Information Sheet."
One function they'd like to have is: for each job, they have a list
of
documents that are to be sent to the client. This is a fixed list, with a
specific amount of items (ie. invoice, certificate, etc.) However, each
job
can have any combination of items to be sent. They would "simply" like to
be
able to select those items to be sent for that specific job, and sometime
after selecting them, be able to enter the date on which the item was
sent.
Not only would they like to use a form to enter this information, but also
be
able to include upon the report for each job entry, the list of specific
items to be sent, along with their dates.
I realize a very crude way about this would be to simply enter the
list into the current table "Job Information Sheet" as individual fields
using checkboxes. Then, I could simply have individual "date" fields for
the
whole list, and hope that the users would only enter data into those
fields
that are selected. However, this seems very crude and cumbersome. I'm
sure
one of you has a much more elegant way to go about this. Any ideas?
--
Tony Fotsch

Here's the direct link:
http://www.rogersaccesslibrary.com/d...ultiSelect.mdb

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Michelle K" wrote in message
...
Roger,

I went to your website as I have the same question. I can't seem to find
this sample db. Help.

Thanks,
Michelle K

"Roger Carlson" wrote:

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "MultiSelect.mdb" which shows how to write selected value
in a
listbox to a table. Perhaps this would give you some ideas.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"TheQuick" wrote in message
...
Good day,
Have a question regarding a request made of me that goes a
little
beyond my Access ability. I've made a fairly basic database for one
of
our
depts. to record information for each job they perform. The database
"Job
Log" currently has just one table, "Job Information Sheet."
One function they'd like to have is: for each job, they have a
list
of
documents that are to be sent to the client. This is a fixed list,
with a
specific amount of items (ie. invoice, certificate, etc.) However,
each
job
can have any combination of items to be sent. They would "simply"
like to
be
able to select those items to be sent for that specific job, and
sometime
after selecting them, be able to enter the date on which the item was
sent.
Not only would they like to use a form to enter this information, but
also
be
able to include upon the report for each job entry, the list of
specific
items to be sent, along with their dates.
I realize a very crude way about this would be to simply enter
the
list into the current table "Job Information Sheet" as individual
fields
using checkboxes. Then, I could simply have individual "date" fields
for
the
whole list, and hope that the users would only enter data into those
fields
that are selected. However, this seems very crude and cumbersome.
I'm
sure
one of you has a much more elegant way to go about this. Any ideas?
--
Tony Fotsch