Hi

When creating a form to be able to update it automatically puts the arrows
at the bottom but they seem to be the wrong way around ie you have to press
> to go back one and < to go forward one.

Can anyone one work out in the script what I have to change to make it more
logical so that the person presses < to go back and > to go forward.

<!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"

b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc"

i-groupsize="1" clientside tag="BODY"

local_preview="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot;
align=&quot;center&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;End of
Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD
ALIGN=LEFT VALIGN=MIDDLE&gt;&lt;FORM&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button
VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt;
&quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt; &quot;&gt;&lt;INPUT
TYPE=Button VALUE=&quot; &gt;| &quot;&gt;
[1/1]&lt;/NOBR&gt;&lt;/FORM&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"

preview="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD ALIGN=LEFT
VALIGN=MIDDLE&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button VALUE=&quot; |&lt;
&quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt; &quot;&gt;&lt;INPUT
TYPE=Button VALUE=&quot; &gt; &quot;&gt;&lt;INPUT TYPE=Button
VALUE=&quot; &gt;| &quot;&gt;
[1/1]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" --><!--#in
clude file="../../../_fpclass/fpdbrgn2.inc"-->

<!--webbot bot="DatabaseRegionEnd" endspan i-CheckSum="9297" -->



Any help would be great thanks Shona.

That shouldn't be happening - is this live on the web where we can see it?

--

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



SS <(E-Mail Removed)> wrote:
> Hi
>
> When creating a form to be able to update it automatically puts the
> arrows at the bottom but they seem to be the wrong way around ie you
> have to press
>> to go back one and < to go forward one.
>
> Can anyone one work out in the script what I have to change to make
> it more logical so that the person presses < to go back and > to go
> forward.
>
> <!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"
>
> b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc"
>
> i-groupsize="1" clientside tag="BODY"
>
> local_preview="&lt;table border=0
> width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot;
> align=&quot;center&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;End
> of Database Results
> region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD ALIGN=LEFT
> VALIGN=MIDDLE&gt;&lt;FORM&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button
> VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot;
> &lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;
> &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;| &quot;&gt;
> [1/1]&lt;/NOBR&gt;&lt;/FORM&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"
>
> preview="&lt;table border=0
> width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
> bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;&gt;&lt;font
> color=&quot;#000000&quot;&gt;This is the end of a Database Results
> region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD ALIGN=LEFT
> VALIGN=MIDDLE&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button VALUE=&quot;
> |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt;
> &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;
> &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;| &quot;&gt;
> [1/1]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"
> --><!--#in clude file="../../../_fpclass/fpdbrgn2.inc"-->
>
> <!--webbot bot="DatabaseRegionEnd" endspan i-CheckSum="9297" -->
>
>
>
> Any help would be great thanks Shona.

No I'm afraid it isn't it's on an Intranet site

"Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in
message news:%(E-Mail Removed)...
> That shouldn't be happening - is this live on the web where we can see it?
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
>
>

When you say backwards it is relative to the way your DB is sorted and called (if sorted in reverse order)
- the button are scrolling thru the records in the sequence in your DB or any sort applied in the DBRW
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"SS" <(E-Mail Removed)> wrote in message news:d73sut$4e3$(E-Mail Removed)...
| No I'm afraid it isn't it's on an Intranet site
|
| "Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in
| message news:%(E-Mail Removed)...
| > That shouldn't be happening - is this live on the web where we can see it?
| >
| > --
| >
| > ~ Kathleen Anderson
| > Microsoft MVP - FrontPage
| > Spider Web Woman Designs
| > web: http://www.spiderwebwoman.com/resources/
| >
| >
|
|

Ah thanks

Don't suppose you know how I could change the buttons though so it looks OK
to the person using them? Still wanted it sorted highest number first.

Cheers Shona
"Stefan B Rusynko" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When you say backwards it is relative to the way your DB is sorted and
called (if sorted in reverse order)
> - the button are scrolling thru the records in the sequence in your DB or
any sort applied in the DBRW
> --
>
> >
>

If you add the proper sort criteria to the query the buttons will look OK to
the user.

--

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



SS <(E-Mail Removed)> wrote:
> Ah thanks
>
> Don't suppose you know how I could change the buttons though so it
> looks OK to the person using them? Still wanted it sorted highest
> number first.
>
> Cheers Shona
> "Stefan B Rusynko" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> When you say backwards it is relative to the way your DB is sorted
>> and
> called (if sorted in reverse order)
>> - the button are scrolling thru the records in the sequence in your
>> DB or any sort applied in the DBRW --

OK thanks as I want highest number first as hopefully that is the one that
the persons needs to update most of the time then Idon't think it can be
done unless it can be done in the custom query somehow which is

Update DISTINCTROW results
SET
Approve='::Approve::',Reject='::Reject::',Approve1='::Approve1::',Reject1=':
:Reject1::',
Approve2='::Approve2::',Reject2='::Reject2::',Approve3='::Approve3::',Reject
3='::Reject3::',
Approve4='::Approve4::',Reject4='::Reject4::',Approve5='::Approve5::',Reject
5='::Reject5::',
Approve6='::Approve6::',Reject6='::Reject6::',Comments='::Comments::',Commen
ts1='::Comments1::',
Comments2='::Comments2::',Comments3='::Comments3::',Comments4='::Comments4::
',Comments5='::Comments5::',
Comments6='::Comments6::'
WHERE ID=::ID::




"Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in
message news:e0Tci$(E-Mail Removed)...
>

Shona -
The buttons are defined in the
&lt;INPUT TYPE=Button VALUE=&quot; |&lt; &quot;&gt;
statements buried in the stuff FP produced.
In straight HTML this would look like
<INPUT TYPE=Button Value="<">
to change the arrow to point the other way, the statement
would be
&lt;INPUT TYPE=Button VALUE=&quot; |&gt; &quot;&gt;

&lt; = < &gt; = >
I have no idea if you can edit web-bot code directly. I suspect not. Sort is a
display idea. The database doesn't care, and is only sorted if data is entered
sorted. I didn't see an "order by" clause in your query, but I don't use the DRW
and don't know how it works.

Hope this is of some help....
MikeR

SS wrote:
> Hi
>
> When creating a form to be able to update it automatically puts the arrows
> at the bottom but they seem to be the wrong way around ie you have to press
>
>>to go back one and < to go forward one.
>
>
> Can anyone one work out in the script what I have to change to make it more
> logical so that the person presses < to go back and > to go forward.
>
> <!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"
>
> b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc"
>
> i-groupsize="1" clientside tag="BODY"
>
> local_preview="&lt;table border=0
> width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot;
> align=&quot;center&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;End of
> Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD
> ALIGN=LEFT VALIGN=MIDDLE&gt;&lt;FORM&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button
> VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt;
> &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt; &quot;&gt;&lt;INPUT
> TYPE=Button VALUE=&quot; &gt;| &quot;&gt;
> [1/1]&lt;/NOBR&gt;&lt;/FORM&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"
>
> preview="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
> bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;&gt;&lt;font
> color=&quot;#000000&quot;&gt;This is the end of a Database Results
> region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD ALIGN=LEFT
> VALIGN=MIDDLE&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button VALUE=&quot; |&lt;
> &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt; &quot;&gt;&lt;INPUT
> TYPE=Button VALUE=&quot; &gt; &quot;&gt;&lt;INPUT TYPE=Button
> VALUE=&quot; &gt;| &quot;&gt;
> [1/1]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" --><!--#in
> clude file="../../../_fpclass/fpdbrgn2.inc"-->
>
> <!--webbot bot="DatabaseRegionEnd" endspan i-CheckSum="9297" -->
>
>
>
> Any help would be great thanks Shona.
>
>

Thanks for that unfortunately it doesn't change looks like I will just have
to live with it!

Thanks Again