Bear with me - I'm not much chop as a code cutter.
I've worked my way through Nick's db plugin more than once - but I'm not getting it.
Currently I'm running all my VBscripting out of the send box of my triggers and alias' ... because it's quicker for me to debug and because I've never actually written anything large enough to need subs and functions and the like. (How embarassing <g>).
This is probably why I'm having so much trouble following Nick's code which is written more professionally.
Now it's time for me to start talking to an Access db that I've set up, and I'm going round and round in circles.
I'm assuming that it's possible for me to handle all the interaction with the db from send boxes. Much less efficient I'm sure - but at this point I'm not too fussed. Can someone confirm or deny this please?
Assuming it IS possible - could someone please help me with a code chunk? Something generic for an alias which will run an sql query to check the existance of a record perhaps? Or anything which will help me get my head around the actual steps needed to send some sql to the db.
Anyone? Please? <g>
I've worked my way through Nick's db plugin more than once - but I'm not getting it.
Currently I'm running all my VBscripting out of the send box of my triggers and alias' ... because it's quicker for me to debug and because I've never actually written anything large enough to need subs and functions and the like. (How embarassing <g>).
This is probably why I'm having so much trouble following Nick's code which is written more professionally.
Now it's time for me to start talking to an Access db that I've set up, and I'm going round and round in circles.
I'm assuming that it's possible for me to handle all the interaction with the db from send boxes. Much less efficient I'm sure - but at this point I'm not too fussed. Can someone confirm or deny this please?
Assuming it IS possible - could someone please help me with a code chunk? Something generic for an alias which will run an sql query to check the existance of a record perhaps? Or anything which will help me get my head around the actual steps needed to send some sql to the db.
Anyone? Please? <g>