Access 2013: API code to put hidden database icon in taskbar?

I have Access 2013 databases with hidden database windows and popup, modal forms and it works, but there is no icon in the taskbar for users to switch between applications.
I found this : http://stackoverflow.com/questions/26594043/access-application-hidden-application-window-with-form-taskbar-icon

I can't get it to work. Is it necessary to include a reference in order to use API functions?
Thanks In Advance.
LVL 1
machine_runAsked:
Who is Participating?
 
Helen FeddemaCommented:
If you just want to have a taskbar icon to open this database, try the technique in this Access Archon article (Making an Access Database Taskbar Item).  The steps are listed below (shorn of screen shots); the full instructions are in the attached article.  (No API calls needed!)

1.      Create a folder for the new toolbar – I made one called Taskbar Items under the default folder for my user name.
2.      Right-drag the database to the new folder, and select Create Shortcut Here from the context menu when dropping it.
3.      Edit the shortcut name as desired.
4.      Right-click the taskbar and select New toolbar…
5.      Select the Taskbar Items toolbar:
6.      The new toolbar appears on the right side of the taskbar, with the toolbar name displayed:
7.      Unlock the Taskbar if it is locked:
8.      Right-click the toolbar name and uncheck the Show Text and Show Title items:
9.      Now you will see a small Access icon representing the database, that you can click to open the database, just as in Windows XP:
Access-Archon-Column-237----Making-a.doc
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<I can't get it to work. Is it necessary to include a reference in order to use API functions?>>

No, no references.  Your code should compile fine.

Would you consider putting it in the system tray by the date and time?

Jim.
0
 
machine_runAuthor Commented:
When debugging :

WStyle = GetWindowLong(frmHwnd, GWL_EXSTYLE)  
Error = GWL_EXSTYLE variable not defined.

WStyle = WStyle Or WS_EX_APPWINDOW
Error = WS_EX_APPWINDOW variable not defined.

Others also.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<WS_EX_APPWINDOW>>

 You missed copying something then or they did not post the full solution.

 Those are constants  or type structures that are required.  I would dig them out for you, but I'm very short on time at the moment and you should be able to find them on-line easily enough with a quick google search on either the constant or the API call.

Jim.
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
>"I have Access 2013 databases with hidden database windows and popup, modal forms and it works, but there is no icon in the taskbar for users to switch between applications."

are you are opening a second database from VBA? if so, what code are you using?
0
 
machine_runAuthor Commented:
crystal, no, just opening one.
0
 
machine_runAuthor Commented:
Helen_Feddema,

This solution is GLORIOUS!
I have each database in the taskbar (separate folders) with custom icons and NO API spaghetti!

THANK YOU THANK YOU
0
 
machine_runAuthor Commented:
EXCELLENT!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.