D
dohernan
Good afternoon.
I have a table called PersonnelForms2009 with a Field called ‘Form Type’
that’s a dropdown menu.
I want to be able, if a person is entering the record in Table/Datasheet
view, or using the Form to input new Records, to have another table pop up if
the person selects “Verification†from the dropdown menu, because
Verifications are letters, and at that point I would need more information.
(Right now I leave Access and go to Word, where I have a Verification letter
template complete with header & footer, and open up another program in order
to get addresses.)
The original Table has the employee Last & First names, and the Socials.
In order to generate the letter I would need to get further information such
as-
Dates of Employment:
Title:
Salary:
Last Known Address:
And a paragraph left blank in case there are extra Notes to add to the
bottom of the letter.
I also want to be asked if I want to add another sentence to the letter
“Actual Start Date†if I do then I would need to be able to input that date
as well.
I would want the 2nd pop-up table to keep the addresses in case the same
person needs a letter at a later date. I figured the 2 tables could be
related by the Social Sec # Fields.
Is it possible to print envelopes from Access using the letter/report once
it's generated?
In some cases the employee doesn’t want their social printed, or their
address has to show up as N/A, so if the address/city/state/zip fields are
blank I want N/A to show up.
Once a letter is printed I’d like the Completed field in the original table
to show the current date as the Completed date.
Any help would be appreciated, even a link in the right direction, thanks
so much.
I have a table called PersonnelForms2009 with a Field called ‘Form Type’
that’s a dropdown menu.
I want to be able, if a person is entering the record in Table/Datasheet
view, or using the Form to input new Records, to have another table pop up if
the person selects “Verification†from the dropdown menu, because
Verifications are letters, and at that point I would need more information.
(Right now I leave Access and go to Word, where I have a Verification letter
template complete with header & footer, and open up another program in order
to get addresses.)
The original Table has the employee Last & First names, and the Socials.
In order to generate the letter I would need to get further information such
as-
Dates of Employment:
Title:
Salary:
Last Known Address:
And a paragraph left blank in case there are extra Notes to add to the
bottom of the letter.
I also want to be asked if I want to add another sentence to the letter
“Actual Start Date†if I do then I would need to be able to input that date
as well.
I would want the 2nd pop-up table to keep the addresses in case the same
person needs a letter at a later date. I figured the 2 tables could be
related by the Social Sec # Fields.
Is it possible to print envelopes from Access using the letter/report once
it's generated?
In some cases the employee doesn’t want their social printed, or their
address has to show up as N/A, so if the address/city/state/zip fields are
blank I want N/A to show up.
Once a letter is printed I’d like the Completed field in the original table
to show the current date as the Completed date.
Any help would be appreciated, even a link in the right direction, thanks
so much.