Hiding ribbon window

[ItsMe]

The executible file will rely on RunTime. All of your VBA code will be compiled. Then, the app will only have the code that is available via RunTime. As long as you created your app to operate 100% in RunTime, there will not be an issue. Having said that, someone with a full version of office will still be able to access some objects like, tables for instance.



You will still need to incorporate code to hide stuff.

[data808]

How do you create an app to operate in runtime 100%? I know that in runtime accde the user will be able to access tables and queries. You mentioned full version of office. Does this mean that if someone that has home edition which does not come with Access, will they be able to run the database because its an executable? If so, that is pretty awesome?

[ItsMe]

Most User interaction with your app will utilize Runtime, regardless. The exception is when you interact with things like the navigation pane. You can download Access 2007, 2010 and I believe 2013 RunTime for free. This free downloadable version of Access is for Runtime Only and is not the full version, where the full version that is purchased allows you to interact with the development interface. The development/design interface does not depend upon RunTime.

[data808]

So anyway, this whole hiding the main Access Window is just not working out. The only problem I was having was with the reports. I have a filter that runs right before the report opens to give the filtered results and I couldn't get it to work properly so I have decided to just keep the main access window behind the forms and even though it does not look as nice, it will have to do. Thanks for the help guys.