Join them; it only takes a minute: Sign up Type mismatch error while reading lotus notes document in vb6 up vote 0 down vote favorite Am trying to read the lotus You should use getItemValue as everyone else is suggesting, and also you should check to see if the NotesItem exists. Join & Ask a Question Need Help in Real-Time? Let's start with the procedure itself where the error occurs? Source
The issue should be a data type incompatibility. When you use "" for a null value, you are saying compare to a string null. And the reason, once again, is that Notes and Domino are schema-less. Your value is actually a null number.
All contents Copyright 1998-2016 by MrExcel Consulting. So check the below code... Is that line 67 in the Programmers Pane in Notes?
Share Share this post on Digg Del.icio.us Technorati Twitter Colin RAD Excel Blog Reply With Quote Apr 20th, 2010,12:10 PM #3 afridi New Member Join Date Apr 2010 Posts 26 Re: Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We When I looked at the code, one variable has decimals and the other does not, so it does not think they match. lsaddress = ImsField(doc.address) What is the datatype of lsaddress?
Exchange Advertise Here 794 members asked questions and received personalized solutions in the past 7 days. RE: Error 13: Type Mismatch and @Er... (Natalie Schleut... 8.Aug.03) . . . . . . . . Copyright © 2004 - VBA Express ERROR The requested URL could not be retrieved The following error was encountered while trying to retrieve the URL: http://0.0.0.10/ Connection to 0.0.0.10 failed. Generated Thu, 20 Oct 2016 07:37:34 GMT by s_wx1206 (squid/3.5.20)
In one case, an email was found in the rules folder and the script validating the mail rules could not process the mail message because it was a Memo, not a If you generate a string from a date using Format and one of the system formatting strings (like "General Date" or "Long Date"), then Cdat will create the date properly at Get 1:1 Help Now Advertise Here Enjoyed your answer? If we need other bits of code we can always ask for them later...
Below is some code for three months. http://stackoverflow.com/questions/16663659/type-mismatch-error-while-reading-lotus-notes-document-in-vb6 How do you grow in a skill when you're the company lead in that area? Reply With Quote 10-16-2012,01:21 PM #7 snowdyce View Profile View Forum Posts View Blog Entries View Articles VBAX Regular Joined Oct 2012 Posts 35 Location Thank you for the advice. Create new registration Member Tools RSS Feeds RSS feeds All forum posts RSSAll main topics RSSMore Lotus RSS feeds Resources Resources Forum use and etiquette Native Notes Access Web site Feedback
shall i send the excel? Symptom "Error in CompactMailRules function 13: Type mismatch" Cause The (Rules) design element in a mail database is a folder, not a view. because the error update is done after i click ok on the pop up message "Run Time Error" u can then have a proper look at it. have a peek here more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed
Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. The code itself is working correctly but the Variables are storing the wrong number format. If so it appears to be the following line of code: If doc.getitemvalue("C" & Cstr(i)) = "" Then Any ideas?
Actually I am very new to VBA so its v hard for me to debug errors. Why does Luke ignore Yoda's advice? Eg:- dim x as String Dim z as variant z= Split("Test:XXX",":") x=z The above will through the error what you mentioned. Suggested Solutions Title # Comments Views Activity Lotus Domino - Recovery Manager: Log File is Full 7 2,051 770d Lotus Domino 9 web server 6 66 337d IBM Domino web server
Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Apr 20th, 2010,04:08 PM #6 Colin Legg MrExcel MVPLike totally RAD man Join Date Feb 2008 Location UK Posts How is the ATC language structured? Just another remark: instead of the chr(13) call you can - use Chr$(13): this is a string, whereas Chr(13) returns a Variant which needs a conversion - use rtitem.AddNewline(1): this is Check This Out That will occur when you attempt to reference a NotesItem that does not exist.