Customise Access icon in Windows 7 taskbar

[vbaInet]

It just seems unnecessary to change the front end every day or even every time the shortcut is clicked. Surely the db doesn't bloat that badly. Your Sys Admins can schedule a task to replace the front ends every week when no one is in the office.

In addition, installation of a new front end (not a replacement) should be a controlled process. Even though you think it should work properly all the time, sometimes it doesn't. So I agree with replacing the front end every now and then but I'm not in favour with doing it for new front ends. That should be controlled.

 

[vbaInet]

Basically leave the power of distributing front ends or applications to your Sys Admins. That's their job and they do it in a controlled fashion.

 

[torz]

Hey guys, while we are bringing this thread back to life, using this code: http://access.mvps.org/access/api/api0045.htm (pretty sure this is basically the same as earlier in these posts)


Is there a way to have the systray icon there permanently?

I hide the whole access window currently and everything is run via popup forms. I use the minimize to try on some forms (where is when the icon appears in the try currently, but as soon as you restore its detroyed)

it can be painful getting back to your form sometimes when there are heaps of other windows on top of it (other programs etc) so I wanted the icon there permanently and then setup a right click to setfocus on the form so it comes on top of any other programs (if that is possible()


Thanks!

 

[vbaInet]

Not familiar with the Where command in Shell; is that a 'better' way of identifying the executable?

Forgot to reply to this. It's just a way of finding files. The registry is probably the better way.

Hey guys, while we are bringing this thread back to life, using this code: http://access.mvps.org/access/api/api0045.htm (pretty sure this is basically the same as earlier in these posts)


Is there a way to have the systray icon there permanently?

I hide the whole access window currently and everything is run via popup forms.

This thread is about icons in the taskbar not the notification area or systray. The workings are different.

 

[torz]

ahhh my bad, ill post it in one of the systray threads cheers

 

[AOB]

Basically leave the power of distributing front ends or applications to your Sys Admins. That's their job and they do it in a controlled fashion

Ahh, but what if my Sys Admins want nothing to do with this?

I totally agree with you but unfortunately that's not the way it works in here - at least not for this! Basically I'm building this as a workaround to avoid the 'proper' tech guys building something (which costs money)

So I'm basically the developer / maintenance / support / administrator for everything - hence I try to build in as much 'self-maintenance' as I possibly can so there's as little as possible for me (or my eventual successor) to have to actually do to support it.

Sucks to be me!

 

[vbaInet]

Sucks to be me!

Yes

Ok, this is how I would do it. Perform two checks before creating a fresh FE/shortcut:

1. Check a folder for the existence of a new FE. This will be used for updating the FE and you place a new FE in the folder whenever you want to update FEs.
2. Check a text file (or ini file) for the date the FE was last updated. This will be used as an alternative to Compact/Repair. You can set the date in the file to weekly, monthly or whatever you wish.
3. If any of the above criteria is met a new FE is copied across.

This way there's no "excessive" copying/pasting of files and deleting/creating of shortcuts.

Remember it's a shortcut so all that needs replacing is the FE file not the recreation of the shortcut.