We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Only 49 characters please..

Nelmarcas
Nelmarcas asked
on
Medium Priority
142 Views
Last Modified: 2011-09-20
Hello there...

I had a great time reading data from a serial port and then placing it into an Access table.  However the data that comes across from the MSComm1.Input is sometimes to long.  Is there anyway to allow only 49 characters in at a time? AND THEN CLEAR THE BUFFER?
Here is what my code looks like:

Private Sub Receive_Click()

Dim Db As Database
Dim rs As Variant

   
Text1.Text = MSComm1.Input
    'Open Database
Set Db = Workspaces(0).OpenDatabase("C:\Program Files\Microsoft Visual Basic\serial")
    'Open table
Set rs = Db.OpenRecordset("tbl_main", dbOpenDynaset)
   
rs.AddNew
rs("fld_String") = Text1.Text
rs.Update                             ' Save changes.
rs.Move 0, rs.LastModified            ' Go to new record
rs.Close                              ' Close Table.
Db.Close                              ' Close Database

End Sub
Comment
Watch Question

Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thank you very much, I figured it out too late.  Thanks for the help..


Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.