borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2011 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Next Topic (Word Text in an Access Table's field) New Topic New Poll Post Reply
AndreaVB Forum : VBA (Access, Excel, Word, ...) : RS232 data to MS Access database
Poster Message
kosin
Level: Trainee

Registered: 26-01-2009
Posts: 1

icon RS232 data to MS Access database

Dear,

I've a telephone small central (10 users). I have a VB6 MSComm application, which reads data from serial port. I wish that data to transfer directly into MS Access database, 24 hours non-stop. Is it possible to do that? How to manage MS Access and VB6 application to do that without command button, just read data and transfer directly from VB6 to MS Access from telephone central? Thank you for your attention!

26-01-2009 at 05:50 PM
View Profile Send Email to User Show All Posts Visit Homepage | Quote Reply
marizel
Level: Trainee

Registered: 09-02-2010
Posts: 1
icon Re: RS232 data to MS Access database

You'd need to leave the database open and with a certain form displayed, then you could use the Timer event of the form to check for data at some interval.  If you already have a button to check, you can just use the same code.

I'd be interested in hearing more about how you've integrated MSComm--I had been trying to do that, with only limited success.

Mz

09-02-2010 at 04:10 PM
View Profile Send Email to User Show All Posts | Quote Reply
AndreaVB Forum : VBA (Access, Excel, Word, ...) : RS232 data to MS Access database
Next Topic (Word Text in an Access Table's field) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2011 Andrea Tincaniborder