none
One user reports buttons on a form not working RRS feed

  • Question

  • This is a multi-user database. Every user has their own copy of the front-end.

    Several users are using the database successfully. One user reports they can open the database and display the main menu.

    However, none of the buttons on the form do anything and no error message. User says it worked till last Thursday and Friday stopped working, so I suspect some system/network update did something.

    Have checked they have permissions to the folder.

    I checked the code for the buttons and it just does DoCmd.Openform "Formname"

    I have an On Error trap that should display a message, but user reports no message.

    I'm stuck at this point. Have no idea what to do next.

    Anyone got any ideas how to debug this further?.

    The user is not technical and I do not have access to their PC.


    Tuesday, June 4, 2019 5:47 PM

Answers

  • Sounds like the Macro settings need to be changed or the database file is not in a trusted location.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Tuesday, June 4, 2019 7:40 PM

All replies

  • Sounds like the Macro settings need to be changed or the database file is not in a trusted location.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Tuesday, June 4, 2019 7:40 PM
  • Thanks for the suggestion. I will check what the user's settings are.
    Wednesday, June 5, 2019 5:39 PM
  • Thanks for your answer.

    Resetting the macro option did the trick.

    It's strange that I've not had to have any other user do that.

    Also, shouldn't the user have received some type of error notification if the macro setting did not allow MS Access to continue? And that's the first question I asked her, but she denied there was any message.

    Wednesday, June 5, 2019 9:24 PM
  • Thanks for your answer.

    Resetting the macro option did the trick.

    It's strange that I've not had to have any other user do that.

    Also, shouldn't the user have received some type of error notification if the macro setting did not allow MS Access to continue? And that's the first question I asked her, but she denied there was any message.

    Notice? Not necessarily. One of the macro options is to block code and NOT give a warning. Why that is an option is a mystery to me. When MS started all this "trusted location" stuff everyone got caught up in its evil web. Just like the Outlook warning that a program is trying to send an email and the user has to acknowledge it.

    I finally got my desktop techs to select the lowest macro setting when they install Office on any new machines. That made my life so much easier.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals


    Thursday, June 6, 2019 1:26 PM