John c
Last Activity: Oct 2 '09, 07:45 AM
Joined: Aug 25 '09
Location:
-
Thanks FishVal, that seems to be the right direction although it can be a bit iffy. -
Is it always a single line address before the town? And is it always ctrl-enter?Leave a comment:
-
Hi MJVM
I've been successful using the following:
I’m assuming your region is selected from a combo, thus:
Select the region and then let the Region AfterUdate do the work.
Private Sub RegionCombo_Aft erUpdate()
Me!NetworkCombo .RowSource=”SEL ECT [tblNetworks].[Network] FROM tblNetworks WHERE tblNetworks.Reg ion=Me!RegionCo mbo.Column(1);”
If not then...Leave a comment:
-
Can I stop running code by user input ?
I have looping code in Access which generates Excel spreadsheets and prints them off. They can run to hundreds and at present, once the code starts to run there is no way it can stop cleanly part way through. For instance, if the wrong printer has been selected. (I know that Ctrl-Break should slam it but doesn't always and anyway that's not too user friendly). So is there any way a user input can work ?
No activity results to display
Leave a comment: