<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Kewl</FONT></DIV>
<DIV><FONT face=Arial size=2>What did you do, if I may ask???</FONT></DIV>
<DIV>Kind regards,<BR>David
Hingston<BR>_________________________________________________________________________<BR>Engines2Go
- Now THAT's a Search Engine!<BR>Automated major search engine manager<BR>Makes
searching quicker and easier - Have you tried it? <BR><A
href="http://www.engines2go.com/">http://www.engines2go.com/</A> <BR><A
href="http://www.cheqsoft.com/">http://www.cheqsoft.com/</A> The home of
Clipboard Express, MP3 Detective, TimesOwn and Break Reminder.</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=prodevmg@yahoo.com href="mailto:prodevmg@yahoo.com">Lonnie
Johnson</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion and
problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, July 30, 2003 2:35
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Count the times a
table is opened</DIV>
<DIV><BR></DIV>
<DIV>I really like the idea of the tabbed form that looks like the dB window.
However, I like the fact that you can't do it even more which will actually be
support for my argument of reason's why they shouldn't be allowed to go
directly into the database window.</DIV>
<DIV> </DIV>
<DIV>Even though I was not presented with a way of doing what the boss wanted,
I actually got the information I was looking for. </DIV>
<DIV> </DIV>
<DIV>Thanks everyone for your replies.</DIV>
<DIV> </DIV>
<DIV><BR><BR><B><I>"Porter, Mark" <MPorter@acsalaska.com></I></B>
wrote:</DIV>
<DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid; WIDTH: 100%">
<META content="MSHTML 5.50.4923.2500" name=GENERATOR>
<DIV><SPAN class=654245121-29072003><FONT face=Arial color=#0000ff
size=2>It's more than a discussion, there is actually a form in
the ADH97 source code disk.</FONT></SPAN></DIV>
<DIV><SPAN class=654245121-29072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=654245121-29072003><FONT face=Arial color=#0000ff
size=2>I've used it with runtime installations for users who were used to
the DB window. They couldn't tell the difference for their
purposes.</FONT></SPAN></DIV>
<DIV><SPAN class=654245121-29072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=654245121-29072003><FONT face=Arial color=#0000ff
size=2>Mark</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> John Bartow
[mailto:john@winhaven.net]<BR><B>Sent:</B> Tuesday, July 29, 2003 1:31
PM<BR><B>To:</B> Access Developers discussion and problem
solving<BR><B>Subject:</B> RE: [AccessD] Count the times a table is
opened<BR><BR></FONT></DIV>
<DIV><SPAN class=000282421-29072003><FONT face=Arial color=#0000ff
size=2>Not that I know of.</FONT></SPAN></DIV>
<DIV><SPAN class=000282421-29072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=000282421-29072003><FONT face=Arial color=#0000ff
size=2>A possible work around off the top of my head (if no one else can
tell you how to do it directly):</FONT></SPAN></DIV>
<DIV><SPAN class=000282421-29072003><FONT face=Arial color=#0000ff
size=2>In the ADH there's a discussion of presenting a tabbed form that
looks exactly like the access database object
container.</FONT></SPAN></DIV>
<DIV><SPAN class=000282421-29072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=000282421-29072003><FONT face=Arial color=#0000ff
size=2>You could recreate that form,</FONT></SPAN></DIV>
<DIV><SPAN class=000282421-29072003><FONT face=Arial color=#0000ff
size=2>hide the DB window (set the bypass key to false so they couldn't
use that)</FONT></SPAN></DIV>
<DIV><SPAN class=000282421-29072003><FONT face=Arial color=#0000ff
size=2>set the double click event of the table view list to
record: the item being opened, the count of the times opened, and then
open the actual table in datasheet view.</FONT></SPAN></DIV>
<DIV><SPAN class=000282421-29072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=000282421-29072003><FONT face=Arial color=#0000ff
size=2>HTH</FONT></SPAN></DIV>
<DIV><SPAN class=000282421-29072003><FONT face=Arial color=#0000ff
size=2>John B.</FONT></SPAN></DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Lonnie
Johnson<BR><B>Sent:</B> Tuesday, July 29, 2003 4:22 PM<BR><B>To:</B>
Access Developers discussion and problem solving<BR><B>Subject:</B> Re:
[AccessD] Count the times a table is opened<BR><BR></FONT></DIV>
<DIV>Believe me, I know all this. You are preaching to the choir. This
is a small company that has their own way of doing things. I've had this
argument for over a year now and haven't won. If they pay me to do it, I
do it.</DIV>
<DIV> </DIV>
<DIV>So, back to my question, is there a method of tracking how many
times a user invokes an object from the database window. </DIV>
<DIV> </DIV>
<DIV>I assume the answer may be no since I can't seem to get an
answer.<BR><BR><B><I>William Hindman
<wdhindman@bellsouth.net></I></B> wrote:</DIV>
<DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid; WIDTH: 100%">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
<DIV><FONT face=Arial size=2>...so build him a continuous records form
that looks like the table's database window but isn't ...with him in
the real table your rectum is exposed big-time, not
his ...and with the form approach, you not only can limit the
damage he can do but the access count becomes much easier to
provide.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>William Hindman<BR>...It's a proven fact that if you smoke a pack
of cigarettes a day for 90 years, you'll live to a ripe old age.
:)))</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=prodevmg@yahoo.com href="mailto:prodevmg@yahoo.com">Lonnie
Johnson</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers
discussion and problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, July 29, 2003
4:26 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Count
the times a table is opened</DIV>
<DIV><BR></DIV>
<DIV>I am 1000 percent in agreement with you. However, I have a CFO
who literally signs the checks and demands direct access to a
certain table for him and a couple of others, but wants to know how
many times they get into it.</DIV>
<DIV> </DIV>
<DIV><BR><BR><B><I>"Wortz, Charles" <<A
href="mailto:CWortz@tea.state.tx.us">CWortz@tea.state.tx.us</A>></I></B>
wrote:</DIV>
<DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid; WIDTH: 100%">
<META content="MSHTML 6.00.2719.2200" name=GENERATOR>
<DIV><SPAN class=241124019-29072003><FONT color=#0000ff
size=2>Lonnie,</FONT></SPAN></DIV>
<DIV><SPAN class=241124019-29072003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=241124019-29072003><FONT color=#0000ff
size=2>IMHO the database window should only be available in Design
mode. Letting the users get at the database window is a
serious mistake that you will regret ever
making.</FONT></SPAN></DIV>
<DIV><SPAN class=241124019-29072003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=241124019-29072003></SPAN><SPAN
lang=en-us><B><FONT color=#0000ff>Charles Wortz</FONT></B></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>Software Development
Division</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>Texas Education Agency</FONT></SPAN> <BR><SPAN
lang=en-us><FONT color=#0000ff>1701 N. Congress Ave</FONT></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>Austin, TX
78701-1494</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>512-463-9493</FONT></SPAN> <BR><SPAN
lang=en-us><FONT
color=#0000ff>CWortz@tea.state.tx.us</FONT></SPAN> </DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr
align=left><FONT face=Tahoma size=2>-----Original
Message-----<BR><B>From:</B> Lonnie Johnson
[mailto:prodevmg@yahoo.com] <BR><B>Sent:</B> Tuesday 2003 Jul 29
14:32<BR><B>To:</B> Access Developers discussion and problem
solving<BR><B>Subject:</B> [AccessD] Count the times a table is
opened<BR><BR></FONT></DIV>
<DIV>Is there a way to record when a table (or any object) is
opened from the database window?</DIV><BR><BR>
<DIV>
<DIV>
<P align=center><STRONG>Lonnie
Johnson<BR></STRONG><STRONG>ProDev</STRONG>, Professional
Development of MS Access Databases<BR>Visit me at ==> <A
href="http://www.prodev.us/">http://www.prodev.us</A></P>
<P><BR> </P></DIV></DIV></BLOCKQUOTE></DIV><BR><BR>
<DIV>
<DIV>
<P align=center><STRONG>Lonnie
Johnson<BR></STRONG><STRONG>ProDev</STRONG>, Professional
Development of MS Access Databases<BR>Visit me at ==> <A
href="http://www.prodev.us/">http://www.prodev.us</A></P>
<P><BR><A
href="http://www.galaxymall.com/software/PRODEV"><BR></A><BR> </P></DIV></DIV>
<P>
<HR SIZE=1>
Do you Yahoo!?<BR><A
href="http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com">Yahoo!
SiteBuilder</A> - Free, easy-to-use web site design software
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD
mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE>_______________________________________________<BR>AccessD
mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></DIV><BR><BR>
<DIV>
<DIV>
<P align=center><STRONG>Lonnie
Johnson<BR></STRONG><STRONG>ProDev</STRONG>, Professional
Development of MS Access Databases<BR>Visit me at ==> <A
href="http://www.prodev.us/">http://www.prodev.us</A></P>
<P><BR><A
href="http://www.galaxymall.com/software/PRODEV"><BR></A><BR> </P></DIV></DIV>
<P>
<HR SIZE=1>
Do you Yahoo!?<BR><A
href="http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com">Yahoo!
SiteBuilder</A> - Free, easy-to-use web site design
software</BLOCKQUOTE></BLOCKQUOTE><BR><BR>
<P><I><FONT face=Arial size=2>This transmittal may contain confidential
information intended solely for the addressee. If you are not the intended
recipient, you are hereby notified that you have received this transmittal
in error; any review, dissemination, distribution or copying of this
transmittal is strictly prohibited. If you have received this communication
in error, please notify us immediately by reply or by telephone (collect at
907-564-1000) and ask to speak with the message sender. In addition, please
immediately delete this message and all attachments. Thank
you.</FONT></I></P>_______________________________________________<BR>AccessD
mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></DIV><BR><BR>
<DIV>
<DIV>
<P align=center><STRONG>Lonnie Johnson<BR></STRONG><STRONG>ProDev</STRONG>,
Professional Development of MS Access Databases<BR>Visit me at ==> <A
href="http://www.prodev.us/">http://www.prodev.us</A></P>
<P><BR><A
href="http://www.galaxymall.com/software/PRODEV"><BR></A><BR> </P></DIV></DIV>
<P>
<HR SIZE=1>
Do you Yahoo!?<BR><A
href="http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com">Yahoo!
SiteBuilder</A> - Free, easy-to-use web site design software
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>