PC Review


Reply
Thread Tools Rate Thread

DBRW - more options - default - value

 
 
=?Utf-8?B?UnVzc2VsbCBOZXcgemVhbGFuZA==?=
Guest
Posts: n/a
 
      25th Sep 2007
I am using a date field to filter a search. I would like the default start
record to be the current date i.e. today. I can only seem to get a
satisfactory result by putting in a specific date, but then understandably
all refreshes of the result start at that specified date. Leaving the default
blank means all refreshes go back to the first record in the field. How can I
start the results from the current date and maintain the start date after
editing records.
PS I have been able to get the initial submit box to return current date in
the browser. But this does not help with the default upon refreshing the
results.
Solution would be greatly appreciated.
 
Reply With Quote
 
 
 
 
Thomas A. Rowe
Guest
Posts: n/a
 
      26th Sep 2007
Set the initial field value to:

<%=Date()%>

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================


"Russell New zealand" <(E-Mail Removed)> wrote in message
news:C08DCDF6-A6CB-44F8-A12A-(E-Mail Removed)...
>I am using a date field to filter a search. I would like the default start
> record to be the current date i.e. today. I can only seem to get a
> satisfactory result by putting in a specific date, but then understandably
> all refreshes of the result start at that specified date. Leaving the default
> blank means all refreshes go back to the first record in the field. How can I
> start the results from the current date and maintain the start date after
> editing records.
> PS I have been able to get the initial submit box to return current date in
> the browser. But this does not help with the default upon refreshing the
> results.
> Solution would be greatly appreciated.



 
Reply With Quote
 
=?Utf-8?B?UnVzc2VsbCBOZXcgemVhbGFuZA==?=
Guest
Posts: n/a
 
      27th Sep 2007
Thanks for the response but I am looking for the value to set WITHIN the
wizard set up under 'more options ' - 'default ' . (The one with the
attached HTML 'fp_sDefault=' that cannot be overwritten as it always changes
back to its original upon saving)
I want the results page to always default to todays date.

I am not looking for the value to populate the submission box to start the
query.

Appreciate if you can help further. thanks




"Thomas A. Rowe" wrote:

> Set the initial field value to:
>
> <%=Date()%>
>
> --
> ==============================================
> Thomas A. Rowe
> Microsoft MVP - FrontPage
>
> http://www.Ecom-Data.com
> ==============================================
>
>
> "Russell New zealand" <(E-Mail Removed)> wrote in message
> news:C08DCDF6-A6CB-44F8-A12A-(E-Mail Removed)...
> >I am using a date field to filter a search. I would like the default start
> > record to be the current date i.e. today. I can only seem to get a
> > satisfactory result by putting in a specific date, but then understandably
> > all refreshes of the result start at that specified date. Leaving the default
> > blank means all refreshes go back to the first record in the field. How can I
> > start the results from the current date and maintain the start date after
> > editing records.
> > PS I have been able to get the initial submit box to return current date in
> > the browser. But this does not help with the default upon refreshing the
> > results.
> > Solution would be greatly appreciated.

>
>
>

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      27th Sep 2007
You might need to learn to handcode instead of using the FP database components.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================


"Russell New zealand" <(E-Mail Removed)> wrote in message
news:F4849410-5549-476A-921B-(E-Mail Removed)...
> Thanks for the response but I am looking for the value to set WITHIN the
> wizard set up under 'more options ' - 'default ' . (The one with the
> attached HTML 'fp_sDefault=' that cannot be overwritten as it always changes
> back to its original upon saving)
> I want the results page to always default to todays date.
>
> I am not looking for the value to populate the submission box to start the
> query.
>
> Appreciate if you can help further. thanks
>
>
>
>
> "Thomas A. Rowe" wrote:
>
>> Set the initial field value to:
>>
>> <%=Date()%>
>>
>> --
>> ==============================================
>> Thomas A. Rowe
>> Microsoft MVP - FrontPage
>>
>> http://www.Ecom-Data.com
>> ==============================================
>>
>>
>> "Russell New zealand" <(E-Mail Removed)> wrote in message
>> news:C08DCDF6-A6CB-44F8-A12A-(E-Mail Removed)...
>> >I am using a date field to filter a search. I would like the default start
>> > record to be the current date i.e. today. I can only seem to get a
>> > satisfactory result by putting in a specific date, but then understandably
>> > all refreshes of the result start at that specified date. Leaving the default
>> > blank means all refreshes go back to the first record in the field. How can I
>> > start the results from the current date and maintain the start date after
>> > editing records.
>> > PS I have been able to get the initial submit box to return current date in
>> > the browser. But this does not help with the default upon refreshing the
>> > results.
>> > Solution would be greatly appreciated.

>>
>>
>>



 
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
Average value of a DBRW column Mick Microsoft Frontpage 2 5th Sep 2009 08:58 AM
Error DBRW David8 Microsoft Frontpage 1 24th May 2009 09:17 AM
DBRW ScreenTip %20 Appalachia Microsoft Frontpage 9 28th Apr 2008 09:15 AM
What is DBRW as used in Excel cell formula ie =DBRW( =?Utf-8?B?Q2FybG9z?= Microsoft Excel Worksheet Functions 1 4th Jun 2006 11:13 AM
Search Form on DBRW PinkBishop Microsoft Frontpage 1 1st Nov 2003 03:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:05 AM.