Search results

  1. D

    Search outlook exchange for email address

    I'm trying to see if can search outlook exchange from access vba to get email address (using windows user name) / Anyone with experience doing? Thanks! Don
  2. D

    validate mixed text/number string

    I need to validate an 8 charactor field that it contains: two letters, five numbers, one letter (in that order) How could I best do that? Thanks!
  3. D

    data validation - parsing table with errors..

    Will be importing from excel, residing in access table now. thanks, Don
  4. D

    data validation - parsing table with errors..

    i'm working on a process where I will import data into a temp table, and then want to validate some of the data before proceding 'live' with it to apply updates. I'd like to be able to write bad rows to separate table, with up to 2 error messages. The remaining (good) rows would be in a...
  5. D

    import text - combine lines..

    Greets! I have a text file that for some reason was formatted as follows(for example): FirstName LastName John Smith Bob Dole Jay Jones DOB Address 5/12/91 12 smith ave 6/10/10 40 union pike 3/1/00 18 hun st...
  6. D

    post last update field after Confirming Save

    think i got it! had afterupdate doing it also..thanks for your help and eyes!
  7. D

    post last update field after Confirming Save

    thanks - I had tried, but that seems to trigger the beforeUpdate event again, and get the msgbox again.
  8. D

    post last update field after Confirming Save

    I have a "Confirm Save' msgbox in beforeupdate event of a form. I also need to value the 'lastUpdated' field on form with Now(), but loops me back into confirming Save. How/where can i value the update date without looping into beforeUpdate event? (I tried valuing lastUpdate in afterupdate...
  9. D

    Question check "Include headers" export spec, not saving..

    I have an export spec, and I can't get the 'Include Headers' checkbox to stick. When I save after setting, it becomes unchecked when i re-open the spec. I tried creating new one also, still same.. Don access 2003 sp3
Back
Top Bottom