Command Button not working in accde file (1 Viewer)

gsandy

Registered User.
Local time
Today, 13:44
Joined
May 4, 2014
Messages
104
I have created an accdb file and saved as an accde file. The accde file opens with a form with command buttons. But the commands buttons do not work with the accde file (they do work with the accdb file). How do I get them working. Thanks Sandy.
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 02:44
Joined
Sep 12, 2006
Messages
15,652
what does it say when it does not work? what error do you get?
 

CJ_London

Super Moderator
Staff member
Local time
Today, 02:44
Joined
Feb 19, 2013
Messages
16,607
Have you enabled the db? without doing this the code won't run. You wouldn't necessarily see this prompt if the opening form is popup and/or the access window is hidden
 

gsandy

Registered User.
Local time
Today, 13:44
Joined
May 4, 2014
Messages
104
I don't get any messages, it just does not work.
How do I enable the accde file?
 

CJ_London

Super Moderator
Staff member
Local time
Today, 02:44
Joined
Feb 19, 2013
Messages
16,607
How do I enable the accde file?
you need to click on the enable content button
 

Attachments

  • Capture.JPG
    Capture.JPG
    32.3 KB · Views: 1,284

gsandy

Registered User.
Local time
Today, 13:44
Joined
May 4, 2014
Messages
104
I never get that message.
I went into File/Options/Trust Center/Macro Settings and set "Enable all macros". They still don't work.
I went into File/Options/Trust Center/Active X Settings and set "Enable all controls". They still don't work. I am using Access 2013.
 

CJ_London

Super Moderator
Staff member
Local time
Today, 02:44
Joined
Feb 19, 2013
Messages
16,607
Ah, sorry, not familiar with 2013, I guess it doesn't have the enable button since you haven't mentioned it
 

gsandy

Registered User.
Local time
Today, 13:44
Joined
May 4, 2014
Messages
104
Thanks CJ.
Hopefully someone else can help! Probably something simple. Cheers Sandy.
 

cccjwh

New member
Local time
Yesterday, 18:44
Joined
Jan 18, 2018
Messages
1
I went back into the accdb form, created a new button that executed the same code, complied, saved as accde. Both the buttons works for some unknown reason...
 

rth@trinitylabs.org

New member
Local time
Yesterday, 15:44
Joined
Dec 18, 2018
Messages
10
I had the same issue. From an internet search found there is a bug where the buttons on a form loose link to their vba code. At least that is how I understood it. In any event its intermittent. Here is the way to "fix" it until it happens again the next time ...

Opened the addcb file, compiled the vba code, then recreated the addce file. It might fix it the first time or the second or ... you get the idea; test it, repeat until it resolves itself. Annoying ... but what you gonna do?

Good luck.
 

Users who are viewing this thread

Top Bottom