Rod,
For some additional working ideas, my sample db's mentioned below, though not directly applicable, might be of interest:
(a) MedicalDiagnosis
(b) ArchivesManager
(c) Form_CustomAutoComplete
These are in access 2000 file format and are available at Rogers Access Library. Link:
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45
Best wishes,
A.D. Tejpal
------------
----- Original Message -----
From: borninfulton
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, August 28, 2012 22:48
Subject: [MS_AccessPros] Re: Looking for a template for documenting my trouble shooting tips
I did not know about that, John, thank you very much! Quite handy.
Rod
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Rod-
>
> If you're using 2007 or later, switch to "Tables and Related Views" in the
> Navigation pane to see which queries, forms, and reports are dependent on which
> tables. If you remove a table, simply remove all the dependent other objects
> first. As for removing columns, I would leave them alone in the tables and just
> remove them from forms and reports where I don't need them.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of borninfulton
> Sent: Tuesday, August 28, 2012 4:29 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Looking for a template for documenting my trouble
> shooting tips
>
> Hi John,
>
> Thank you for your response. I'm concerned, though, if I remove columns or
> tables that don't cover what I need, and some Access forms have been developed
> using either those columns or tables, that it would result in problems.
>
> Still, I guess I could just live with that.
>
> Rod
>
> --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@> wrote:
> >
> > Rod-
> >
> > If templates like "problem tracking" or "issues tracking" do everything that
> you
> > want but are more than you need, it would seem to be a good idea to start with
> > one of those and then just take away or disable stuff you don't need to use.
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
>
> <snip />
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar