 |
28-Jul-2006, 08:12 AM
|  | Guest | | | | | | | | | | RE: Default Value Date minus days
In the ControlSource of the field in the subform you can write
=DateAdd("d",-90,Forms![MainFormName]![DateFieldName])
--
Good Luck
BS"D Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10347Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10347
"lmv" wrote:
> I have a date box on a main form
> frmproject.datebox
>
> I have a subform with an unbound box
> that I want the calculated date to be the date in the datebox on the main
> form minus 90 days.
>
> I have tried =[datebox] -90
> But that doesn't work as all of you who know how to do this will say of
> course that won't work
> So, can someone tell me what will work?
> Thanks!!
>
> |
28-Jul-2006, 08:12 AM
| | Guest | | | | | | | | | | RE: Default Value Date minus days
This might you part way there --
=[Forms]![frmproject]![DateBox]
BUT if you change the data in [DateBox] your subform data will not Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10347
automatically change. You will need to add either an Event or Macro to
refresh the box when the data in the DateBox is changed.
"lmv" wrote:
> I have a date box on a main form
> frmproject.datebox
>
> I have a subform with an unbound box
> that I want the calculated date to be the date in the datebox on the main
> form minus 90 days.
>
> I have tried =[datebox] -90
> But that doesn't work as all of you who know how to do this will say of
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10347
> course that won't work
> So, can someone tell me what will work?
> Thanks!!
>
> |
28-Jul-2006, 08:12 AM
| | Guest | | | | | | | | | | RE: Default Value Date minus days
Thank you for the response...
I don't get an Error or #Name? BUT no data is displayed. Do I need to set
something else since it is potentially a date before today's date? I have
tried doing a date into next year but it still doesn't return a value. Format
is set to short date.
Thanks!
lmv
"Ofer Cohen" wrote: Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10347
> In the ControlSource of the field in the subform you can write
> =DateAdd("d",-90,Forms![MainFormName]![DateFieldName])
>
> --
> Good Luck
> BS"D
>
>
> "lmv" wrote:
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10347
> > I have a date box on a main form
> > frmproject.datebox
> >
> > I have a subform with an unbound box
> > that I want the calculated date to be the date in the datebox on the main
> > form minus 90 days.
> >
> > I have tried =[datebox] -90
> > But that doesn't work as all of you who know how to do this will say of
> > course that won't work
> > So, can someone tell me what will work?
> > Thanks!!
> >
> >  |
28-Jul-2006, 08:12 AM
| | Guest | | | | | | | | | | RE: Default Value Date minus days
Where did you placed this DateAdd, is it in the field default or control
source?
--
Good Luck
BS"D
"lmv" wrote:
> Thank you for the response...
>
> I don't get an Error or #Name? BUT no data is displayed. Do I need to set
> something else since it is potentially a date before today's date? I have
> tried doing a date into next year but it still doesn't return a value. Format
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10347
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10347
> is set to short date.
>
> Thanks!
> lmv
>
> "Ofer Cohen" wrote:
>
> > In the ControlSource of the field in the subform you can write
> > =DateAdd("d",-90,Forms![MainFormName]![DateFieldName])
> >
> > --
> > Good Luck
> > BS"D
> >
> >
> > "lmv" wrote:
> >
> > > I have a date box on a main form
> > > frmproject.datebox
> > >
> > > I have a subform with an unbound box
> > > that I want the calculated date to be the date in the datebox on the main
> > > form minus 90 days.
> > >
> > > I have tried =[datebox] -90
> > > But that doesn't work as all of you who know how to do this will say of
> > > course that won't work
> > > So, can someone tell me what will work?
> > > Thanks!!
> > >
> > > |
28-Jul-2006, 08:12 AM
| | Guest | | | | | | | | | | RE: Default Value Date minus days
default...
"Ofer Cohen" wrote:
> Where did you placed this DateAdd, is it in the field default or control
> source?
>
> --
> Good Luck
> BS"D
>
>
> "lmv" wrote:
>
> > Thank you for the response...
> >
> > I don't get an Error or #Name? BUT no data is displayed. Do I need to set
> > something else since it is potentially a date before today's date? I have
> > tried doing a date into next year but it still doesn't return a value. Format
> > is set to short date.
> >
> > Thanks!
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10347
> > lmv
> >
> > "Ofer Cohen" wrote:
> >
> > > In the ControlSource of the field in the subform you can write
> > > =DateAdd("d",-90,Forms![MainFormName]![DateFieldName])
> > >
> > > --
> > > Good Luck
> > > BS"D
> > >
> > >
> > > "lmv" wrote:
> > >
> > > > I have a date box on a main form
> > > > frmproject.datebox
> > > >
> > > > I have a subform with an unbound box
> > > > that I want the calculated date to be the date in the datebox on the main
> > > > form minus 90 days.
> > > >
> > > > I have tried =[datebox] -90
> > > > But that doesn't work as all of you who know how to do this will say of
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10347
> > > > course that won't work
> > > > So, can someone tell me what will work?
> > > > Thanks!!
> > > >
> > > > |
28-Jul-2006, 08:12 AM
| | Guest | | | | | | | | | | RE: Default Value Date minus days
gotcha! it's fixed now!! Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10347
Thanks
"Ofer Cohen" wrote:
> Where did you placed this DateAdd, is it in the field default or control
> source?
>
> --
> Good Luck
> BS"D
>
>
> "lmv" wrote:
>
> > Thank you for the response...
> >
> > I don't get an Error or #Name? BUT no data is displayed. Do I need to set
> > something else since it is potentially a date before today's date? I have
> > tried doing a date into next year but it still doesn't return a value. Format
> > is set to short date.
> >
> > Thanks!
> > lmv
> >
> > "Ofer Cohen" wrote:
> >
> > > In the ControlSource of the field in the subform you can write
> > > =DateAdd("d",-90,Forms![MainFormName]![DateFieldName])
> > >
> > > --
> > > Good Luck
> > > BS"D
> > >
> > >
> > > "lmv" wrote:
> > >
> > > > I have a date box on a main form
> > > > frmproject.datebox
> > > >
> > > > I have a subform with an unbound box
> > > > that I want the calculated date to be the date in the datebox on the main
> > > > form minus 90 days.
> > > >
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10347
> > > > I have tried =[datebox] -90
> > > > But that doesn't work as all of you who know how to do this will say of
> > > > course that won't work
> > > > So, can someone tell me what will work?
> > > > Thanks!!
> > > >
> > > > | 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! |
 (View-All)
Members who have read this thread : 0
| | There are no names to display. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes |  Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On
| | | |  | » Active Discussions | | | | | | | | | | | | | | | | | | | | | Panjabi Today 02:14 AM 9 Replies, 201 Views | | | | | | | | | | » Books You Should Read... | | | |
