By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

I finished the application - - - now what?

P: n/a
Hi All,

I just finished creating my first all-inclusive MS-Access application. Ideally, I would prefer to prevent mischievous users from accessing everything except the switchboard items. This would include the menu system and except for the "print" shortcut button, all the control buttons. In fact, if I could somehow automate printing reports, I would hide it, too. Please reply with any recommendation.

Thanks very much,
Chuck
Nov 13 '05 #1
Share this Question
Share on Google+
10 Replies


P: n/a
Chuck Insight wrote:
Hi All,

I just finished creating my first all-inclusive MS-Access application.
Ideally, I would prefer to prevent mischievous users from accessing
everything except the switchboard items. This would include the menu
system and except for the "print" shortcut button, all the control
buttons. In fact, if I could somehow automate printing reports, I would
hide it, too. Please reply with any recommendation.

Thanks very much,
Chuck


Create an autoexec macro. In the macro, run your reports, then quit the
app. You may want to inform the users the reports are running via a form.
Nov 13 '05 #2

P: n/a
Chuck Insight wrote:
Hi All,

I just finished creating my first all-inclusive MS-Access application.
Ideally, I would prefer to prevent mischievous users from accessing
everything except the switchboard items. This would include the menu
system and except for the "print" shortcut button, all the control
buttons. In fact, if I could somehow automate printing reports, I would
hide it, too. Please reply with any recommendation.

Thanks very much,
Chuck


Create an autoexec macro. In the macro, run your reports, then quit the
app. You may want to inform the users the reports are running via a form.
Nov 13 '05 #3

P: n/a
Thanks for this reply, but this will not quite get the complete job done.

Closer to what I had in mind would be making an executable file that:
1 - hides everything except the auto-execute opening switchboard,
2 - exits the application if the user exits the switchboard,
3 - prohibits viewing everything but the switchboard, yet
4 - supports all the functionality built into the application

Again, thanks
"Salad" <oi*@vinegar.com> wrote in message
news:T%*****************@newsread1.news.pas.earthl ink.net...
Chuck Insight wrote:
Hi All,

I just finished creating my first all-inclusive MS-Access application.
Ideally, I would prefer to prevent mischievous users from accessing
everything except the switchboard items. This would include the menu
system and except for the "print" shortcut button, all the control
buttons. In fact, if I could somehow automate printing reports, I would
hide it, too. Please reply with any recommendation.

Thanks very much,
Chuck


Create an autoexec macro. In the macro, run your reports, then quit the
app. You may want to inform the users the reports are running via a form.

Nov 13 '05 #4

P: n/a
Thanks for this reply, but this will not quite get the complete job done.

Closer to what I had in mind would be making an executable file that:
1 - hides everything except the auto-execute opening switchboard,
2 - exits the application if the user exits the switchboard,
3 - prohibits viewing everything but the switchboard, yet
4 - supports all the functionality built into the application

Again, thanks
"Salad" <oi*@vinegar.com> wrote in message
news:T%*****************@newsread1.news.pas.earthl ink.net...
Chuck Insight wrote:
Hi All,

I just finished creating my first all-inclusive MS-Access application.
Ideally, I would prefer to prevent mischievous users from accessing
everything except the switchboard items. This would include the menu
system and except for the "print" shortcut button, all the control
buttons. In fact, if I could somehow automate printing reports, I would
hide it, too. Please reply with any recommendation.

Thanks very much,
Chuck


Create an autoexec macro. In the macro, run your reports, then quit the
app. You may want to inform the users the reports are running via a form.

Nov 13 '05 #5

P: n/a
Chuck Insight wrote:
Thanks for this reply, but this will not quite get the complete job done.

Closer to what I had in mind would be making an executable file that:
1 - hides everything except the auto-execute opening switchboard,
2 - exits the application if the user exits the switchboard,
3 - prohibits viewing everything but the switchboard, yet
4 - supports all the functionality built into the application

Again, thanks
Since the user can only view a switchboard, what functionality is there
but exiting the app?

"Salad" <oi*@vinegar.com> wrote in message
news:T%*****************@newsread1.news.pas.earthl ink.net...
Chuck Insight wrote:

Hi All,

I just finished creating my first all-inclusive MS-Access application.
Ideally, I would prefer to prevent mischievous users from accessing
everything except the switchboard items. This would include the menu
system and except for the "print" shortcut button, all the control
buttons. In fact, if I could somehow automate printing reports, I would
hide it, too. Please reply with any recommendation.

Thanks very much,
Chuck


Create an autoexec macro. In the macro, run your reports, then quit the
app. You may want to inform the users the reports are running via a form.


Nov 13 '05 #6

P: n/a
Chuck Insight wrote:
Thanks for this reply, but this will not quite get the complete job done.

Closer to what I had in mind would be making an executable file that:
1 - hides everything except the auto-execute opening switchboard,
2 - exits the application if the user exits the switchboard,
3 - prohibits viewing everything but the switchboard, yet
4 - supports all the functionality built into the application

Again, thanks
Since the user can only view a switchboard, what functionality is there
but exiting the app?

"Salad" <oi*@vinegar.com> wrote in message
news:T%*****************@newsread1.news.pas.earthl ink.net...
Chuck Insight wrote:

Hi All,

I just finished creating my first all-inclusive MS-Access application.
Ideally, I would prefer to prevent mischievous users from accessing
everything except the switchboard items. This would include the menu
system and except for the "print" shortcut button, all the control
buttons. In fact, if I could somehow automate printing reports, I would
hide it, too. Please reply with any recommendation.

Thanks very much,
Chuck


Create an autoexec macro. In the macro, run your reports, then quit the
app. You may want to inform the users the reports are running via a form.


Nov 13 '05 #7

P: n/a
On Sun, 17 Jul 2005 20:28:26 GMT, Salad <oi*@vinegar.com> wrote:
Since the user can only view a switchboard, what functionality is there
but exiting the app?


I'm sorta new at Access but I have written some apps using VB and
Access in the back but I have never come across the term switchboard?

What does it mean?

Thanks.
Nov 13 '05 #8

P: n/a
On Sun, 17 Jul 2005 20:28:26 GMT, Salad <oi*@vinegar.com> wrote:
Since the user can only view a switchboard, what functionality is there
but exiting the app?


I'm sorta new at Access but I have written some apps using VB and
Access in the back but I have never come across the term switchboard?

What does it mean?

Thanks.
Nov 13 '05 #9

P: n/a
Rog
New Guy,

A switchboard is a system of one or more menu forms. You can use the
switchboard manager (under tools / add-ins) to create one.

Rog

Nov 13 '05 #10

P: n/a

"Chuck Insight" <j.*******@insightbb.com> wrote in message
news:y6yCe.162031$_o.44926@attbi_s71...
Thanks for this reply, but this will not quite get the complete job done.

Closer to what I had in mind would be making an executable file that:
1 - hides everything except the auto-execute opening switchboard,
Right click on the database window, click on startup.
Enter you swichboard form in Display Form: "May not need autoexec
macro"
Uncheck display database.
2 - exits the application if the user exits the switchboard,
Add "Application.Quit acPrompt", to the On close event of your switchboard
3 - prohibits viewing everything but the switchboard, yet
These are 2 soft security steps, easily bypassed by knowledgeable users.

Add a macro named {F11} to disable using F11 do display the database.
Create a new application toolbar and have your switchboard switch it for the
default.
4 - supports all the functionality built into the application

Again, thanks
"Salad" <oi*@vinegar.com> wrote in message
news:T%*****************@newsread1.news.pas.earthl ink.net...
Chuck Insight wrote:
Hi All,

I just finished creating my first all-inclusive MS-Access application.
Ideally, I would prefer to prevent mischievous users from accessing
everything except the switchboard items. This would include the menu
system and except for the "print" shortcut button, all the control
buttons. In fact, if I could somehow automate printing reports, I would hide it, too. Please reply with any recommendation.

Thanks very much,
Chuck
Create an autoexec macro. In the macro, run your reports, then quit the
app. You may want to inform the users the reports are running via a

form.

Nov 13 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.