<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2726.2500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=436355111-02072003><FONT face=Arial color=#0000ff size=2>I
recently had to "fork" an app, such that branch had total functionality and the
other a very limited subset. Since I use the switchboard for the main UI, it was
quite simple to achieve what I wanted. I made a tiny mod to the switchboard code
so that it accepts an OpenArgs argument which is the initial switchboard to
open. In its standard implementation, the code looks for the word "(Default)" in
the switchboard items table. (Open the code module and search for that, and
you'll see what I mean.) I simply modified this code to search for the OpenArgs
argument instead.</FONT></SPAN></DIV>
<DIV><SPAN class=436355111-02072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=436355111-02072003><FONT face=Arial color=#0000ff size=2>Then I
created a hidden form that opens the switchboard with an OpenArgs argument. THus
both versions have the entire app, but the limited one shows only a part of the
functionality. I change the value of a variable on the hidden form, then create
an MDE, overriding its name. Then I change the variable again, create another
MDE and change its name slightly.</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=436355111-02072003><FONT face=Arial color=#0000ff
size=2>hth,</FONT></SPAN></DIV>
<DIV><SPAN class=436355111-02072003><FONT face=Arial color=#0000ff
size=2>Arthur</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us 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>John
Bartow<BR><B>Sent:</B> July 1, 2003 1:27 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><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><FONT face=Arial
size=2></DIV></BLOCKQUOTE></FONT></BODY></HTML>