Combining Microsoft Templates

[dacsone]

[FONT=&quot]I'm trying to combine 2 templates that have a Contact tables. I'd like to remove one of the tables and establish new table relationships, create new queries were needed and modify macros.

There are 2 problems;

- The first is changing look-up field "Assign To" to get "ID", "Name" for the current Contact table,

- On a Form, the second is change or modify the Event "On Dbl Click" Macro that opens another Form, "Contact Details". The Macro uses "Where Condition == "[ID]=" &[Screen].[ActiveControl] and I'm getting the error "missing operator in query expression '[ID='. I know what the new Screen object and ActiveControl property do, I've not used them before.

My thought is that if I correct the first problem I won't have the second. I need suggestions for the first problem.

By the way, the 2 template file names are:
TCI Tasks db.accdb
TCI Issue Tracking db.accdb

Thanks,[/FONT]

 

[HiTechCoach]

Sounds like you have already combine the two templates together. If this is true e then you will need to post a copy of your database so we can see what you have changed.

 

[dacsone]

the 2 file have been uploaded, the combine file is too large to upload

 

[HiTechCoach]

Oops ... the attachments did not make it.

 

[dacsone]

files posted

 

[HiTechCoach]

- The first is changing look-up field "Assign To" to get "ID", "Name" for the current Contact table,

From what I say it look like it is working.

Please give specific details (steps) on how to find and duplicate the issue.

 

[dacsone]

The files that were uploaded yesterday were copies of the same file. I have remove one and uploaded the correct second file. Please note that these are the files that I'd like to combine into one.

 

[HiTechCoach]

Thanks for the update. I will take a look.

 

[dacsone]

Any luck with what to do?

 

[HiTechCoach]

Any luck with what to do?

Integrating two separate application is never easy. First you must fully understand how each one is written and how it works. It you were the designer of both then it is a little easier. If the applications are each written by different developers other tahn yourself, you have to learn each style. You are going to have to spend a lot of time learning how each one works.

It it were my project I would start a new database. I would start building the tables. Using the two templates as a guide, create the tables with all the required fields. I find it usually requires some redesign of get the two database merged into a common set of tables.

FWIW:
Most of the templates I have see from Microsoft have many design issues. I have not seen one yet that I would actually use. There are things you can learn from dissecting and studying them.