<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2719.2200" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=684170518-01072003><FONT color=#0000ff
size=2>Barb,</FONT></SPAN></DIV>
<DIV><SPAN class=684170518-01072003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=684170518-01072003><FONT color=#0000ff size=2>See Terri Jarus
"E-mail Acronyms" at <A
href="http://www.databaseadvisors.com/newsletters/7602-2wr.htm">www.databaseadvisors.com/newsletters/7602-2wr.htm</A>.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><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> </P>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Barbara Ryan
[mailto:BarbaraRyan@cox.net] <BR><B>Sent:</B> Tuesday 2003 Jul 01
13:08<BR><B>To:</B> Access Developers discussion and problem
solving<BR><B>Subject:</B> Re: [AccessD] Two front end databases with one user
interface?<BR></FONT></DIV>
<DIV><FONT size=2><SPAN class=684170518-01072003><FONT
color=#0000ff> </FONT></SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=684170518-01072003> </SPAN>Thanks,
John......</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I was hoping to limit the number of objects in my "vanilla"
front end by keeping the "really specific" customizations in another FE.
</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>This is funny--- I didn't quite catch on to the acronym "PITA"
--- I thought it must be some high-tech thing, so I did a search in Google.
Found the "Palestine Information Technology Association", the "Pacific Islands
Telecommunications Association", the Pacific International Trapshooting
Association....</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>...but it just clicked --- that it's a Pain......</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Barb</FONT></DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=john@winhaven.net href="mailto:john@winhaven.net">John Bartow</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 01, 2003 1:27
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Two front end
databases with one user interface?</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=968291517-01072003><FONT color=#0000ff size=2>I do something
kind of similar with an app. Its a PITA!</FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT color=#0000ff size=2>It entails
using a login (which I have happen automatically based on the windows login if
it matches the staff table info). I then hold info in variables about
about what the person can see and if necessary how they see
it.</FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT color=#0000ff size=2>So for instance
if the forms a person is allowed to see, based the department they work for
and their "security" (my built in security-not access's) then they just don't
get the icons for the other forms displayed. When there is a choice of forms
to use for the same info they get "their" version of the form. How the
position their forms is called everytime a form opens and reset to the postion
when it closes. </FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT color=#0000ff size=2>I store some of
this info (personal choices for UI settings) in the registry and other info
(such as security-which is required in case they login into someone elses
PC) in the "staff" table.</FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT color=#0000ff size=2>BTW did I
mention that its a PITA?</FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT color=#0000ff size=2>I suppose you
could get it set up in a class framework but I haven't gone there
yet.</FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT color=#0000ff
size=2>HTH</FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT color=#0000ff
size=2>JB</FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT color=#0000ff size=2>PS: <SPAN
class=968291517-01072003><FONT color=#0000ff size=2>did I mention that its a
PITA?</FONT></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT color=#0000ff size=2><SPAN
class=968291517-01072003>:o)</SPAN></FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"> </BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>