Stanley
Well, it's nice to see my post finally made it. Now about your question...
The best book on Access is "Microsoft Access 2010 Inside Out" by John Viescas ( one of our MVP members) and Jeff Conrad. The way I'd start is by importing everything into a new database and poke around in it. The startup form will probably be the biggest challenge since each template has its own startup. I don't know how much code has been written for the templates, but as long as everything has a unique name you should be okay. For example, if you get two "Employee" tables you will have to make sure they have the same fields. Pick one to use and then add whatever fields from the other one that are missing.
Whatever you do, don't start adding data until you are finished fixing everything. And we're here to help. By the bye, which templates are you wanting to combine?
Bill
PS: I accidentally sent a reply directly to you instead of the group. Sorry about that.
----- Original Message -----
From: "Stanley C Pearse" <spearse@sfsu.edu>
To: "MS Access Professionals" <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, August 27, 2013 9:22:02 AM
Subject: [MS_AccessPros] MS Office Templates - Can they be joined
I would like to make use of two or more MS Access templates and would like to know if they can be joined to make a more complete database?
Stanley C. Pearse, CPPM
Supervisor of Property and Distribution Systems
San Francisco State University
1600 Holloway Avenue
Corp Yard, Building C / Property Office
San Francisco, CA 94132
(415) 405-3584, Phone
(415) 841-5022, Fax
spearse@sfsu.edu <mailto: spearse@sfsu.edu >
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar