UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> Error: 3420: Object Invalid Or No Longer Set, Access 2010    
 
   
Alhakeem1977
post Jun 17 2019, 05:35 PM
Post#21



Posts: 115
Joined: 8-July 17



Wow, you are so expert and clever, thank you so much it works perfectly. pompom.gif

The code has a letter l missing in: If Not oMail Is Nothing Then

I will not forget your help and it will add a lot to my project.

Thanks again I hope one day I could do something for you, at least I will pray for you. wavehi.gif
This post has been edited by Alhakeem1977: Jun 17 2019, 05:41 PM

--------------------
Best Regards,

Al Hakeem1977
Go to the top of the page
 
cheekybuddha
post Jun 18 2019, 06:00 AM
Post#22


UtterAccess VIP
Posts: 11,423
Joined: 6-December 03
From: Telegraph Hill


yw.gif

I'm glad it's working for you.

Well done for spotting the mistake in the variable name (oMail => olMail)!

You can easily find such errors by making sure every code module has Option Explicit declared at the top (as well as Option Compare Database).

To ensure this happens automatically when you create a new module see here in the UA wiki

Then, when you make any code change, go to the 'Debug' menu in the VBA editor and choose 'Compile'. It will highlight errors like this one.

hth,

d

--------------------


Regards,

David Marten
Go to the top of the page
 
2 Pages V < 1 2


Custom Search


RSSSearch   Top   Lo-Fi    21st July 2019 - 08:10 AM