Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2016-09-01
8
Medium Priority
?
205 Views
Last Modified: 2016-09-04
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
Comment
Question by:machine_run
8 Comments
 
LVL 58
ID: 41780041
<<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
 
LVL 1

Author Comment

by:machine_run
ID: 41780091
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
 
LVL 58
ID: 41780123
<<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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 22
ID: 41780374
>"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
 
LVL 1

Author Comment

by:machine_run
ID: 41780446
crystal, no, just opening one.
0
 
LVL 31

Accepted Solution

by:
Helen Feddema earned 2000 total points
ID: 41783775
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
 
LVL 1

Author Comment

by:machine_run
ID: 41784092
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
 
LVL 1

Author Closing Comment

by:machine_run
ID: 41784094
EXCELLENT!!!
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question