<!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 5.50.4522.1800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Thanks, John....That gives me some options to think
about..............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=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 2:23
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=515200818-01072003><FONT face=Arial color=#0000ff
size=2>Barb,</FONT></SPAN></DIV>
<DIV><SPAN class=515200818-01072003><FONT face=Arial color=#0000ff size=2>You
could do that but instead of presenting a different form in the FE for that
user open a different form in another FE. I did that with one of the apps
until it was fully integrated into the main FE.</FONT></SPAN></DIV>
<DIV><SPAN class=515200818-01072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=515200818-01072003><FONT face=Arial color=#0000ff size=2>Of
course this was the entire app. If you're opening one specific form and
there is more than just that one form in the other FE then you'de have to work
something out for that. Maybe put each special form in its own FE? (Thats just
a wild swing at a solution, could get ugly.)</FONT></SPAN></DIV>
<DIV><SPAN class=515200818-01072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=515200818-01072003><FONT face=Arial color=#0000ff
size=2>Select Case gintDeptID</FONT></SPAN></DIV>
<DIV><SPAN class=515200818-01072003><FONT face=Arial color=#0000ff size=2>Case
"PITA depart."</FONT></SPAN></DIV>
<DIV><SPAN class=515200818-01072003><FONT face=Arial color=#0000ff
size=2> Dim strStAppName As String<BR>
strStAppName = "C:\Program Files\Access 97 Runtime\Msaccess.exe
""N:\PITAForm1.mde"""<BR> Call Shell(strStAppName,
1)</FONT></SPAN></DIV>
<DIV><SPAN class=515200818-01072003><FONT face=Arial color=#0000ff size=2>Case
Else</FONT></SPAN></DIV>
<DIV><SPAN class=515200818-01072003> <FONT face=Arial
color=#0000ff size=2>"open the vanilla form"</FONT></SPAN></DIV>
<DIV><SPAN class=515200818-01072003><FONT face=Arial color=#0000ff size=2>End
Select</FONT></SPAN></DIV>
<DIV><SPAN class=515200818-01072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=515200818-01072003><FONT face=Arial color=#0000ff
size=2>JB</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<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>Barbara
Ryan<BR><B>Sent:</B> Tuesday, July 01, 2003 1:08 PM<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><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Thanks, John......</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial 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 face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial 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 face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>...but it just clicked --- that it's a
Pain......</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial 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 face=Arial 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 face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial 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 face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial 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 face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial 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 face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff
size=2>BTW did I mention that its a PITA?</FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial 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 face=Arial color=#0000ff
size=2>HTH</FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff
size=2>JB</FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff
size=2>PS: <SPAN class=968291517-01072003><FONT face=Arial
color=#0000ff size=2>did I mention that its a
PITA?</FONT></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial 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">
<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>Barbara
Ryan<BR><B>Sent:</B> Tuesday, July 01, 2003 12:04 PM<BR><B>To:</B>
Access List<BR><B>Subject:</B> [AccessD] Two front end databases with
one user interface?<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>I have a "vanilla" Access 97 application
that is used at multiple sites. If a particular site want a
modification --- e.g., a customized version that I do NOT want to
incorporate into the vanilla version, is there a way that I can create a
separate front end (to hold these custom objects) yet still have one
user interface? I don't want them to have to open two separate
applications.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Hope this makes sense!<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2>Barb Ryan</DIV></BLOCKQUOTE></FONT>
<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></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>