[AccessD] Two front end databases with one user interface?

Arthur Fuller artful at rogers.com
Wed Jul 2 07:01:12 CDT 2003


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.
 
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.
 
hth,
Arthur

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
Sent: July 1, 2003 1:27 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Two front end databases with one user interface?


I do something kind of similar with an app. Its a PITA!
 
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.
 
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. 
 
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.
 
BTW did I mention that its a PITA?
 
I suppose you could get it set up in a class framework but I haven't gone
there yet.
HTH
JB
 
PS: did I mention that its a PITA?
:o)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030702/63755a94/attachment-0001.html>


More information about the AccessD mailing list