[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

memo field in microsoft access

Posted on 2000-03-23
5
Medium Priority
?
199 Views
Last Modified: 2012-06-27
when i retrieve data from the memo field, it doesn't show the linebreak .. the sentences are join together. How can i retrieve the details with linebreaks?

i have a column with type date/time and the format is short time. how do i issue an insert statement?

e.g. temp= '12:00'
sql = "insert into table ('" & temp & "')"

the above sql gave me an error.
0
Comment
Question by:irene79
  • 3
5 Comments
 

Expert Comment

by:crysys
ID: 2652415
The memo field is correct but think that when you retrieve it the newline character (vbcrlf) has no meaning in a HTML context. You should search for each vbcrlf and replace then with a <br>

The correct sentence for insert is:

sql="insert into table (datecolum) (#" & temp & "#)

Regards
0
 
LVL 25

Accepted Solution

by:
clockwatcher earned 40 total points
ID: 2652433
1.

myMemo = rs("memofield")
myMemo = replace(myMemo, chr(13), "<BR>")
response.write myMemo

2.

sql = "insert into table (fieldname) values ('" & temp & "')"

or

sql = "insert into table (fieldname) values (#" & temp & "#)"
0
 

Expert Comment

by:crysys
ID: 2652491
You're right clockwatch. I forgot the 'values'.

Regards
0
 

Expert Comment

by:crysys
ID: 2652494
crysys changed the proposed answer to a comment
0
 

Author Comment

by:irene79
ID: 2659452
Thanks clockwatcher!!
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
There is a wide range of advantages associated with the use of ASP.NET. This is why this programming framework is used to create excellent enterprise-class websites, technologies, and web applications.
Is your organization moving toward a cloud and mobile-first environment? In this transition, your IT department will encounter many challenges, such as navigating how to: Deploy new applications and services to a growing team Accommodate employee…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question