Selasa, 24 Mei 2011

RE: [MS_AccessPros] Subform return error

 

Jonathan-

Yo hablo Español tambien.

If you're working in a Spanish version of Access, then "nombre" is probably also
a reserved word.

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:34 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Subform return error

John,

Thanks for the input. You always there to help me out, that is great. You have
no idea how much I apreciate that.

The field is not named "Name", I simply placed it that way for you instead of
"Nombre" (spanish) so you had a better idea of what I was talkign about in case
you do not know spanish.

I will try and apply that formula you gave me and see what happens, be right
back...

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

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar