database results memo field

[Stephen Green]

I've created a small table in Access, just a date and memo field for a
comment.

I also created a database results page that shows the most recent comment
(sorted by date).

This is working. However, the memo field comes out as one contiguous
paragraph even though several returns were entered into it. Is there a way
to get the memo field to reflect these paragraphs? Is this a characteristic
controlled by Access?

Thanks for your help.

Stephen

 

[Kathleen Anderson [MVP - FrontPage]]

http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Line Breaks

 

[Stephen Green]

Thanks Kathleen!

I found your page directly after posting my question and have been working
with it since then.

Thanks so much for posting such useful information for all of us non
programmers!

Stephen

 

[Kathleen Anderson [MVP - FrontPage]]

You're welcome - actually, the page I pointed you to belongs to another
FrontPage MVP - Stephen C. Travis.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

 

[Stephen Green]

Kathleen!

Do you have any ideas about the following (from a more recent post):

I've been looking at MS KB article 318281 on querying two table in the same
database in FP 2002.

What I acutally need to do is query db1 for ProjectName, but carry the
associate ProjectID over to the results page where the results will be based
on db2.projectID=db1ProjectID (or the variable carried over form the drop
down). I've been slogging away trying to do it on, with no success.

Can anyone suggest the answer?

Thanks.

Stephen

 

[Kathleen Anderson [MVP - FrontPage]]

Hi Stephen:
I saw that post, but hesitated to answer because I've never done queries
from two tables. However, if you take a look at the following article, you
may be able to combine it with the other one:
HOW TO: Filter a Database Query by Using a Drop-Down List in FrontPage 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q235554&GSSNB=1

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

Kathleen!

Do you have any ideas about the following (from a more recent post):

I've been looking at MS KB article 318281 on querying two table in
the same database in FP 2002.

What I acutally need to do is query db1 for ProjectName, but carry the
associate ProjectID over to the results page where the results will
be based on db2.projectID=db1ProjectID (or the variable carried over
form the drop down). I've been slogging away trying to do it on,
with no success.

Can anyone suggest the answer?

Thanks.

Stephen

You're welcome - actually, the page I pointed you to belongs to
another FrontPage MVP - Stephen C. Travis.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

Thanks Kathleen!

I found your page directly after posting my question and have been
working with it since then.

Thanks so much for posting such useful information for all of us non
programmers!

Stephen

"Kathleen Anderson [MVP - FrontPage]" <[email protected]>
wrote in message http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Line Breaks

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


I've created a small table in Access, just a date and memo field
for a comment.

I also created a database results page that shows the most recent
comment (sorted by date).

This is working. However, the memo field comes out as one
contiguous paragraph even though several returns were entered into
it. Is there a way to get the memo field to reflect these
paragraphs? Is this a characteristic controlled by Access?

Thanks for your help.

Stephen

 

[Stephen Green]

Once again, thanks. That article at leat takes me one step closer to where
I need to be.

Stephen

Hi Stephen:
I saw that post, but hesitated to answer because I've never done queries
from two tables. However, if you take a look at the following article, you
may be able to combine it with the other one:
HOW TO: Filter a Database Query by Using a Drop-Down List in FrontPage 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q235554&GSSNB=1

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

Kathleen!

Do you have any ideas about the following (from a more recent post):

I've been looking at MS KB article 318281 on querying two table in
the same database in FP 2002.

What I acutally need to do is query db1 for ProjectName, but carry the
associate ProjectID over to the results page where the results will
be based on db2.projectID=db1ProjectID (or the variable carried over
form the drop down). I've been slogging away trying to do it on,
with no success.

Can anyone suggest the answer?

Thanks.

Stephen

You're welcome - actually, the page I pointed you to belongs to
another FrontPage MVP - Stephen C. Travis.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


Thanks Kathleen!

I found your page directly after posting my question and have been
working with it since then.

Thanks so much for posting such useful information for all of us non
programmers!

Stephen

"Kathleen Anderson [MVP - FrontPage]" <[email protected]>
wrote in message http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Line Breaks

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


I've created a small table in Access, just a date and memo field
for a comment.

I also created a database results page that shows the most recent
comment (sorted by date).

This is working. However, the memo field comes out as one
contiguous paragraph even though several returns were entered into
it. Is there a way to get the memo field to reflect these
paragraphs? Is this a characteristic controlled by Access?

Thanks for your help.

Stephen

 

[Thomas A. Rowe]

Use the following format to display the memo field content on your page:

<%=Replace(fp_rs("MemoFieldName"), vbcrlf, "<br>")%>

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Once again, thanks. That article at leat takes me one step closer to where
I need to be.

Stephen

Hi Stephen:
I saw that post, but hesitated to answer because I've never done queries
from two tables. However, if you take a look at the following article, you
may be able to combine it with the other one:
HOW TO: Filter a Database Query by Using a Drop-Down List in FrontPage 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q235554&GSSNB=1

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

Kathleen!

Do you have any ideas about the following (from a more recent post):

I've been looking at MS KB article 318281 on querying two table in
the same database in FP 2002.

What I acutally need to do is query db1 for ProjectName, but carry the
associate ProjectID over to the results page where the results will
be based on db2.projectID=db1ProjectID (or the variable carried over
form the drop down). I've been slogging away trying to do it on,
with no success.

Can anyone suggest the answer?

Thanks.

Stephen


in message You're welcome - actually, the page I pointed you to belongs to
another FrontPage MVP - Stephen C. Travis.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


Thanks Kathleen!

I found your page directly after posting my question and have been
working with it since then.

Thanks so much for posting such useful information for all of us non
programmers!

Stephen

"Kathleen Anderson [MVP - FrontPage]" <[email protected]>
wrote in message http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Line Breaks

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


I've created a small table in Access, just a date and memo field
for a comment.

I also created a database results page that shows the most recent
comment (sorted by date).

This is working. However, the memo field comes out as one
contiguous paragraph even though several returns were entered into
it. Is there a way to get the memo field to reflect these
paragraphs? Is this a characteristic controlled by Access?

Thanks for your help.

Stephen