<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