PC Review


Reply
Thread Tools Rate Thread

< Clarity

 
 
Simon Weaver
Guest
Posts: n/a
 
      22nd Feb 2004
Thanks Thomas & Jim,

but I'm not actually linking to Access nor using DRW. I
want to programmatacly place a link in an html table to a
html file which has been generated by the 'Export Query
to HTML' feature of Access. One of the table fields I'm
exporting contains the code of an item I want to display
i.e. AA1, the exported html file is named as this code. I
want users to be able to click the link in the resulting
table and open AA1.htm

Access is exporting the code embedded in an html anchor,
but I can't stop FrontPage from replacing > with &tl;

Do you have an idea?

TIA, Simon
 
Reply With Quote
 
 
 
 
Thomas A. Rowe
Guest
Posts: n/a
 
      22nd Feb 2004
How are you bringing the page into FP after you have exported it from
Access?

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Simon Weaver" <(E-Mail Removed)> wrote in message
news:1460401c3f92d$db3b7fa0$(E-Mail Removed)...
> Thanks Thomas & Jim,
>
> but I'm not actually linking to Access nor using DRW. I
> want to programmatacly place a link in an html table to a
> html file which has been generated by the 'Export Query
> to HTML' feature of Access. One of the table fields I'm
> exporting contains the code of an item I want to display
> i.e. AA1, the exported html file is named as this code. I
> want users to be able to click the link in the resulting
> table and open AA1.htm
>
> Access is exporting the code embedded in an html anchor,
> but I can't stop FrontPage from replacing > with &tl;
>
> Do you have an idea?
>
> TIA, Simon



 
Reply With Quote
 
Simon Weaver
Guest
Posts: n/a
 
      22nd Feb 2004
In FrontPage, using File, Import

The expression in my query is as follows...

Details: "<a href=" & [code] & ">See Details</a>"

When exporting my query as an html file (In Access, File
Export - AA1.htm) then importing AA1.htm into FrontPage
the > is replaced with &lt;

How can I prevent this.

TIA, Simon

PS I use this method in DRW pages with ease, because I
can force columns to display As HTML in the Column
Properties as Jim explained earlier on. But I don't have
this property in an HTML raw table...
>-----Original Message-----
>How are you bringing the page into FP after you have

exported it from
>Access?
>
>--
>
>==============================================
>Thomas A. Rowe (Microsoft MVP - FrontPage)
>WEBMASTER Resources(tm)
>http://www.ycoln-resources.com
>FrontPage Resources, WebCircle,
>MS KB Quick Links, etc.
>==============================================
>To assist you in getting the best answers for FrontPage

support see:
>http://www.net-sites.com/sitebuilder/newsgroups.asp
>
>"Simon Weaver" <(E-Mail Removed)>

wrote in message
>news:1460401c3f92d$db3b7fa0$(E-Mail Removed)...
>> Thanks Thomas & Jim,
>>
>> but I'm not actually linking to Access nor using DRW.

I
>> want to programmatacly place a link in an html table

to a
>> html file which has been generated by the 'Export Query
>> to HTML' feature of Access. One of the table fields

I'm
>> exporting contains the code of an item I want to

display
>> i.e. AA1, the exported html file is named as this

code. I
>> want users to be able to click the link in the

resulting
>> table and open AA1.htm
>>
>> Access is exporting the code embedded in an html

anchor,
>> but I can't stop FrontPage from replacing > with &tl;
>>
>> Do you have an idea?
>>
>> TIA, Simon

>
>
>.
>

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      22nd Feb 2004
Simon,

The problem is that since you are exporting the page from Access, it is not
filling in the URL Values, this is not an FP issue.

The only solution in FP, since you don't want to use the Access database and
the DRW in the web site, is to manually create your hyperlinks.

Without the data source and ASP/VBScript there is no way for the " & [code]
& " to be dynamically replaced on the page when view in a browser.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Simon Weaver" <(E-Mail Removed)> wrote in message
news:1488301c3f93e$5dc4c110$(E-Mail Removed)...
> In FrontPage, using File, Import
>
> The expression in my query is as follows...
>
> Details: "<a href=" & [code] & ">See Details</a>"
>
> When exporting my query as an html file (In Access, File
> Export - AA1.htm) then importing AA1.htm into FrontPage
> the > is replaced with &lt;
>
> How can I prevent this.
>
> TIA, Simon
>
> PS I use this method in DRW pages with ease, because I
> can force columns to display As HTML in the Column
> Properties as Jim explained earlier on. But I don't have
> this property in an HTML raw table...
> >-----Original Message-----
> >How are you bringing the page into FP after you have

> exported it from
> >Access?
> >
> >--
> >
> >==============================================
> >Thomas A. Rowe (Microsoft MVP - FrontPage)
> >WEBMASTER Resources(tm)
> >http://www.ycoln-resources.com
> >FrontPage Resources, WebCircle,
> >MS KB Quick Links, etc.
> >==============================================
> >To assist you in getting the best answers for FrontPage

> support see:
> >http://www.net-sites.com/sitebuilder/newsgroups.asp
> >
> >"Simon Weaver" <(E-Mail Removed)>

> wrote in message
> >news:1460401c3f92d$db3b7fa0$(E-Mail Removed)...
> >> Thanks Thomas & Jim,
> >>
> >> but I'm not actually linking to Access nor using DRW.

> I
> >> want to programmatacly place a link in an html table

> to a
> >> html file which has been generated by the 'Export Query
> >> to HTML' feature of Access. One of the table fields

> I'm
> >> exporting contains the code of an item I want to

> display
> >> i.e. AA1, the exported html file is named as this

> code. I
> >> want users to be able to click the link in the

> resulting
> >> table and open AA1.htm
> >>
> >> Access is exporting the code embedded in an html

> anchor,
> >> but I can't stop FrontPage from replacing > with &tl;
> >>
> >> Do you have an idea?
> >>
> >> TIA, Simon

> >
> >
> >.
> >



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ah clarity! Thanks Ms Q-reeus Microsoft Outlook Installation 0 2nd Apr 2009 07:59 PM
image clarity Hadeel Microsoft Access Forms 1 26th Sep 2008 05:43 AM
Picture Clarity =?Utf-8?B?bW9ua2V5c3Bvbmdl?= Windows XP Photos 5 29th Jun 2006 01:13 AM
Code Clarity John Microsoft Access Form Coding 5 2nd Sep 2003 04:04 PM
Loss of clarity Adrian Watts Windows XP Video 0 30th Jun 2003 10:14 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:15 AM.