Handling multiple projects with common functionalities

[tsluu]

I am suppose to implement similar Access projects for different sites. Each
site had their own minor specific requirements but shared major similarity in
functionalities.

To help ease support and implementation of new projects in future, I thought
of combining all functionalities of all projects into a switchboard where I
can turn on/off certain functionality for different project.

Any suggestions will be much appreciated.

 

[Tom van Stiphout]

On Mon, 12 Jan 2009 17:32:01 -0800, tsluu

Good idea. The worst thing you can do is develop several slighly
different projects. One of our clients did this and it became a
maintenance nightmare. "Only the London office needs this quick
report" so it seems such a good idea to quickly hack that up for them
and ship it. Not so.

One possible way to implement the Switchboard is to put an extra
dropdown on it to choose the Location. Great for development and beta
testing. The Location could be read from a System Settings table so it
remembers the user's last selection.

-Tom.
Microsoft Access MVP

 

[tsluu]

Hi Tom,

Can you give me some points as how to go about it?

Thanks

 

[Tom van Stiphout]

On Mon, 12 Jan 2009 21:55:00 -0800, tsluu

Not really. If this is a problem for you, you may need to read up on
general Access programming topics, such as creating a dropdown bound
to a table, and reading data from and saving data to a table. Maybe
this tutorial will help as well:
http://www.accessmvp.com/strive4peace/

-Tom.
Microsoft Access MVP