In my job I want instant access to my *shared* outloook calendar (and that uses the *existing* outlook window). It seems simple but messing with the command-line switches wasn't getting me anywhere...but after lots of tweaking I finally came up with the wacko syntax that made outlook do it...
Excellent points, RoyVidar. One of my dirty little secrets is not knowing the difference between .text and .value for textboxes. Sounds like .text is real-time contents and .value is after last update (due to lostfocus, etc)...?
A tweak to make it even better(faster execution and less typing): use the Nz() function to handle the "Null" problem. I love using Nz.
Change: If Trim(Me!NName & "") = "" Then Cancel = True
To: If Nz(Me!NName,"")="" then Cancel = True
Nz will return "" if Nname is Null
Aaron
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.