Form Problems

[mis]

Hi Forum,

I have created a database can I am trying to create an interface for them. I would like to get the database to do the following when it is loaded.

I would like a form to equal the size of the monitor, so the user cant see the desktop. I would then like a switchboard to loaded in front of this maximum form were the user can open the different forms and enter data etc.

It this possilble.

 

[a.sinatra]

Why would you want a blank form to be loaded?
________
Free Themes

 

[mis]

Background

So it loads as a background. So when opening small forms they will not just be a little window on the desktop were the user can click off the form and cause problems.

 

[Parker]

So it loads as a background. So when opening small forms they will not just be a little window on the desktop were the user can click off the form and cause problems.

I think I know what you are looking for but correct me if I am wrong.

First, I can’t see why you would want to open a form behind your switchboard. Use your switchboard to fill the screen.However,

First thing you need to do is disable the windows task bar as this can be used to min. apps. ----- My end users are pretty dim so I just hide it and tell them it’s not available but sooner or later they will discover the key shifts to pull it up and then I’ll have to investigate killing it completely.

Create a custom menu, disable standard access menus
(Application.SetOption "Built-in Toolbars Available", False)
Have your custom menu’s load when you open the db.

Design your switchboard form to run maximized. Disable min, max and close buttons in the forms properties. (Do not forget to include an “Exit this App.” Button on the form)

Behind the “On Open” for your switchboard form event put “DoCmd.Maximize”

Make the form “modal”

Now you can either, create a desktop shortcut to start your app, or, you can be really mean like me and put it as the last event in your start-up bin.
That way it takes over as soon as someone pushes the go-go button.

Open all other forms over th top. ( if you put all your controlls in the middle of the maximized form then other forms will hide it if you open them cetralised in the window).

This is by no means secure and end users with any knowledge of computers will be able to get round it. (Ctr + esc will call the taskbar and start menu)But it will achieve the “look” I believe you are after.

To carry this to the next stage.

Create a start-up routine that disables the shift key and hides the db window.

Use a system of pass worded login with user level security.

Or (the near ultimate for Access) split the app into FE & BE and create an .mde.

Whatever security methods you use remember to give yourself a private entrance (Back Door) that gives you full control. It can be the biggest pain in the butt when you realise that you need to crack your own security in order to fix or modify your app.

Hope this helps

Pete

 

[Rich]

If you set the forms PopUp and Modal properties to yes then users will not be allowed to open other forms etc from the db window

 

[Parker]

If you set the forms PopUp and Modal properties to yes then users will not be allowed to open other forms etc from the db window

Too true but surley if you then open another form that is not Modal this would breach this security and enable the F11 key?

 

[mis]

Thanks

That is great, i have a problem designing the form as the design view is small than the maximised screen view how can I get the design view to meet the same size of the maximum when it loads?? so i can position all the fields etc on it.

 

[Parker]

Err "maximise"?

And then stretch the form boudries to fit the screen

 

[Rich]

Too true but surley if you then open another form that is not Modal this would breach this security and enable the F11 key?

Make them all Modal

 

[billyr]

User access level

mis, from somewhere in Access World (Its been a while), I got a module which allowed me to enable/disable database properties - even the "shiftkey" bypass. My user table has a field for access level (1,2) for each user. The properties module sets properties accordingly. Storing the access level in a public variable allows me to disallow access to certain forms also. I did embed a fail safe password in my code to assure I can always get to everything. This was "back" in the access '97 days for me but I still have the code if you are interested.

 

[Rich]

Thanks for the offer but I don't have any problems with forms etc.

 

[billyr]

You caught the mistake while I was correcting it. Now you know what a "senior moment" is. Nothing like a demonstration eh?

 

[mis]

More Problems

Forum,

Changed the form design silently I have got a main form that is maximised and is constant, there is a section under the header that i would like to get the forms to load under and fill the size of the screen i have got the measurements with is 22.33cm width and 17.039 cm height but when placing this into the form it cuts the top off !! see image to moved the title of the form down as it was being cut off

any idea and can you stat the x,y corodinates??