<!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.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<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></BODY></HTML>