slimplynth
Senior Member
Hello all
I've been looking for a way to control a Picaxe using Access 2007 forms. (because they are quick an easy to create)
Think it's half way there now.. anyway as my projects have a tendency to fall foul of never getting completed before the next one starts
thought someone else may see a use for it.
Got the serial port comms code/module from here:
http://www.thescarms.com/vbasic/commio.aspx
The Axe027 had to be configured as COM 2 (the VBA module only supports COM 1 - 4)
Attached is a first attempt at getting a form to display a button to control an LED connected to C.5 of a 20X2 and indicate it's status (It's a bit shoddy tbh - but then as I said, it's unfinished and a first try.)
There's an occasional error when the serial port is already open, because the Form's 'On Timer' event updates a text box control to indicate the status of the LED (reported by the picaxe) the button sends data and the text box is waiting for data from the Picaxe... the two clash... need to find a way to use the GotFocus (Hover) event of the button to suspend the OnTimer event running.. anyhoo.. attached code and blah blah blah.. happy halloween
Link to my revolutionary islimplynth webpage, which took years to agree on the final design:
http://www.stanleyluk.webspace.virginmedia.com/
Adios
I've been looking for a way to control a Picaxe using Access 2007 forms. (because they are quick an easy to create)
Think it's half way there now.. anyway as my projects have a tendency to fall foul of never getting completed before the next one starts
thought someone else may see a use for it.Got the serial port comms code/module from here:
http://www.thescarms.com/vbasic/commio.aspx
The Axe027 had to be configured as COM 2 (the VBA module only supports COM 1 - 4)
Attached is a first attempt at getting a form to display a button to control an LED connected to C.5 of a 20X2 and indicate it's status (It's a bit shoddy tbh - but then as I said, it's unfinished and a first try.)
There's an occasional error when the serial port is already open, because the Form's 'On Timer' event updates a text box control to indicate the status of the LED (reported by the picaxe) the button sends data and the text box is waiting for data from the Picaxe... the two clash... need to find a way to use the GotFocus (Hover) event of the button to suspend the OnTimer event running.. anyhoo.. attached code and blah blah blah.. happy halloween
Link to my revolutionary islimplynth webpage, which took years to agree on the final design:
http://www.stanleyluk.webspace.virginmedia.com/
Adios