|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
hi,
When a user clicks on a button for a report , there is a macro that is there
- it worked before, not it no longer works. Im totally stuck.
it says on the on-click event for this button: =openreports('logentry")
where "logentry" is a valid name of a report. But, when everyone clicks on
it, I get this obtuse message telling me that something is wrong,the
expression has a function name that ms access doesnt recognise. What's wrong
with it? I really need help on this please !!!!!!!!!!!!
|
|
Im so dumb. i used openform and it works. Is there an openreports function?
"Maggie" wrote:
[Quoted Text] > hi,
> When a user clicks on a button for a report , there is a macro that is there
> - it worked before, not it no longer works. Im totally stuck.
> it says on the on-click event for this button: =openreports('logentry")
> where "logentry" is a valid name of a report. But, when everyone clicks on
> it, I get this obtuse message telling me that something is wrong,the
> expression has a function name that ms access doesnt recognise. What's wrong
> with it? I really need help on this please !!!!!!!!!!!!
>
>
|
|
Maggie,
There may or may not be an openreports() function in your database, I
don't know. There is not such built-in to Access. Nor is there an
openform() function either. If this works, then someone must have built
a user-defined function into your database. There is an OpenForm macro
action, and there is also an OpenReport macro action, and there are
OpenForm and OpenReport methods which can be used in VBA code. But in
none of these would you use the type of approach or syntax which you
showed us. If you go into the design view of your Modules, you might
find it there.
--
Steve Schapel, Microsoft Access MVP
Maggie wrote:
[Quoted Text] > Im so dumb. i used openform and it works. Is there an openreports function?
>
>
> "Maggie" wrote:
>
>> hi,
>> When a user clicks on a button for a report , there is a macro that is there
>> - it worked before, not it no longer works. Im totally stuck.
>> it says on the on-click event for this button: =openreports('logentry")
>> where "logentry" is a valid name of a report. But, when everyone clicks on
>> it, I get this obtuse message telling me that something is wrong,the
>> expression has a function name that ms access doesnt recognise. What's wrong
>> with it? I really need help on this please !!!!!!!!!!!!
>>
>>
|
|
I did take a lot of time trying to find out more about this in the project,
but i never found anything that defined openreports() macro. It's a project
from somebody that I'm modifying, so I am not that good at this yet. I'll
dig around more to see what I can find - thanks for your help.
"Steve Schapel" wrote:
[Quoted Text] > Maggie,
>
> There may or may not be an openreports() function in your database, I
> don't know. There is not such built-in to Access. Nor is there an
> openform() function either. If this works, then someone must have built
> a user-defined function into your database. There is an OpenForm macro
> action, and there is also an OpenReport macro action, and there are
> OpenForm and OpenReport methods which can be used in VBA code. But in
> none of these would you use the type of approach or syntax which you
> showed us. If you go into the design view of your Modules, you might
> find it there.
>
> --
> Steve Schapel, Microsoft Access MVP
>
> Maggie wrote:
> > Im so dumb. i used openform and it works. Is there an openreports function?
> >
> >
> > "Maggie" wrote:
> >
> >> hi,
> >> When a user clicks on a button for a report , there is a macro that is there
> >> - it worked before, not it no longer works. Im totally stuck.
> >> it says on the on-click event for this button: =openreports('logentry")
> >> where "logentry" is a valid name of a report. But, when everyone clicks on
> >> it, I get this obtuse message telling me that something is wrong,the
> >> expression has a function name that ms access doesnt recognise. What's wrong
> >> with it? I really need help on this please !!!!!!!!!!!!
> >>
> >>
>
|
|
|