Recent content by deBassMan

  1. deBassMan

    Opening a Report

    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
  2. deBassMan

    Converting

    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...
  3. deBassMan

    Enabling Multiple Fields on a form

    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 ...
  4. deBassMan

    Training in VBA

    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.
  5. deBassMan

    Client/Server Architecture

    IMHO - the best solution is MySQL on the be good luck
  6. deBassMan

    Dynamic textfields and a combobox

    hi how about checking if textbox 1 exists? good luck
  7. deBassMan

    Password Criteria Validation

    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
  8. deBassMan

    Export Structure?

    Hi there what db are you using on your web server?
  9. deBassMan

    Split A Value and then perfom Test

    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
  10. deBassMan

    Split A Value and then perfom Test

    Hi there may I ask why you wish to do this??
  11. deBassMan

    ORDER BY not working

    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?
  12. deBassMan

    Change Qry/Tbl Name Tool

    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...
  13. deBassMan

    Peter Answers website

    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
  14. deBassMan

    Regular Expression reference?

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

    Regular Expression reference?

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