Form on full screen.

[Jamaluddin Jamal]

Hello everyone.

Is there any way to create a full screen form, like MDI. I used a method earlier in which form covered whole screen including Task Bar.

 

[HiTechCoach]

Is the database set to use Tabbed documents?

You will find the setting in Acess Options > Current Database

 

[Jamaluddin Jamal]

Is the database set to use Tabbed documents?

You will find the setting in Acess Options > Current Database

I think I missed something. I want a Form to be filled Whole Screen like individual application, and the Access Windows be hide from users. Only Main Forms with all Child Forms (in Pop Up/ Model property yes).

 

[isladogs]

Either I'm also missing something or what you mean is very simple

In Access options, set forms to use overlapping windows and also hide the navigation pane

In the form load event for each form use

docmd.Maximize

Finally in Windows set task pane to hide automatically

Hopefully that covers what I think you mean

 

[HiTechCoach]

I think I missed something. I want a Form to be filled Whole Screen like individual application, and the Access Windows be hide from users. Only Main Forms with all Child Forms (in Pop Up/ Model property yes).

I think you are wanting to hide the Access Application Window any use only POP-up for.

I have been down the rabbit hole. Acess 2007 and after really do not play well when you hide the Application Windows. Things like report preview will not work.

IMHO, you should avoid trying to hide the Access Application Window.


DWIW: I also use the free Access Runtime a lot and it violates the license agreement to hide the Access Application Windows

 

[Jamaluddin Jamal]

I think you are wanting to hide the Access Application Window any use only POP-up for.

I have been down the rabbit hole. Acess 2007 and after really do not play well when you hide the Application Windows. Things like report preview will not work.

IMHO, you should avoid trying to hide the Access Application Window.


DWIW: I also use the free Access Runtime a lot and it violates the license agreement to hide the Access Application Windows

Yes, I want to hide the Access Application windows.

 

[isladogs]

Did my earlier suggestions do what you wanted?

If not, two further suggestions

In one of my production databases, the nav pane & ribbon are hidden to all standard users. It also contains code to display the print preview ribbon when each report loads then hide it again when it closes. It works well and makes the database very secure.

If you want even more security, you'll then need to convert to an Access executable

Alternatively, if you want to hide everything and just have the current object on the screen then see post 8 in this thread.

https://www.access-programmers.co.uk/forums/showthread.php?t=284248

 

[CJ_London]

I also use the free Access Runtime a lot and it violates the license agreement to hide the Access Application Windows

I always hide the application window in production versions which may or may not be run in a runtime environment - I've never heard of it violating the license agreement - where does it say that?

 

[isladogs]

Although I'm still not clear what you are trying to do, you may be interested in an example database I have just created to show how the Access application interface can be controlled in various ways.
Some of these methods can be used to make a database more secure.

It is intended to demonstrate that all of this is easy to do safely and without any issues arising

The item can be found in the code repository in the thread:
https://www.access-programmers.co.uk...d.php?t=293577

 

[Jamaluddin Jamal]

Post is considered SOLVED for me!!

 

[HiTechCoach]

I always hide the application window in production versions which may or may not be run in a runtime environment - I've never heard of it violating the license agreement - where does it say that?

Here is what you agreed to when you install it:

"keep the status bar containing the statement "Powered by Microsoft Office
Access" displayed in your user interface to be viewed by users at all times;"

 

[CJ_London]

Still news to me - where can that statement be found? Can you provide a link? All I can find is this thread on the subject https://bytes.com/topic/access/answers/733532-powered-ms-access

but reading the EULA makes absolutely no mention of the requirement.

 

[isladogs]

@CJ_London

I always hide the application window in production versions

I consider the application window to be the 'outer containing window' with the title bar.
Are you referring to the navigation pane?

I also hide the nav pane in ALL production versions EXCEPT for users with full admin rights.
Occasionally, I will also hide the application window e.g. to have a splash screen 'floating' on the desktop.

EDIT:
Just found this link which covers the runtime licence agreement .... for Access 2007:
https://www.office-forums.com/threads/access-runtime-license-terms.434705/

I can't find anything that refers to later versions of the runtime.
However, I rarely use the Access runtime version for production databases

@HiTech
In an earlier post, you were adamant that hiding the application window was full of problems

I have been down the rabbit hole. Acess 2007 and after really do not play well when you hide the Application Windows. Things like report preview will not work.

IMHO, you should avoid trying to hide the Access Application Window.

Have you looked at my post in the code repository where I show how this CAN be done without any problems?
I also show how to deal with the print preview ribbon
I would be interested to know what you think.

See the thread:https://www.access-programmers.co.uk...d.php?t=293577