C
ChuckW
Hi,
I have a main form called Protocol with two text boxes: CustomerName and
ProtocolName. The table that this form is based on is called Protocols. I
then have a continous form called Items. It has combo boxes that allow you
to select items from an item table. The data from the form and subform are
written to another table called ProtocolItems. There is a field called
protocolID which is in both the main protocol table and the protocolItems
table. There are then reports that people create based on these
selections. The reports have the company name and the protocol name in the
header and the items selected in the detail section.
I want to create a "template" similar to excel where there are set
protocols. A user can then go in and change either the company name or
protocol in the main form or the mix of items in the subform. They can then
print this out. But it would not change the overall data. In excel you
have a set template with some things that cannot be changed. You can add
data to them and print them out but there are things that stay the same. Is
it at all possible to do this in Access?
Thanks,
I have a main form called Protocol with two text boxes: CustomerName and
ProtocolName. The table that this form is based on is called Protocols. I
then have a continous form called Items. It has combo boxes that allow you
to select items from an item table. The data from the form and subform are
written to another table called ProtocolItems. There is a field called
protocolID which is in both the main protocol table and the protocolItems
table. There are then reports that people create based on these
selections. The reports have the company name and the protocol name in the
header and the items selected in the detail section.
I want to create a "template" similar to excel where there are set
protocols. A user can then go in and change either the company name or
protocol in the main form or the mix of items in the subform. They can then
print this out. But it would not change the overall data. In excel you
have a set template with some things that cannot be changed. You can add
data to them and print them out but there are things that stay the same. Is
it at all possible to do this in Access?
Thanks,