help with external inputs!!

[minxka]

Hi,

I am trying to creat a DB that can potentially recieve input from a serial port which has a unique ID on it and updates the corresponding feild within the DB. I don't need to demonstrate full functionality (although if I have time I might give it a go!).

What I want to show is that the DB can accept a unique ID from this external source. The ID will just be to identify a user and a peice of equipment, potentially the feilds in the table would be updated with information like, time of session, duration, speed. I am assuming I may need to use VB to do some programming and create an incoming event. Just wondering what the most logical solution is. I want to bring up an interface when an input is recieved, like a user interface or pop up which says eg. "Hello Jim". Then it is possible to demonstrate that they have been detected.

Any help would be hugely appreciated!

Thanks,

Minxka

 

[allan57]

check out the MSCOMM control

 

[minxka]

Hi,

know how to use the mscomm control within vb to get the input from the serial port. I am wondering how I can synchronise this in access. I have only ever put in basic tables and queries in access. I have never had to incorporate pogramming as well. How can I set it up to accept the input from mscomm and then bring up a form?

Cheers
Minxka

 

[MStCyr]

I've used this before and works quite well:

Open "Com1,9600,n,8,1" for output as #1
Print #1,"This is a test"
Close #1

 

[minxka]

hey, thats great thanks, but am honestly a novice on the Access coding bit! if I have a table with userID as the primary key, and the input is a userID where can I program this in? I am assuming I have to create this in 'modules' and then somehow add this into the table or on the form?

Sorry if I am running of the wrong track!

Cheers
Minxka

 

[MStCyr]

I would just put this code in the form - that's what I did the last time. Read the incoming data then dump it into your table, I normally let the data capture run for 10 min. then add it to the table, then reset the data capture file