Hi there
you're on the right path but I think your syntax needs tweaking ...
Me.Dirty = False
RetValue = MsgBox("Print Lab Sheet for this Batch?", vbOKCancel)
If RetValue = vbOK Then
DoCmd.OpenReport "lab_sheet", acViewPreview
End If
good luck
dbase -> Access
hi there
first - wow - I'm surprised ANYONE still uses dbase!!!
I used to write a lot of scripts in good ol' dBase - but I'm talking late '80's.
The flavour I used to use was dbXL - which was like dbase on steroids but still required reams of code to achieve - well, not very...
use the tag property
hi there
use the tag property - as a previous poster suggested.
loop through all controls on form, check each tag property, call appropriate routine
s'easy ...
vba training
don't know about Chicago - but in London I was lucky enough to find www.clearpresence.co.uk and received superb advanced and tailored vba training.
I know of no existing function but going through the entire string character by character validating ascii characters by value is def the way to go.
good luck
Hi
still not quite sure why you need to do this but ...
1. convert number to a string and use VBA to reverse it one char at a time
2. carry out calcs as required
good luck
Hi there
Access is good at quite a few things - but if you need to change object names - you are on your own.
This is because Access lacks some of the requisites of a true Object Oriented environment - Inheritance, polymorphism etc.
I believe there are third party tools that can help with...
yeah I've tried it ...
seems you enter Peter,. (note the comma and the full stop) and keep typing anthing and it displays:
Peter, please answer the following question:
mr moe - it's no biggie - just capture the onkeypress event and insert each char in a string.
good luck