there is one more condition I need to set, due for review is another column which is showing "True" or "False"
In this command where I can this condition
Dear Experts,
Can someone please guide me how to generate the report based on the selection from the drop-down. For illustration purpose, I have added the sample database:
So I have data that lists down the process names for multiple countries, and I want to generate a report based on the...
But unfortunately there is no macro that’s why I am trying to understand from where it is generating this error
Plus trust center is enabled for any type of macro
Dear expert,
When I click on the generated reported and wanted to convert it into excel, I am getting an error. Please see screenshot
Appreciate your guidance
Dear Arnelgp,
it worked finally, thanks heaps for your patience with me 😃
One additional thing, this macro will run once we open the database. And in case it’s a weekend and any procedure fall on that date where I couldn’t open the database in such scenario the records will not be marked as due...
Yeah I did it just now and it worked. I have now put a test record for tomorrow to see how this will execute tomorrow.
Sincere thanks and really appreciate your support dear and apologies for my ignorance on this since I am not a tech guy.
Dear Arnelgp,
many thanks for your assistance dear.
It seems it worked but one thing is that macro is not running by itself when the database is opened but I have to run it manually.
Just to give you more details, 13 branches are using front end and the code which you have guided me I did it...
Please apologies for my ignorance, I am not expert into this. Plus the database is divided into front end and back-end.
Front-end if given to all 13 branches which contains list of their procedures, they open their front end daily to check which processes are due for review today.
The...
Yes Arnelgp, I have tried it but it did not mark those as "yes". When I executed the macro it gives me an error "the expression you entered has a function name that microsoft access can't find"
Actually, we have 13 branches and each branch has procedures or SOPs for them. Each process has a different date of last review.
Once they enter this information in their database, they need to generate a report on a daily basis to check if there are any new procedures due for review.
Its a...