Re-Use a Form for new user - empty tables & data

E

ERWatkins

I designed a Call Log that autopopulates the date and the user enters data in
4 fields on the form. This data in the four field builds a "record" Each
record is data about a phone call and details associated with it.
I would like to share this "form" with my peers, but I cant figure out out
to send them a BLANK form, without all the records I have built over time.
How can I COPY the form and make a BLANK TEMPLATE that I can share with
others who can then use the form and build their own records of calls and
messages?
 
S

Sprinks

I think the easiest way, assuming you don't want to have a network
application that has *all* calls is to copy the entire database, and empty
the tables that have your specific data from the copy, and send them the new
..mdb file.

Hope that helps.

Sprinks
 
E

ERWatkins

Understood. I agree and seems straightforward. However, intuitely I would
go to FILE or EDIT and look for a COPY option, or some other utility in TOOLS
that would help me "COPY TO NEW FILE".... but I dont see any of those
options. So I would just open up MY Computer, find the file, right click it
and copy it to a new location? Then open the copied file and edit it by
deleting all the records, leaving just the first empty record. Correct?
 
S

Sprinks

Yes, although you don't necessarily have to move it to a new location; you
can paste it as a Copy of... and rename it. Alternatively, if you want to
work within Access, start a new database, and use File, Get External Data,
and import all of the objects of your original into the new database file.

HTH
Sprinks
 
S

Stryker412

Is there a way I can obtain a copy of your template? I work at a college and
we're trying to design something similar in Access to log all outgoing calls.
Does your template allow for International calls?
 
Top