Recent content by deBassMan

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.

IMHO - the best solution is MySQL on the be good luck

hi how about checking if textbox 1 exists? good luck

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 there what db are you using on your web server?

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 may I ask why you wish to do this??

Hi there as your code stands right now it does not appear to make sense ... in what order do you wish your data to be presented?

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

Yeah - I tried that Didn't get the movement I was after ...

Hi there try referencing: VBScript Regular Expressions x.x works for me!