Share via

ACCESS 2010 - ACCDE buttons on first form displayed do not work, but ACCDB works fine - VB code has been compiled,

Anonymous
2012-09-18T17:20:00+00:00

Hello,

I'm having problems and inconsistencies creating an ACCDE app from a ACCDB in access 2010.

Here are the steps so far. Please advise.

Converted a .mdb DB to an ACCDB - tested functions. All worked fine.

Created a ACCDE - the buttons on the first form displayed  do not work. App was created in the same folder as the working ACCDB. Checked all security to confirm.

Returned to the ACCDB and compiled the VB code. Then recreated the ACCDE - worked fine.

Made minor change to the ACCDB and retested - worked fine.

Recompiled the ACCDB VB code and recreated the ACCDE. The ACCDE first form stopped working again. I can, however, retrieve the forms it calls if I click on them individually in the Navigation Pane as opposed to using the related button on the main form.

This happened on three other applications. I finally got them to work but going in and out of the ACCDB several times and recreating the ACCDE. Not sure why or how they started working or why they didn't work in the first place.

I don't see a security problem here  -

Please help. Very frustrated.

Thanks.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-09-18T17:49:17+00:00

    Found a solution on my own, but it seems a bit funky. Here is what I did. Would like advice about a better way. 

    Opened the ACCDB

    Opened the form that was not working. Went to design mode and retrieved the VB code behind the first button.

    Recompiled the VB code.

    Recreated the ACCDE.

    I didn't make any changes to this form at any time. It's a mystery to me why it worked after the first ACCDE was created and failed when I recreated it.

    Thanks.

    Was this answer helpful?

    10 people found this answer helpful.
    0 comments
  2. Anonymous
    2013-05-27T05:52:21+00:00

    Found a solution on my own, but it seems a bit funky. Here is what I did. Would like advice about a better way. 

    Opened the ACCDB

    Opened the form that was not working. Went to design mode and retrieved the VB code behind the first button.

    Recompiled the VB code.

    Recreated the ACCDE.

    I didn't make any changes to this form at any time. It's a mystery to me why it worked after the first ACCDE was created and failed when I recreated it.

    Thanks.

    Thanks for sharing this.  I had the same problems, with none of the buttons on any of the forms working.  I did what you suggested, and it worked.  For the sake of other people with this issue, I will go into more detail.

    I went to the first form that opens up according to my autoexec

    Went to the visual basic window, and highlighted the "CLICK" code for the main button

    I cut the code, including the Sub header and end of sub.

    I saved the form and closed it.

    I reopened the form, went to visual basic code for it, pasted the code back in, and saved and closed the form again.

    Then I went back to visual basic and compiled.

    the new accde worked like a charm.

    Thanks!!!

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments
  3. Anonymous
    2013-05-28T15:01:08+00:00

    As I said, I've seen this happen in development. Something must be tearing the code page a bit. Cut & paste usually isn't necessary. Just selecting the control and clicking the builder button to open the procedure should fix the link.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2012-09-19T04:29:56+00:00

    Thanks Bill,

    I tried that on another DB I had a problem with and it didn't solve the problem - but there were other issues with it at the time.

    If I run into this problem again I'll give it a try. Right now, all of them are working fine.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2012-09-18T18:39:56+00:00

    Forms sometimes lose the "link" between a control and it's procedure. What you did re-established the link. Usually, you only have to do that once.

    If you continue to have this issue it would be wise to import everythng into a new ACCDB to fix whatever corruption has creeped into the current file.

    Was this answer helpful?

    0 comments