A few lines of code (bassaccesshider, found at
http://www.tek-tips.com/faqs.cfm?fid=2562 and elsewhere) did a
beautiful job of completely hidding all elements of the Access
environment (Access window, etc.), so the only thing visible was your
application, consequently, your average end-user did not even know
they were in an Access-based application. However, under one of my
current environments (Access 2010 running under Vista 64) this
solution no longer works. Additional lines of code may hide some of
the newer elements of the environment such as the ribbon, etc., but
not everythingas before (Access 2003 under Windows XP in my case),
although I have read "basaccesshider" still works perfectly in Access
2010 running under Vista 32, a claim which, if true, leads to the
side-question, why would it work under Vista 32 and not Vista-64.

My question, though, is: Is it possible to come up with a single block
of VBA code that will consistently hide all elements of the Access
environment except for your application, regardless of which version
of Access and/or Windows it is running under? Perhaps even by first
having the code determine which version is running, then running
diffenret lines as needed?

Actually, I use one line of code:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

The above hides everything.

The additonal settings are:
Tabbed windows
Turn off display tabs
Hide navagation pane.

If you do the above, then with the ONE LINE OF CODE all you will see is
this:
http://cid-b18a57cb5f6af0fa.office.l...3/formonly.png

If above does not show, then try this link:
http://public.bay.livefilestore.com/...nly.png?psid=1

Note in the above picture how you see the windows desktop.
Note in the above how you only see the form and none of the Access interface

Of course for the form, I turned off things like navigation and record
selector.

My whole point is that all of the above was done with the one line code as
per above.
So, you can well hide everything with one line of code.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com

On Fri, 15 Apr 2011 18:53:19 -0600, "Albert D. Kallal"
<PleaseNOOOsPAMmkallal (AT) msn (DOT) com> wrote:

The screen shot shown in
http://cid-b18a57cb5f6af0fa.office.l...3/formonly.png
is exactly what I get in an Access 2003/Windows XP environment using
basaccesshider, however, in AC2010 running on Vista 64 I do not get
the same results, even after I include the line you suggested to hide
the ribbon, together with the additional settings you mentioned.

I thank you for your suggestion anyway.

wrote in message news:579jq6leunv7p9e3mlvsqig841k2llc9ce (AT) 4ax (DOT) com...


Well I do get those results.
So you simply not following instructions.

Try the sample myhide3.zip here:

http://cid-b18a57cb5f6af0fa.office.l...Public/Shuttle

As noted, one line of code is all I needed.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com

On Sat, 16 Apr 2011 23:43:57 -0600, "Albert D. Kallal"
<PleaseNOOOsPAMmkallal (AT) msn (DOT) com> wrote:

Your example does work as desired, however, as stated in my original
message, what I am trying to determine is if it is possible to
implement a solution that, without having to revisit the code, would
yield the same clean results across several versions of Access, at
least from AC2003 to AC2010, running on Windows XP and later, both 32
and 64 bit versions. It would seem that:

Private Sub Form_Load()
DoCmd.ShowToolbar "Ribbon", acToolbarNo
End Sub

Will not achieve this. In fact, even the following will not hide all
elements of the Access environment except for the actual application
forms, which is the desired final result.

Private Sub Form_Load()
If Val(Access.Version) >= 12 Then
strMenu = "Ribbon"
Else
strMenu = "Menu Bar"
End If
DoCmd.ShowToolbar strMenu, acToolbarNo
End Sub

I do thank you for your help.

Arsene