Is it possible to have TWO Front ends?

[mattpearcey]

I have a database that covers the rgion that i work in. Part of this region has now been split and joined another region. That region does not have a database, so i would like to introduce them into using my database. However, we are having problems trying to figure out how to do this. At present, the idea is to completely split the tow. Having two databases, and keeping the approriate data on each. However, this will mean i have to do 2 lots of updates, two lots of repairing, two lots of mods, etc.

Is there a way that i can make two front end databases that link to the same back end. But allowing me to make the necessary changes to the forms, such as different drop downs for the countries, different names, etc.

Can this be done, and how safe is it to do so?

Advice please? Thank you for your help already.

Matt Pearcey

 

[Mats]

This should be no problem at all as far as I can see. Just start a new project and link the tables from the back-end of your first database.

In case you don't want the users of both front-ends to see the same records you have to add some identification for your data so you know to which front-end it belongs.

Mats

 

[mattpearcey]

i have a region field, and a country field, could i do it from the region field?

At the moment, they open the same DB and go to the region field, double click, and it says What region do you want to see. They type in Central Europe, and it filters intot those records. Could i possibly do this form them, as an OnLoad macro to filter this when they load up the front end they want. So that they dont have to do anything, and it will filter for them?

Thank you for your help already.

Matt Pearcey

 

[Lightning]

Matt

Do you have Access Security set on this db? If you do, you could filter the records the user sees according to the User Group and/or User Id they log on with.

ie user group "Central Europe" filter by Region = CE (or whatever)

user group "South East Asia" filter by Region = SEA

Just a thought

Lightning

 

[mattpearcey]

I have set up two front ends now, in a test area, and i now want to split up some of the data to be viewed. For example, I have records for a CEE region, and a CISMEA region in the test back end. So, i want to have one front end for each region. In the main database, that i have running live at the moment, i have an option at the start where the user has to enter what region they would liek to look at. This is set up in a query, with a criteria set to [What region would you like to view?] on the region field. So , they enter CEE and it comes up with a filtered database of CEE banks.

Is there a way that i can run a macro to have this filter to run on the OnLoad Event. So that when they open the CEE front end, it automatically filters the front end without them knowing it.

Do i have to do this in a query, then actoivate it through a macro? IF so , how do i write the query? Do i have to put a criteria on it? and how do i write the critera so that is it now a question. but it just runs withouth the user having to do anything?

Thank you for your help already.

Matt Pearcey

 

[AArt]

You can have different versions of the same form, each one performing the filtering that your looking for. Then distribute different versions of the DB with the different forms as Startup forms.
The query isn't in the onLoad event, its the recordsource. Write a query that selects all the fields you want, and in the region field put 'CEE' for the criteria. Save the query, then select as the recordsource for your form. No Macro required.