[AccessD] MSComm control - Cross post AccessD & dba-vb

MartyConnelly martyconnelly at shaw.ca
Fri Jul 11 18:27:05 CDT 2003


Get a hexeditor for the textfile or read the text file into Access via a 
Byte string and Dec(myChar)
will give you decimal Ascii number.
Here is a free hexeditor I use
http://www.hhdsoftware.com/

Joe Rojas wrote:

>At the end of every "record" there are three nonprintable characters. I
>can't tell what exactly they are because when viewing the data that was
>captured to a text file in notepad all I see are 3 boxes. How can I use this
>to my advantage?
>
>Thanks!
>
>Joe R.
>
>-----Original Message-----
>From: John Colby [mailto:jcolby at colbyconsulting.com]
>Sent: Friday, July 11, 2003 11:58 AM
>To: Access Developers discussion and problem solving
>Subject: RE: [AccessD] MSComm control - Cross post AccessD & dba-vb
>
>Does the device send a terminator?  A fixed length string?  I would think it
>has to send a terminator character saying it's "done".
>
>John W. Colby
>www.colbyconsulting.com
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Joe Rojas
>Sent: Friday, July 11, 2003 10:54 AM
>To: 'Access Developers discussion and problem solving'
>Subject: [AccessD] MSComm control - Cross post AccessD & dba-vb
>
>
>Hi All,
>
>I am using the MSComm control to capture data the is coming over the serial
>port.
>I am using the OnComm event to determine when data is received by looking at
>the ComEvent property and detecting a comEVReceive status.
>
>When the attached device sends information to the serial port it actually
>send 3 lines of information (on average, could be more).
>What I am wondering is when does the OnComm event fire? Does it fire after
>all the data has been received or does it fire as soon as the first
>character is received into the input buffer? What I am trying to avoid is
>pulling the data from the input buffer before all the data is there. That
>way I can capture everything I need before I start parsing the data.
>
>Any ideas?
>
>Thanks!
>Joe R.
>
>
>
>This electronic transmission is strictly confidential to TNCO, Inc. and
>intended solely for the addressee. It may contain information which is
>covered by legal, professional, or other privileges. If you are not the
>intended addressee, or someone authorized by the intended addressee to
>receive transmissions on behalf of the addressee, you must not retain,
>disclose in any form, copy, or take any action in reliance on this
>transmission. If you have received this transmission in error, please notify
>the sender as soon as possible and destroy this message. While TNCO, Inc.
>uses virus protection, the recipient should check this email and any
>attachments for the presence of viruses. TNCO, Inc. accepts no liability for
>any damage caused by any virus transmitted by this email.
>_______________________________________________
>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
>
>
>
>This electronic transmission is strictly confidential to TNCO, Inc. and
>intended solely for the addressee. It may contain information which is
>covered by legal, professional, or other privileges. If you are not the
>intended addressee, or someone authorized by the intended addressee to
>receive transmissions on behalf of the addressee, you must not retain,
>disclose in any form, copy, or take any action in reliance on this
>transmission. If you have received this transmission in error, please notify
>the sender as soon as possible and destroy this message. While TNCO, Inc.
>uses virus protection, the recipient should check this email and any
>attachments for the presence of viruses. TNCO, Inc. accepts no liability for
>any damage caused by any virus transmitted by this email.
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>




More information about the AccessD mailing list