Search results

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

thank you so much it worked, I really appreciate your support

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

Yes I do have access to back end and it is a shared folder Creating excel on front end once report is generated some users need it in excel

Database is splitted into back end and front end Front end on my PC and back end is on a server.

Dear it’s developed by myself and IT is not involved and they have no clue whatsoever

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"

Dear All - any possible solution on this please.

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...

Dear Experts, I am here once again to seek your support. I have a database that has a list of processes for my organisations. Each process should be reviewed after 3 years. Here are the fields: Process Name (Type - Text) Last Review Date (Type - Date) Next Review Date (Type - Date) Process...

Yes conditional formatting worked... I never knew this. Thank you soooo much

yes, the form has a split and it has rows like excel. Can you please explain to me in detail how to set up conditional formatting?

Dear All, Appreciate your expert guidance please, probably it is very simple but I am making a silly mistake. I have 3 dates on a form (Last Review Date, Next Review Date, and Start Review Date). Last Review Date let's assume today (i.e. 18/08/2022) Next Review Date is "Last Review Date" + 3...

Dear we have modify permission as well on the folder