Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

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.
0
machine_run
Asked:
machine_run
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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
 
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now