How to LOAD access form without ribbons and toolbar?

[taimysho0]

Hello, is there a way for my form to load on it own without an access background? (ribbons, menus, toolbar, etc). for example when the user clicks on the .accdb file, the form itself should just appear. thanks

[June7]

This link indicates this is a simple setting in Access 2003 http://office.microsoft.com/en-us/ac...005188503.aspx and http://www.techrepublic.com/blog/mso...cess-data/2014. I don't find this setting in Access 2007/2010.

I have seen a sample db that shows how to do this programmatically but not sure I will ever find it again. Google: Access vba hide the application window. Here are other references
http://www.tek-tips.com/faqs.cfm?fid=2562.
http://www.access-programmers.co.uk/...d.php?t=115646
I do customize the ribbon/QAT - review http://forums.aspfree.com/microsoft-...at-303789.html

[sw1085]

This may help:

http://www.techrepublic.com/blog/mso...xcel-2007/1131

Hello, is there a way for my form to load on it own without an access background? (ribbons, menus, toolbar, etc). for example when the user clicks on the .accdb file, the form itself should just appear. thanks

[taimysho0]

thanks jun, i got it to work, however do you know how to add all the access menus to the form? thanks!

[June7]

Not sure what you mean. Want to explain more what you are looking for?

[redbull]

Ive been using this bit in some of my programs.. it works in both 2003 and 10...

Private Sub Form_Current()
On Error Resume Next
DoCmd.ShowToolbar "Ribbon", acToolbarNo

This code does not have to be on Form Current, could be on load as well. The on error resume next is what makes it work in 2003.

The only thing this does it HIDE that ridiculous sized ribbon toolbar. You still have to go to (Tools ~> Startup) to change other toolbar options, for 2003 that is.

Hope this helps.