Two different Switchboards same DB

[Joe8915]

Office 2010
Split DB
User level Security

I have a couple of suits (bosses) that don't like to click a couple buttons to access a report. Anyone have an idea how I can accomplish this. I was thinking 2 different Switchboards., but I don't think I can do that.

Any ideas

 

[vbaInet]

Why don't first of all ask them what they would prefer and you can weigh up your options and see which is feasible?

 

[Joe8915]

Thanks for the quick reply. The bottom line they only want to click one time and they have there report.

 

[vbaInet]

Use a listbox to display all the reports. On click, it will open the report using the bound column, which would be the name of the report.

Here's what you can use for the row source of the listbox to get all reports in your db:

SELECT MSysObjects.Name, MSysObjects.Type
FROM MSysObjects
WHERE (((MSysObjects.Type)=-32764))
ORDER BY MSysObjects.Name;

If you want to have a more descriptive name then just manually enter the report name in the first column and in the second put the descriptive name.

You can even use a combo box and open the report on the After Update event.

 

[The_Doc_Man]

There is such a thing as having a "hidden" form that looks like a splash page, maybe with a company logo, as the "real" startup / switchboard form. If you are using a login system, you know who you are serving, so make a hidden table with all your users and the name of the correct switchboard for each. Have the "splash" form - which really is just a form with no obvious controls - open the correct form based on who it is. Then either close the splash or minimize it and make it invisible if you need to run timer-based code behind it for some obscure reason.

Note: This requires VBA coding. You didn't say whether you were comfortable with VBA, but I think this is the approach you need. A nice, spiffy little logo would make the product look nice, and it only has to last long enough to make that one decision and bring up the right form.

 

[gemma-the-husky]

what buttons are they having to press to get the reports at the moment?

why 2? (indeed why only 2) - dont they need to select a data range, or some other filter for the report)

 

[JoeCruse]

Don't know about simplifying your report without more information, but yes you can have more than on switchboard. I have 3; one for me, one for 4 different lab workstations, and one for all other users. I have a startup form that is invisible. It uses Environ to see the userid, and opens the appropriate switchboard from there. Some coding required though.

 

[SOS]

Don't know about simplifying your report without more information, but yes you can have more than on switchboard. I have 3; one for me, one for 4 different lab workstations, and one for all other users. I have a startup form that is invisible. It uses Environ to see the userid, and opens the appropriate switchboard from there. Some coding required though.

I would just use a single form and display what you want based on user. Reusability is a very good thing.

 

[Joe8915]

SOS, thanks for the reply. Sounds just what I need. I have tried the Environ, but didn't have much luck with it. It has been some time ago when I tried it. If you can send me a sample on how you did accomplish it, I would be so grateful

 

[SOS]

I don't have an example myself but there was one posted here.

 

[Joe8915]

SOS, thanks for the link.. That did the trick