David - Glad to hear you have it working. You have a great day, too!
Bill
--- In MS_Access_Professionals@yahoogroups.com, "David Tolson" <drtolson@...> wrote:
>
> Thank you Bill, that is exactly what it is. At least I'm not flying blind
> now J.
>
>
>
> Have a great evening and an even greater day tomorrow.
>
>
>
> Sincerely,
>
>
>
> David
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
> Sent: Thursday, October 27, 2011 4:28 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: RE: [MS_AccessPros] Why does Access not recognize subreport with
> the "rpt" prefix
>
>
>
>
>
> David
>
> Check the name of the sub report *control* on the main report. This might
> not be
> the same as the actual sub report. The control name is the one you have to
> use.
>
> Regards,
>
> Bill
>
> From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of
> djsdaddy531
> Sent: Thursday, October 27, 2011 1:13 PM
> To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: [MS_AccessPros] Why does Access not recognize subreport with the
> "rpt"
> prefix
>
> When I open a report, there is a routine that checks for a certain
> condition. If
> the condition is met, then the Visible Property of one of two of my
> subreports
> will be set to "True;" however, if the condition is not met, the Visible
> Property will be set to "False." I kept getting an error that Access could
> not
> find the field name "[a straight vertical line]". It was a straight verticle
> line in the error message between two quotes. Here is the code:
>
> If Me.OpenArgs = "RepairOrder" Then
> [rptParts-RepairOrder subreport].Visible = True
> Else
> [rptParts-RepairOrder subreport].Visible = False
> End If
>
> The field name is spelled correctly, but when I went to the expression
> builder
> to see if the form was there, and discovered it was spelled with the "frm"
> prefix. Notwithstanding that the report has an "rpt" prefix, I changed the
> code
> (above) to the "frm" prefix and the code works. I do not want to have any
> false
> sense of security here, so I'd like to know if anyone can explain this to
> me.
>
> Thanks in advance.
>
> r/David
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar