Just a thought - could you use an AUTOEXEC macro in Access? The macro fires when you use BWS to open the database. Don't forget to include an EXIT command.
Hold down the SHFT key when you manually open the database to keep the macro from automatically running. Thankyou, Steven Borland, Project Coordinator Information Systems and Technology TEMPLE UNIVERSITY HEALTH SYSTEM (215) 707-5272 [email protected]<mailto:[email protected]> From: [email protected] [mailto:[email protected]] Sent: Monday, August 05, 2013 9:39 AM To: [email protected] Subject: RE:[talkbws] #safe# Click Function Hi, I don't know if this is an option for you or not, but since I'm our BWS programmer and Access Database programmer, I get to "cheat" a little. I have also had issues working with Access using BWS, but I have had some success with one of two methods: * I added a hot key to my "import" button in Access using the letter "U" for update. After connecting / activating the Access form, I Key "U" in BWS and update the database. * If that doesn't work (because I agree BWS and Access don't seem too friendly), I create an update macro in Access as well as a bat file with the update macro, and then I use the shell command in BWS to fire off the bat file which in turn opens the database and performs the update. Example Shell - Shell ("c:\Batches\UpdateOccupancySummary.bat") Example Bat file: @ECHO OFF c: cd \program Files\Microsoft Office\Office14 msaccess.exe "\\W2k-hrmc\apps\Occupancy Summary\OccupancySummary.mdb<file:///\\W2k-hrmc\apps\Occupancy%20Summary\OccupancySummary.mdb>" /x update EXIT Darryl Clemmons Systems Analyst [http://intranet/hrmc/logo/email.JPG] Phone - (252)535-8562 Fax - (252)535-8563 email - [email protected]<mailto:[email protected]> Website - www.halifaxregional.org<http://www.halifaxregional.org> From: [email protected]<mailto:[email protected]> [mailto:[email protected]] Sent: Friday, August 02, 2013 4:58 PM To: [email protected]<mailto:[email protected]> Subject: RE:[talkbws] #safe# Click Function In my <limited> experience, I have found Access forms to be sort of odd ducks when it comes to directly interacting with them via the Windows connections. Their buttons and fields may not have window handles like normal buttons etc would in a windows application. First thing to try is Connect to it using Windows, see if the button shows up in the Advanced Windows List build the click as you would for any other windows app. Now if you don't see your button in the list (which wouldn't surprise me with Access forms... You could also see if Smart sees the button. If it doesn't, you could try a Smart location and just fire a click that way at it - see if it works. If that doesn't then we're looking at just firing a click at a spot Use Activate "Form title goes here" Wait 'just in case it wasn't the foreground window, give it a bit of time to become it after the activate ClickEx Getforegroundhwnd,X, Y 'ClickEX has a parameter where you can see where the mouse is going, keep changing X and Y until it hits the button Another approach entirely would be to use the Access object model - that's beyond what I could explain here - but my guess is you could programmatically upload this data and avoid firing clicks entirely. Thom C. Blackwell, VP Technical Services Boston Software Systems, Inc. Phone: 866.653.5105 x807 Mobile: 508.423.8463 Fax: 508.319.3015 www.bostonsoftwaresystems.com<http://www.bostonsoftwaresystems.com/> Healthcare Automation - Revolutionizing How You Work. The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] Sent: Friday, August 02, 2013 4:46 PM To: Talk Subject: [talkbws] #safe# Click Function I am running a report through Meditech and when it's completed it is linked to an Access Database to execute certain data. I am running a script through Boston to open the database and click the Import File button to compile the data needed. How do I write the Click function in Boston to click a command button on the Access Database Form? I am currently using the Key function to use the shortcut keys to the button. Click([Window],[DblClick As Boolean = False . . . . . . . . so on and so on. Thank you, Jesus --- To post a message to this list, send mail to: [email protected]<mailto:[email protected]> You are currently subscribed as: [email protected]<mailto:[email protected]> Unsubscribe in the customer center on our website: http://www.bostonsoftwaresystems.com/Customers/ListServe.aspx --- To post a message to this list, send mail to: [email protected]<mailto:[email protected]> You are currently subscribed as: [email protected]<mailto:[email protected]> Unsubscribe in the customer center on our website: http://www.bostonsoftwaresystems.com/Customers/ListServe.aspx The information contained in this e-mail message is intended only for use of the individual or entity named above. If the reader of this message is not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender at the above address/telephone number. --- To post a message to this list, send mail to: [email protected]<mailto:[email protected]> You are currently subscribed as: [email protected]<mailto:[email protected]> Unsubscribe in the customer center on our website: http://www.bostonsoftwaresystems.com/Customers/ListServe.aspx ________________________________ This electronic message is intended to be for the use of the named recipient, and may contain information that is confidential or privileged. This communication may contain protected health information (PHI) that is legally protected from inappropriate disclosure by the Privacy Standards of the Health Insurance Portability and Accountability Act (HIPAA) and relevant Pennsylvania Laws. You can direct questions concerning PHI or HIPAA to the Corporate Compliance and Privacy Officer at (215) 707-5605. If you are not the intended recipient, please note that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this message in error, you should notify the sender immediately by telephone or by return e-mail and delete and destroy all copies of this message. --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonsoftwaresystems.com/Customers/ListServe.aspx
<<inline: image001.jpg>>
