RE: [Talk] Open Access routines using Boston Workstation

[Thom C. Blackwell]

Title: Open Access routines using Boston Workstation

Greetings, If I am understanding this correctly – you are going to have Access forms that will populate tables – then that info needs to get into the HIS (once a month). The DataStation can read directly from Access tables (or from queries) similar to how you’d read from an Excel spreadsheet or flat file. So no need to “hook the form” into the script – or to embed the script into the Access application - this would be the easier approach and therefore my recommendation.   Let me know if I’m on the right track here.   Thom C. Blackwell Product Manager Boston Software Systems www.BostonWorkStation.com 866 653-5105 - ex 807 [EMAIL PROTECTED] From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pat Thomson Sent: Wednesday, May 03, 2006 3:01 PM To: talk@bostonworkstation.com Subject: [Talk] Open Access routines using Boston Workstation   Has anyone experience running Access2000+ data load and form routines with  Boston Workstation? Basically,  I am running a script to perform multi-file validation, then upon successful validation, I need to open an Access Form to load files into tables and perform various other access commands to accumulate and consolidate data. I will then run a nested script to archive the files I've loaded into Access.  Once a month,  I will import this consolidated data (from these Access tables)  into my HIS system. I don't have Visual basic developers or Access developers and am thinking I need to do this through DAO however, if you have worked with interfacing Access forms with your scripts,  I would appreciate hearing from you. Thanks Pat Thomson Support St. Joseph's Healthcare Hamilton. Donate today at www.stjoesfoundation.ca