Question How Can I only open a MS Access Form without Access running in the background?

[clarerome14]

I have made a form on access which will be used by other employees within the company, however they have never used access before and they are wanting to access only just the form as I feel with Access and all the tools in the background will confuse them, plus I don't want them editing the data base its self.

Is there a way to only bring up the form, unless I obviously need to edit the date base.

I've done some research on Google and it seems I need to use:

SW_SHOWMINNOACTIVE

However I can not seem to find how I would use this or where?

and also if i did find a way to only bring up the form, how would I be able to switch it from that veiw to the veiw I edit in?

Can somebody please help.

 

[DavidAtWork]

I assume you mean you want users to be able to use the form to enter data and not be able to see any of the toolbars or database window. This is possible but it depends on how Access savy your users are, it sounds like Access is new to your users and in this case you'd get away with writing a start up function that will disable all toolbars, hide the database window and open the required form. This start up procedure can be called from an autoexec macro.
When you come to open it, you can use the shift key to bypass this start up procedure allowing you to operate as normal

David

 

[clarerome14]

Yes, exactly like that.

I already have a Autoexec Marco, which starts the form up, how would I go about disabling all the toolbars.

Also I do not want to maximize the form, is there a way to enable it so i can just see the form, ie. no access screen behind it. just say my desktop?

Sorry Im really no good at explaining.