<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4522.1800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi, Charles.... There seems to be a problem with
the link...............Barb</FONT></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=CWortz@tea.state.tx.us href="mailto:CWortz@tea.state.tx.us">Wortz,
Charles</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 2:06
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=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><A
href="mailto:CWortz@tea.state.tx.us">CWortz@tea.state.tx.us</A></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>
<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>