A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

combine two database templates



 
 
Thread Tools Display Modes
  #1  
Old March 21st, 2005, 04:35 PM
Lisa
external usenet poster
 
Posts: n/a
Default combine two database templates

I have found two Access templates that have tables I need to incorporate into
one database. How do I combine the Events Management and Membership templates
so that they work properly? My knowledge of Access is limited.
  #2  
Old March 21st, 2005, 10:46 PM
John Vinson
external usenet poster
 
Posts: n/a
Default

On Mon, 21 Mar 2005 08:35:10 -0800, "Lisa"
wrote:

I have found two Access templates that have tables I need to incorporate into
one database. How do I combine the Events Management and Membership templates
so that they work properly? My knowledge of Access is limited.


well, you'll need to either increase your knowledge of Access, or work
with someone who does know Access.

You can use File... Get External Data... Import to import tables and
forms, but (given that I have not worked with these templates) I have
no idea whether the table designs are such that they can be integrated
easily, with difficulty, or not at all without a complete redesign of
one or the other.

John W. Vinson[MVP]
  #3  
Old March 21st, 2005, 11:17 PM
Lisa
external usenet poster
 
Posts: n/a
Default

Thank you. I had already done what you suggested... but am having trouble
with the rest of it. What I am trying to do is create a database for a
non-profit membership organization that holds meetings, has an educational
program, committees, etc. I do not, however, need to track any financials
here. What I am having trouble with is the forms and subforms when I get rid
of/or edit a table... I believe I have figured out the relationships and the
switchboard. If this is the only way to combine the tables then I am just
going to have to figure out the rest as well. Thanks again. Lisa


"John Vinson" wrote:

On Mon, 21 Mar 2005 08:35:10 -0800, "Lisa"
wrote:

I have found two Access templates that have tables I need to incorporate into
one database. How do I combine the Events Management and Membership templates
so that they work properly? My knowledge of Access is limited.


well, you'll need to either increase your knowledge of Access, or work
with someone who does know Access.

You can use File... Get External Data... Import to import tables and
forms, but (given that I have not worked with these templates) I have
no idea whether the table designs are such that they can be integrated
easily, with difficulty, or not at all without a complete redesign of
one or the other.

John W. Vinson[MVP]

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Encrypt AccesS File? milest General Discussion 2 February 9th, 2005 07:58 PM
Access Error Message when opening database eah General Discussion 3 January 26th, 2005 10:04 AM
Database connectivity?How many users can connect at once Emmanuel General Discussion 9 January 5th, 2005 01:07 AM
Archiving A Database PC User General Discussion 2 November 2nd, 2004 11:16 PM
Images in a database Franz General Discussion 10 October 7th, 2004 09:35 AM


All times are GMT +1. The time now is 06:02 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.