existing tables to templates?

[Guest]

I have tables that are not structured exactly like the tables in the
templates I want to use (class management for example). I want to be able to
add the contact information of the students to the template but when I change
the recordSource to my table then all the cool goodies like gpa and
assignment reports no longer work. How do I keep all the functions of the
template but use my data?
Thanks
Stephanie

 

[Guest]

Hi Stephanie,

You can try downloading and installing the free Find and Replace Add-In
Wizard for Access:

http://www3.bc.sympatico.ca/starthere/findandreplace/

I haven't personally used this tool (I use SpeedFerret instead), but I think
it will work to help you find all references to a given table or query name.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Larry Linson]

I have tables that are not structured exactly like the tables in the
templates I want to use (class management for example). I want to be able
to
add the contact information of the students to the template but when I
change
the recordSource to my table then all the cool goodies like gpa and
assignment reports no longer work. How do I keep all the functions of
the
template but use my data?

Consider using a query to extract from your tables, into a compatible format
with the tables from the template, and appending that data into the template
tables. Once you have constructed a database from the templates, you can
open the objects in design view to alter them -- you do have to have some
knowledge of how Access works.