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" /x update
EXIT
Darryl Clemmons
Systems Analyst
[cid:[email protected]]
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]]
Sent: Friday, August 02, 2013 4:58 PM
To: [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
<html><td><span style="max-width:450px;"><font size="2pt" face="verdana"
color="black">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. </span></td></font></html>
--- 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>>
