Event in ACCDE

[Khushalay]

The other day I had a query and JHD told me about OnNoData event that worked as I wanted it to be.

Now, it works in normal db but when I convert it to accde, it doesn't perform what it is supposed to do.

How to overcome this now?

thanking you in advance

 

[bob fitz]

it doesn't perform what it is supposed to do.

What exactly does it do, or are you saying that the code doesn't run at all.

 

[Khushalay]

oh ya it doesn't work at all.

 

[JHB]

It should work.
Attached is an sample database.

 

[Khushalay]

I tried to compile an repair and deleted the accde and make it a couple of times. It didnt work.

I googled it as well, many others have complained that their vba code doesn't function well in accde.

 

[JHB]

Did you try the attached database?
Could you post your database with some sample data + name of the problem report.

 

[Khushalay]

I cannot open the attached as I dont hv Zip... lemme try to send mine

 

[Khushalay]

Cannot upload, it gives some security msg

 

[Khushalay]

I was googling and there are too many others like me. Scrolling through the posts, I got quite a few solutions.

Just go to the vba mode and compile the program and then publish it to accde. It will work fine.

I have access 2016.

Posting it for the benefit of others who might encounter the same issue in future.