Borderless Access

[tmyers]

Would someone happen to have a link to one of IslaDogs post that details how to make access "borderless"? I cant seem to find it and have a new computer so no longer have it bookmarked

 

[jdraw]

Try

Control Application Interface

This article discusses how the Access application interface can be controlled including hiding the navigation pane, ribbon or the entire application interface. Some methods can help make a database more secure. The example app opens with a form 'floating independently' on the desktop. Various...

www.isladogs.co.uk

 

[theDBguy]

Maybe this one?

Control Application Interface

This article discusses how the Access application interface can be controlled including hiding the navigation pane, ribbon or the entire application interface. Some methods can help make a database more secure. The example app opens with a form 'floating independently' on the desktop. Various...

isladogs.co.uk

Edit: Oops, too slow.

 

[tmyers]

No that was not it. Sharing that helped me narrow the search down however and I found it

Show/hide application window, navigation pane, ribbon, taskbar

I have created an example database 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 This item...

www.access-programmers.co.uk

 

[theDBguy]

No that was not it. Sharing that helped me narrow the search down however and I found it

Show/hide application window, navigation pane, ribbon, taskbar

I have created an example database 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 This item...

www.access-programmers.co.uk

LOL. Glad to hear you found it!

 

[isladogs]

For info, the latest version is always available on my website - see the links provided in posts #2 & #3.

 

[Gasman]

You are able to export/import bookmarks?
I just moved to a new (to me) laptop and did just that.

 

[jdraw]

Congrats on the new laptop Paul.

 

[Gasman]

It was my old works laptop, and my personal one went haywire.
It is an i7 with 12gb ram and 1Tb drive, so quite a step up.

 

[tmyers]

My previous computer died unexpectedly, so I was not able to export the bookmarks off .
Either way I have added both links to my bookmarks now

 

[Gasman]

Unless the hard disk died, all your data is still available to you? Hopefully you will have backups.

All you need is a simple adaptor.
A 3.5" drive will need a powered version. I have one of those as then it handles both 3.5" and 2.5" drives.

If you have a new desktop, just put it into that, and all your data will be there.?

Google Search

 

[tmyers]

Sadly it was an SSD that for one reason or another decided it would rather have a career as a paperweight then a storage device and it was a very sudden and impulsive decision on its end.

 

[Gasman]

Sadly it was an SSD that for one reason or another decided it would rather have a career as a paperweight then a storage device and it was a very sudden and impulsive decision on its end.

Ouch

I had a disk drive where the heads got stuck. I had nothing to lose, so I opened it up and freed the heads. Then I went out, bought a new larger disk, and copied all the data to the new disk whilst it was still working.

 

[isladogs]

My recent experience was the PSU literally going bang with a smell of burning.
I was unable to access any of my files for 10 days until the replacement finally arrived.
Previously I lost both my main hard drive & main backup drive simultaneously. It took me months to recover most of the files from various sources

 

[tmyers]

We had a coworker come in awhile back and while doing the typical morning routine he turned his computer on and we heard a loud POP followed by a faint burning smell then smoke started pouring out of it. Once we got it handled and I took it apart to see what happened, the CMOS battery had apparently exploded and ignited the motherboard. Only time I have ever see that happen.

 

[Gasman]

When I worked in a school as an IT person, they had 6 new computers, which for some reason had dual voltage power supplies, 110 & 220.
The kids found out that if they switched them to 110, they would go pop.

We lost 2 computers pretty quickly, before we superglued the switch to the 220 setting.

 

[tmyers]

Isla, I am getting an error when trying to bring back the navigation pane and don't quite understand why.

If strUserPerm = 3 Then
    SetAccessWindow (SW_SHOWMAXIMIZED)
    DoCmd.ShowToolbar "Ribbon", acToolbarYes
    DoCmd.NavigateTo "acNavigationCategoryObjectType"
    DoCmd.RunCommand acCmdWindowUnhide
End If

This gets me:

I assume since it is in a hidden state, it cant be navigated to which then causes the unhide to error out.

 

[tmyers]

Never mind. Forgot I still had the sample database that had the code to restore it and just used that

 

[isladogs]

Just about to post when your follow up appeared...so I'll post anyway

The navigation pane can only be shown if the app window is visible
For example:

'show app window
SetAccessWindow (SW_SHOW)

'show nav pane 
 DoCmd.SelectObject acForm, , True

'maximise nav pane
DoCmd.NavigateTo "acNavigationCategoryObjectType"
 DoCmd.Maximize

'show ribbon
DoCmd.ShowToolbar "Ribbon", acToolbarYes

 

[tmyers]

Yup! I must say that I find your stuff really helpful. I enjoy "trying" to use it although I think this is the first access file I have made and got it to work how I envisioned