Tossing your records in an Access database and using SQL is a nice flexible (and fun) approach. In this case, you're bypassing the data station altogether and using ADO and recordsets to cycle through your records. Good luck!
Tom Choiniere I.S. - Systems Analyst Saratoga Hospital 211 Church Street Saratoga Springs, NY 12866 518-583-5994 [email protected] From: [email protected] [mailto:[email protected]] Sent: Thursday, December 10, 2009 2:52 PM To: [email protected] Subject: [talkbws] Datastation Record Search Anyone know if there is a FASTER way to search through dataStation Records? If I have 700 records, but only 200 of them match my criteria is there a way to jump from matching record to matching record? Or do I need to figure out a VB solution to this? Criteria would always be ###R, ###0, or ###E for a partial match. Right now line by line searching using steps is working, but I always run the risk of my meditech screen timing out and dropping back a screen (or 2). If possible I'd rather just jump around (using an Array if needed); D.Recored = 10, D.Record = 171, D.Record = 245, etc,,, Thanks. Brian Bennett Affinity Health Systems Systems Analyst PBS\Clinic Billing (920)628-9055 [email protected] ________________________________ CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may contain confidential and privileged information for the use of the designated recipient(s) named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify the sender at the electronic mail address noted above and destroy all copies of this communication and any attachments. Thank you for your cooperation. --- 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.bostonworkstation.com/customer_center/virtual_user_group_talk .aspx This e-mail communication and any attachments may contain confidential and privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify Saratoga Hospital immediately by e-mail at [email protected] and destroy all copies of this communication and any attachments. --- 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.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
