John,
Thank you, that worked great!
Jonathan
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Jonathan-
>
> =IIf([Expire Date] - Date() > 0, [Expire Date] - Date(), "Expired")
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of jrv2110
> Sent: Wednesday, May 25, 2011 5:58 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Subform return error
>
> John,
>
> Thanks for the help. It is now working fine. You guys are great! ¡Muchas
> Gracias!
>
> But now I have another question:
> What is the simplest way to on a form get a unbound text box to tell me date
> diference between a date that I placed in a bound text box (date format) and
> todays date? I am puting a client's membership in the bound textbox and I want
> the unbound text box next to it to automaticaly tell me how much days the
> membership still has and once it has expired, to tell me it has expired.
>
> I know it might seem simple for you guys because you're experts at this, but I
> am self taught with just a few books to learn from and trial and error. So I am
> always learning and sometimes I miss simple things and block out and need help
> from the big guys...
>
> Thanks.
>
> Jonathan
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Jonathan-
> >
> > You *might* be able to do it in the Control Source of a text box on the outer
> > form:
> >
> > =IIf([Report].[sub report control name].Report.RecordSet.RecordCount = 0,
> > "Name:_________", "")
> >
> > Enter the name of the subreport control in place of "sub report control name".
> >
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of jrv2110
> > Sent: Tuesday, May 24, 2011 10:39 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: Re: [MS_AccessPros] Subform return error
> >
> > John,
> >
> > I might have done something wrong but it did not work.
> >
> > Let me explain it again.
> >
> > I am working in a report. The report has the client's information. It has the
> > client's emails in a subreport. I want to be able to have a custom label apear
> > on the main report outside the subreport when there is nothing in the
> subreport
> > for the emails. There is nothing in the subreport, it has no records to show
> (no
> > emails in it). What formula could I use to activate a label so that the client
> > knows that I am requesting an email from him on the report given he has not
> > provided one? If he had provided one then nothing will happen because the
> > subreport for the email will show the email.
> >
> > Jonathan
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> > >
> > > Dear jrv2110 (name?)-
> > >
> > > That might be because the field contains a zero-length string. Try this:
> > >
> > > IIf(Len([Name] & "") = 0, "Name:____________", "")
> > >
> > > By the way, Name is a reserved word in Access. You should not give any
> field
> > > that name.
> > >
> > > John Viescas, author
> > > Microsoft Office Access 2010 Inside Out
> > > Microsoft Office Access 2007 Inside Out
> > > Building Microsoft Access Applications
> > > Microsoft Office Access 2003 Inside Out
> > > SQL Queries for Mere Mortals
> > > http://www.viescas.com/
> > > (Paris, France)
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of jrv2110
> > > Sent: Tuesday, May 24, 2011 10:04 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] Subform return error
> > >
> > > I have a subreport that has a client's email address(es). I want a formula
> > that
> > > will return in the a text box in the main report a note saying the
> following:
> > > "Please provide your email:_______________"
> > >
> > > I am using a formula in the main report with data on that main report (not
> on
> > a
> > > subform) and it is working great:
> > > =IIf([NAME] Is Null,"Name:_____________","")
> > >
> > > The name of the subreport is: Report.SUBRPT CORREO ELECTRONICO
> > > The name of the field within the subreport is: CORREO ELECTRONICO
> > >
> > > "Is null" is not working because when the Email subreport has nothing in it,
> > > there is nothing that happens with the formula.
> > >
> > >
> > > Thanks in advance for any advice.
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar