Hello,

I'm trying to make a checkbox checked on a report depending on the existance
of a file in a directory. Its in the report_current event. So far no luck.
Not sure I have the syntax right.

me.checkboxname = true

I took out the condition to see if the file existed, just to test if I could
even set the checkbox to checked. Doesn't work. Could it be

me!checkboxname = true

or

me.checkboxname = -1?

What happens when you tried those?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"attrib75" <(E-Mail Removed)> wrote in message
news:FE07231A-C3FB-44DC-9E92-(E-Mail Removed)...
> Hello,
>
> I'm trying to make a checkbox checked on a report depending on the
> existance
> of a file in a directory. Its in the report_current event. So far no
> luck.
> Not sure I have the syntax right.
>
> me.checkboxname = true
>
> I took out the condition to see if the file existed, just to test if I
> could
> even set the checkbox to checked. Doesn't work. Could it be
>
> me!checkboxname = true
>
> or
>
> me.checkboxname = -1?
>
>
>

Reports are static representations of data. You can't directly modify
data on a report, you have to change the data in the underlying
table or query.

Also, reports do not have a Current event. Did you mean to say that
you are working with a form?

--
_________

Sean Bailey


"attrib75" wrote:

> Hello,
>
> I'm trying to make a checkbox checked on a report depending on the existance
> of a file in a directory. Its in the report_current event. So far no luck.
> Not sure I have the syntax right.
>
> me.checkboxname = true
>
> I took out the condition to see if the file existed, just to test if I could
> even set the checkbox to checked. Doesn't work. Could it be
>
> me!checkboxname = true
>
> or
>
> me.checkboxname = -1?
>
>
>

Thanks,

No I'm trying to do it in a report. I was getting the feeling you couldn't
modify anything in a report. Trouble is I don't know how in the report, to
check a file system for the existance of a .jpg. If its there, check the
box. I was trying to do:

if \\filepath\name.jpg = name.jpg then

me.checkbox.value = true

in vba on the current_record event but you cant modify reports that way I
guess. How do you get a current list of files in a folder into a table so
that the report can check it?

"Beetle" wrote:

> Reports are static representations of data. You can't directly modify
> data on a report, you have to change the data in the underlying
> table or query.
>
> Also, reports do not have a Current event. Did you mean to say that
> you are working with a form?
>
> --
> _________
>
> Sean Bailey
>
>
> "attrib75" wrote:
>
> > Hello,
> >
> > I'm trying to make a checkbox checked on a report depending on the existance
> > of a file in a directory. Its in the report_current event. So far no luck.
> > Not sure I have the syntax right.
> >
> > me.checkboxname = true
> >
> > I took out the condition to see if the file existed, just to test if I could
> > even set the checkbox to checked. Doesn't work. Could it be
> >
> > me!checkboxname = true
> >
> > or
> >
> > me.checkboxname = -1?
> >
> >
> >

Nothing changes, and the report populates as usual.