Database STARTUP OPTIONS problem

[connexion]

I'm well and truly stuck here.

I have an access 2000 database and have set one of the database options to NOT show windows in the taskbar.
My machine does exactly what i expect, but when i am copying the same database which links to a BE database on the server to another user's machine, they start up the database and windows are bing shown on the taskbar.

I can manually change the setting on their machine, but this is VERY wierd in my opinion.

Anyone got any clues as to what to look for and where with this one??

Thanks
Vince

 

[ghudson]

Startup options are db specific so I am not sure while it will not work for your users. You can force it with VBA. Check out my thread on how to do it... hide all Access tool bars and menu bars for I list some tricks on how to hide other things in Access that you do not want the user to see.

 

[connexion]

Nearly...

Thanks for the reply.

Your code is fine and works a treat with startup options, BUT...
The problem is with tools/options/view windows in taskbar.

I'm not sure if you can set this in code or if it's something that you have to set manually?

Thanks
Vince

 

[connexion]

Very promising

Thanks for the reply to my post Pat.

I think i'd better go home now, but sad bloke that i am, i'm really looking forward to giving that one a try in the morning.

If that doesn't work, i'm going to find a tall tree and a short rope!...i am that confident!

Thanks

Vince

 

[ghudson]

The problem is with tools/options/view windows in taskbar.

I misunderstood what you were talking about until now.

To hide the different open forms, reports, etc. for Access 2000/2002/2003
you have to set the "Show Windows In Taskbar" to false...

Go to Tools / Options, then the View tab and deselect 'Windows in Taskbar'

OR

Call DisplayOpenWindowsInTaskbar(False)

Public Function DisplayOpenWindowsInTaskbar(bDisplay As Boolean)
On Error GoTo Err_DisplayOpenWindowsInTaskbar
    
    If bDisplay = True Then
        Application.SetOption "ShowWindowsInTaskbar", True
    Else
        Application.SetOption "ShowWindowsInTaskbar", False
    End If
    
Exit_DisplayOpenWindowsInTaskbar:
    Exit Function
    
Err_DisplayOpenWindowsInTaskbar:
    If Err.Number = 2091 Then 'ShowWindowsinTaskbar is an invalid name [Access 95/97 error]
        Exit Function
    Else
        MsgBox Err.Number & " - " & Err.Description
        Resume Exit_DisplayOpenWindowsInTaskbar
    End If
    
End Function

 

[connexion]

Thanks for the solution

Thanks for the reply Pat.

I've inserted the appropriate line
Application.SetOption "ShowWindowsInTaskbar", False
behind the logon form's load event, i'll deal with error handling if/when it becomes an issue.

Those pesky users won't be able to click them again now!! lol

Thanks

Vince

 

[ghudson]

i'll deal with error handling if/when it becomes an issue.

All of your VBA Functions() and Subs() should have proper error handling within each routine!

 

[connexion]

Error handling

I learnt about code from a developer that built the MDB for me.
Luckily i can learn pretty quick as he involved error handling in about 5% of 20,000+ lines of code!

During the last 3 years i have managed to keep it running as well as adapt and build quite a few new routines myself, and it has a pretty tough job to do in running almost our entire business.

My theory is...if it works...don't go messing with it...if it don't..then it should have been tested better before you started relying on it!

Thanks for your help though, i've done much tougher things than this before, but you know how it is, if it's something you haven't looked at before and the answer isn't obvious then almost anything can take forever!

Cool forum, i wish i could start up a company building a rival for access using some of the best barins from this site!

Vince