onclick don't run macro

[checoturco]

Hello all,

i have a form tha has a button which execute a macro in the onclick.
in some computers this button works and in others no.
we don't receive any error message. we simply press the button and nothing happens.


i already set the macro security to low but the problem persists.

this database is located in a server and users open it from his computers.

thanks all

Checo

 

[Guus2005]

Are you sure nothing happens? What if the macro is executed and you don't see the difference?
Tell us what the macro is supposed to do.

 

[checoturco]

the macro should open one report.

if i put the code in the buttom:

docmd.runMacro "MacroName"

aldo nothing happens.

if i change the code of this button to open directly the form, i receive the error:

the action "Open Report" was canceled..

When a make the debug of the code.
.....
stDocName = "ReportName"
DoCmd.OpenReport stDocName, acNormal <----- from here the code goes to

Err_Command59_Click:
MsgBox Err.Description
Resume Exit_Command59_Click

 

[Guus2005]

Could you use code instead of a macro? It is easier to debug. It is difficult to predict what the macro is doing.

 

[checoturco]

yes, i use the code above in the bottom to see where the code stops.
Now, i'm looking to see what causes this error (the action "Open Report" was canceled..) and trying to understand why the code works in some computers and in others no.

 

[boblarson]

Which version of Access are you using?

 

[DJkarl]

Do you have code in the report itself? If so check if the report code has any errors, if it does it may be causing your problems.

 

[checoturco]

no, the problem is not in the code because in other computers works well.
Maybe the version of access that is installed.
I have the standard version and i will install the professional one.
Then i'll report the result.

Many thanks to all.

 

[boblarson]

no, the problem is not in the code because in other computers works well.
Maybe the version of access that is installed.
I have the standard version and i will install the professional one.
Then i'll report the result.

Many thanks to all.

Again, which version? Not Standard or Professional, but Access 2000, 2002, 2003, or 2007? And are all of the computers running the same version?

 

[Guus2005]

I don't think that installing the professional version would make any difference. Just takes a lot of time. Having done that, you almost certain have a different version than your customer. Like boblarson curious what version. Did you migrate/upgrade recently?

 

[checoturco]

thanks for you answers.


boblarson wrote:
>>Again, which version? Not Standard or Professional, but Access 2000, 2002, 2003, or 2007? And are all of the computers running the same version?

The version is Access 2003.

The problem was not solved with the Professional installation.

 

[checoturco]

and all the computers are running the same version.

 

[Guus2005]

Post your database or a subset showing the problem.

 

[checoturco]

Sorry for the delay,
the problem is with the user.
If we log in in the same machine with other user the application works well.
i'm still trying solve the problem.

tks all,

Checoturco

 

[Guus2005]

So, if you login with a different username in the Access database, the application goes well? When you login with the same username it goes wrong?

If so, don't use usernames in your application. Use some other unique id's.

 

[checoturco]

it's solved, the problem was with the user.

tks all for you help.

Checoturco