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 > > >