In access I have some notes or memo in the field, how do I
make it appear in my msgpage.asp?

I made a page msgpage.asp, my page contain 1 textbox(multiline)…
What I want to happen is that the content of my MS access will appear in the textbox…..

Can anyone point me to the right direction or where can I find a step by step tutorial about this please…. Thanks in advance.... <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

create a recordset i.e. rsNotes
SELECT memNotes
FROM tblNotes
WHERE NotesID = 1 (or whatever record you wish to show.)

Once you have the recordset, then in your bindings tab you'll see the recordset.
and the memNotes field, drag it and drop it on your textarea or using the tunderbolt bind the field to your text area.

Good luck.

thanks man.... got it..... thanks for ur time.... <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>




<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
create a recordset i.e. rsNotes
SELECT memNotes
FROM tblNotes
WHERE NotesID = 1 (or whatever record you wish to show.)

Once you have the recordset, then in your bindings tab you'll see the recordset.
and the memNotes field, drag it and drop it on your textarea or using the tunderbolt bind the field to your text area.

Good luck.


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>