Solved

memo field in microsoft access

Posted on 2000-03-23
5
195 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 10 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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
is this a cms? 8 74
Syntax for query to update table 2 43
Hide and Unhide Table 6 27
JQuery DataTable Functionality 8 20
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

726 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