Email function stopping

[eholtman]

Attached is a sample of test database in the form you will notice that I want to notify when Request is Recevied. The email format will work for the first one. Go to the next line item and select recieved request and nothing happens same happens for when I cancel the email.

I have been working on this for about 2 weeks. And simply stuck at this point otherwise I would have been done.

Please take a look at my VB and see if there is something wrong.. Thanks

 

[pbaldy]

It seems to work as expected for me. Since you have code to test for the checkbox being true, it sometimes requires 2 clicks to get the email (1 to uncheck the box, another to check it again).

 

[eholtman]

What....

pbaldy.. Thanks for the response. But I dont see how that is possible..

1.)Did you select one item under Recieved Request
2.)the outlook box appear to send a email...
3.)Cancel or send doesnt matter ...
4.)Try to select another box below to generate another email

and that is where it dies....

I have several people try this application and the same thing happens..

 

[pbaldy]

Yes. Just did it again, here are the results. At this point when the form opened all 4 records are already checked.

I click on first item. Box unchecks and date disappears.
I click again; box checks, date fills in, email pops up
I cancel email and get your message box

I click on second item. Box unchecks and date disappears.
I click again; box checks, date fills in, email pops up
I cancel email and get your message box

I can do that all day long, any item, no errors.

I decided to try it differently. Closed the form, opened the table, unchecked all received request checkboxes. Opened form.

Clicked on first item, email opens. Cancelled the email, got your message box.
Clicked on second, email opens. Cancelled the email, got your message box.

and so on. As I said, working as I would expect. For the record, OS = XP Pro, A2k, both current.

 

[eholtman]

Thanks again for the testing.

The heads starts to crash into my desk harder and harder. It does not make sense.

No matter what it dies after the first email....

 

[pbaldy]

Sorry I couldn't sort it out. I'd look for a pattern between when it works and when it doesn't. Access version, OS, whatever. I don't see anything in the code that should cause a problem. By the way, as it may be relevant, my Outlook is also 2000, SP3.

 

[RoyVidar]

I haven't looked at the code, but the symptoms seems to indicate the SendObject method is used. There's a recognized flaw in it. If this is the case, check out
http://support.microsoft.com/default.aspx?scid=kb;en-us;260819
there's a workaround code involving CDO in the link.

 

[eholtman]

Thank you ...

I found out at work they are using Office SP1. You are right it works great at home.

If I build this on Office 2000 SP3 or 2003 and save the program. If the users use 2000 SP1 to run the form will it work.

Thanks

RoyVidar - Thanks that article is what I was looking forward. Nothing like losing 2 weeks righting the same code over and over and that not be the issue.

 

[modest]

i dont think that will work, i think vba is interpreted and not compiled. you'd need a setup that would work at your office.