Code not working (1 Viewer)

[Kundan]

When I make an accde file the VBA code doesn't work. why? How to solve the problem?

 

[theDBguy]

Can you post both the accdb and accde files for inspection?

 

[Kundan]

Attaching both files.

 

[zeroaccess]

Try this. Compiled in Access 2019 32-bit.

 

[Kundan]

I have Windows 10 64bit. Your 32bit DB is not opening.

 

[isladogs]

The Windows bitness is irrelevant. However a 32-bit ACCDE cannot be used in 64-bit Access (or vice versa)

Here's another version done in A365 64-bit

 

[Kundan]

Code not working in accde. When I enter the REMARKS field the popup window does not open.

 

[isladogs]

It would have helped if you had said which code didn't work in the First place.
The problem was that you had left an empty event procedure in the Remarks_GotFocus event.
I've removed that and recompiled the ACCDE. AFAIK. it now works correctly

NEVER leave empty event procedures when compiling to ACCDE.

 

[zeroaccess]

Weird, because it worked for me.

 

[isladogs]

Empty event procedures lead to unpredictable results In ACCDE files
Sometimes it prevents the code being compiled as an ACCDE.
At other times, it compiles but prevents code for that control working as Kundan observed and also happened for me using 64-bit.
Perhaps 64-bit is more 'picky' than 32-bit??? Who knows?

 

[Kundan]

Thanks, GOD BLESS YOU!!!!!