Recent content by dmeehanjr

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

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!

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

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

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

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

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

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

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