473,803 Members | 2,279 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem on Reading Ms-Access Memo Field using VB6.0

31 New Member
hi all,

i am creating a VB6.0 application with Ms-Access database. While reading a memo field of my Ms-Access database, the recordset shows some invalid bad charecters like

"(1of 2) Deemed automatically extended unless Tenant notifies Landlord at least 12 months prior their intention to vacate. Landlord must deliver by certified or registered mail an Automatic Renewal Notice at least fifteen (15) and not more than (30) days p IOc??????? ?C 1000 SC??x h Ó? ?? ?? OĞ???$? GiNC RID ?dA??ldA? zC ??????
ZC???a   ††††??????????? ??????????????? ???D??
UC I"

Can any one help me to take the exact data from the database?

my code is:

rsOriginalOptio ns.Open strQry, conOriginal, 1, 3
While Not rsOriginalOptio ns.EOF
strOne = Trim(CStr(rsOri ginal("OCCPNAME 1").Value))
strTwo = Trim(CStr(rsOri ginalOptions("B LDGID1").Value) )
strThree = Trim(CStr(rsOri ginalOptions("L EASID1").Value) )
strFour = "2"
strFive = rsOriginalOptio ns("OPTNTYPE1") .Value
strSix = Trim(CStr(rsOri ginalOptions(in tField).Value)) 'OLDVALUE
strSeven = Trim(CStr(rsNew (intField).Valu e)) 'NEWVALUE
rsOriginalOptio ns.MoveNext
Wend

dhana.
Oct 15 '08 #1
2 3293
9815402440
180 New Member
hi
remove trim()

regards
manpreet singh dhillon hoshiarpur
Oct 16 '08 #2
debasisdas
8,127 Recognized Expert Expert
what does that memo field contains ?
Oct 16 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
3465
by: Programatix | last post by:
Hi, I'm trying to apply Strong Name to my project and I get the following error while building the project, Building satellite assemblies... Satellite build for culture 'ms-MY' failed. Please see the output window for more detailed error information. ALINK: error AL1044: Error reading key file '..\SSM.snk' -- The system cannot find the file specified.
1
2583
by: Magnus Lycka | last post by:
I'm trying to read standard out in a process started with popen2 in a non-blocking way. (Other good ways of doing this than the one I tried are appreciated.) I've tried to dumb down my code to see what happens, and socket.poll seems to behave very strangely. I've tried to use the .poll method for the poll object with and without a timeout, but in either case, the output randomly switches between on of the versions below. It runs fast,...
6
2972
by: Jason Chu | last post by:
situation: I'm uploading file to my application using a java applet sending the request (the file) through socket to my asp.net page. On my asp.net page, I've override the httpmodule to take in the request and saves the file to disk (on the server). My .net side works if I use a simple html file input and post it, I've read in the uploaded request (multipart form), and reproduced it in the java applet. Everything works fine when I upload...
7
2287
by: BluDog | last post by:
Hi I am trying to store an image in an xml file, i vcan store it fine but the retreval is a bit of a problem: To String: Dim ms As New IO.MemoryStream Dim arrImage() As Byte Me.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg)
1
1580
by: David | last post by:
Hi, This one appears a little strange to me. Here is the scenario. I load a datalist the first time a page is run. The page has a !IsPostback and the datalist gets loaded at this point. I have a button on the page, where I want to read the contents of the datalist. As an example that I have found on MS...
12
3342
by: O.B. | last post by:
I'm trying to do a static_cast at runtime in C# and as I understand it, "as" is the keyword to use. Unfortunately, the compiler is trying to do the cast a compilation time. See below. /* TestA.cs */ namespace TEST { class TestA { public ushort val1; public ushort val2; public ushort val3;
15
4150
by: =?ISO-8859-1?Q?J=F8rn?= Dahl-Stamnes | last post by:
Hello folks, I need some help/advice FAST. I have problems with addslashes on my web-servers. After uploading a file, I read the uploaded file, use addslashes on the read data and then insert it into a blob field in a MySQL database. The problem is that this works fine on my internal test web-server (running under RedHat 7.3). But on my production web-server (running Fedora Core 4)
5
4640
by: sascha.folville | last post by:
Hi, I've some trouble reading the containing frames of a multiframe tiff. First frame is a 1700X2400 px CCITT4, second in JPG 820x1200, third is a CCITT again ... and so on. My function extracts the CCITT-frames correct, but the second, fourth, etc. frames causes a general GDI+ error. Hope someone can help!
2
2271
by: Author | last post by:
I am exploring the DeflateStream class as a practice. I thought it is fun to compress a text file and write it to a disk file. So I created the following method. If you don't bother reading the small code snippet, here is a summary of what I did: 1. Read the text content into a buffer through FileStream.Read. 2. Create a DeflateStream by wrapping up a MemoryStream. 3. Write the compressed data into the underline stream (the...
1
2445
navanova
by: navanova | last post by:
Greetings, I have a problem of opening ms word and excel files on my computer. The files are there for a long time. I use to open and modify them. Suddenly, when i try to open the word files, a dialog box appears that says "There was an error opening the file". when i try to open the excel files, a dialog box appears that says "File format not valid". I have tried to create a new word and excel files, save them and when i try to open these...
0
9562
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10542
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10309
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10289
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10068
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5496
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5625
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4274
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2968
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.