Lol it certainly has, and its worked the second time around! I must have mis-typed something the first time - no CPU hang, no problems!
Case closed - though why the bl**dy thing didnt work with the update is still beyond me.
Thank you Bob!
Mike.
I've tried that.
It doesnt actually have an on change event. Not that it stopped me trying it, as access 2003 sometimes didn't show all the events associated to a control, so I assumed access 2007 was the same... how wrong was I? it crashed Access completely - CPU hit 90% and it thrashed the...
All of the code elsewhere on that form runs perfectly, all of the properties on other controls all seem to fire perfectly, its just the "update" property of a scrollbar that doesnt seem to work.
Just checked again, the gotfocus and lostfocus properties for the scrollbar both work also, just...
Yes, it's definately nothing to do with security.
The more I play with it, the more I think it might be a bug, it works perfectly in Access 2003 but fails to fire at all in 2007. I've even tried replacing my code with a simple message box to see if there was any part of the code it didn't...
I have developed a form in Access 2003 which uses the MS Forms 2.0 scrollbar control to enter data into a number of fields.
When I run my database under Access 2003 it works perfectly, but when i run it under access 2007, the Update property is not firing at all.
Anyone know if this is a bug...
Ignore my last post, i've found it.
You have browse for it in Tools/References on the VBA menu, then tick it and it works.
Thanks for your help CyberLinx.
Mike.
This may not be ideal, but a solution i have used in the past is to create a temp table containing 4 fields; box1, box2 etc, then do a sql insert command;
docmd.runsql "insert into temp ([box1], [box2], [box3], [box4])" & _
"values ([forms]![myform].txtbox1, [forms]![myform].txtbox2...
Thanks for the suggestion Cyberlink, but it still didnt work..
I had already registered the DLL but i did it again just to be sure - both via the run command itself and at the dos-promt as you suggested. It still doesnt show up in the activeX control list.
Isnt the IDE reference a fox-pro...
Try this;
Left([yourtext],InStr([yourtext],",")-1)
to get the first half, and
Mid([text],InStr([text],",")+2,10)
to get the back half
the "+2" assumes there is a space after the comma and the "10" is the max length of the field.
Hi all
Long time reader, first time poster ;-)
I've been struggling with a piece of code for Access for a few days and am totally stuck.
I have a piece of code (thank you utteraccess.com) that opens the dialog box up for a PnP scanner I have connected to this PC; the code is;
'---
Dim...