Template Editing

[Guest]

Sorry guys I'm new to this posting stuff. I'm trying to edit the Access 2003
"Orders" template that I downloaded from this the home site. I really love
the look and design of the template. The problem I have is that I want to
change some of the names of the tables and forms. Also, I want to add (or
edit) different fields to (in) the tables and maybe add a few more tables.
I've tried, but I can't seem to get some of my changes to work (like
replacing one table with another in a form.) Is there a walkthrough or
tutorial for designing this particular data base? Any help would be greatly
appreciated.

 

[Brendan Reynolds]

I don't know of anything specifically about that template. As everyone is
likely to want to customize the database created from the template in
different ways, it would be difficult for anyone to write a tutorial, as no
one can predict exactly what modifications you might want to make.

To bind a form to a different table, you edit the RecordSource property of
the form. If the new table does not contain exactly the same fields as the
old one, then you will also need to edit the ControlSource property of the
form controls (text boxes, combo boxes, etc.). Any macros or code that might
refer to the old table/field names will also need to be modified, and also
check the Filter and Order By properties of the form, which may have
references to the old table or field names.

If you're still stuck, try posting a more detailed explanation of the
problem, and someone will probably be able to help.

 

[Guest]

Thanks Brendan I will work with the tips you gave here.

 

[Guest]

Donica, I also want to thank you for replying. I will try the tips you "and
Brendan" posted here. I'm sure they will help.