Search results

Datestamp In the afterupdate event of the box you're updated put textboxname = Date() HTH

Check that you're not opening the form in add mode - this will give you a blank form every time. HTH

Try putting it in the after update event of the field on the subform. HTH

Well I've got the same problem intermittently on one particular PC and numlock key makes no difference. Any ideas?

Russell, This problem occurs after implementing a security patch on Outlook and needs intervention on the Exchange server (search microsoft knowledge base for details) HTH Mary

Email button works fine on other machines, but not mine. Will only send mail once without closing access and starting again. Can't see any difference between outlook or access settings between PC's. Any suggestions? Thanks!

Lost the bracket, that's not the problem, I DO have it in the code me.[dist]

No, not getting an error message at all. Code is just DoCmd.SendObject , , , Me.Dist], , , "Subject", "Messagebody", no

Thanks for all the help. Finally got back to this today! Another problem! Click list box - names go to distribution box, click button - mails sent, that's fine. Do it again on same record to test - still workign. BUT if I go to a new record, it doesn't send. I have to shut down access...

Thanks guys. I'm now kicking myself (though I haven't had a chance to actually try it yet!) Can't see any reason for this not to work. I had been putting each entry into a new record on a sub form. The only advantage was that I had a tick box that was true when the mail was sent, so a new...

And modest too! No, that's not exactly what I want either. Main form contains RecordID Number, with five tabbed pages containing subforms. One of the subforms is a distribution record. I have an unbound listbox with all the company email addresses and clicking on an address puts it in the...

I can't find anything to match exactly what I want to do and don't have the knowledge to adapt any code that I found. I didn't make it quite clear. I don't want to send any object, but I want to notify just the people on the distribution list for each particular record. The database keeps...

Ok, I'm on the right track thanks to Talismanic's code. BUT not quite there. Database consists of fairly detailed records split across tab pages. One page holds the list of all those who need to be notified about the particular record. I'm doing this by using an unbound list of all email...

Thanks David

Hi, From a list box I select email address of people to receive a short email. What I want is to have a command button that will send each person an email. So email person 1, email person 2 etc. until end of the list. My coding skills are very basic and I've never used a loop before so go...