John07

I have a problem, And need advise as where to start.

I have a visual basic program on computer A
Microsoft access on computer B

On computer B there is a textbox always in focus, that logs data when a value is entered and the enter key is press.

So far very simple.

Now, I need computer A to beable to send keys to that textbox on computer B.

Can anyone point me in the right direction. I was using DDE on a single computer but It turns out these applications MUST be seperated to two computers.

Any input would be much appreciated.

Rory

There are numerous ways of communicating between machines, including NetDDE.

However I'd say the best and simplest way to achieve what you want would be to use basic TCP/IP. You can do this in VB by using the built in Winsock control or the API. Specifically you would need to run a server program on the computer with the database that would use DDE to enter the data as you are currently doing, and a remote client that would send keystrokes to the server program over the network connection.

Do a quick google for "VB Winsock Control" or search on PlanetSourceCode

John07

Thanks for the feedback.

I was looking up the winsock control, and it seems I need a vb application on both PCs. Is this true?

I was hoping not to modifiy Computer B in anyway.

If I have no choice though, Thats fine.


Thanks again.

Rory

Yes you will. However you could write computer B's part into the Access database using VBA and the winsock control :-)