Creating Templates in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a database called Cost Analysis. It has a main form called Protocol
with two text boxes. One is a for the Company Name and the other is for a
Protocol. Right now, there are about 10 different companies. Each company
can have several different protocols. There is also a subform on this
Protocol form called SelectItems. The subform has items that are selected
from drop downs. They come from an Item table that also has pricing
information. The user selects a quantity for each item. There is then a
command button at the bottom of the Protocol form that the user clicks on
which prompts them for a company. They select one of the 10 available
companies and then click on another command button. They are then prompted
for all of the protocols under this company. There is finally another
command button that runs a report for this individual protocol.

These protocol reports have the Company Name and Protocol in the header of
the report and then all items that the user selected from the Select Items
subform ind the detail section. What I want to do is to allow the user to
make templates similar to Excel. I would like it so that these 40 protocols
are saved. A user can go in and modify the protocols by choosing a new
company name and protocol name and perhaps changing an item or two which
creates a new template. However, the original template or protocol that they
started with is unchanged. Many protocols have a very similar set up items
but a different Company Name and Protocol Name. The users are having to
print out an existing protocol and then create a new one from scratch even
though all of them items are the same. The only difference is the Company
Name and Protocol Name.

Can anyone suggest a solution here?

Thanks,
 
Is your database relational or flat? The angle you use to attack this
type of issue would depend on your database layout.
 
Hi,

The database is relationtional. There are two main tables. The Protocol
table which is fed from the main form and has ProtocolID, CustomerName, and
ProtocolName. The Items table from the Subform has ProtocolID, ItemName and
Quantity.

Thanks for you help.
 
Back
Top