Drew Wutka
DWUTKA at Marlow.com
Fri Apr 1 16:06:29 CDT 2011
Glad it worked perfectly for you! That's what I like to hear about my sample systems. ;) I wonder if MS ever looked at it. Years ago this came up, it was Susan that wanted it, because she was copying and pasting data from the web into an Access form, and wanted the form to always be on top. MS's knowledge base had an article using a form timer... I submitted my solution to them, never heard back. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Friday, April 01, 2011 3:57 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Can it be done? Drew: Thanks so much for the demo. It worked perfectly. My client will be ecstatic. Best, Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Thursday, March 31, 2011 11:21 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Can it be done? Yes, I'm sending you my 'always on top' demo off list. You can do this with a timer, which is ugly, and pointless. Access forms are subclassed windows, which make them act a little different than regular windows. For a regular window, setting the ZOrder to -1 will put it on top of other windows. With an access form, you set the ZOrder to -1 for the Access window itself, and then hide the Access window. Then the visible 'popup' form is on top of everything on your desktop. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Thursday, March 31, 2011 12:43 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Can it be done? Dear List: A client - has a law firm - wants a pop up form on an existing time keeping form with ten buttons that would be assigned to various clients and legal matters. So when they click a button, the timer changes from the current matter to the one assigned to that button and starts running the clock for the new matter. No problem. But he says he also wants that pop up form to be on top when a lawyer is working on a word doc or other application so that they can switch their timekeeping clock from one matter to another without having to go back to the access app to do it since they may have 10 or fifteen windows open and finding the access app would be awkward for them. I guess if a lawyer is working on a matter and the phone rings they'd want to change the timer from the current matter to the one on the phone - things like that. Anyway, can this be done? MTIA Rocky Smolin Beach Access Software 858-259-4334 Skype: rocky.smolin www.e-z-mrp.com <http://www.e-z-mrp.com/> www.bchacc.com <http://www.bchacc.com/> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.