tati16
01-18-2018, 07:20 PM
Hello everyone. I'm new to the forum and new to the VBA world with Access.
I am trying to get through my first challenge but I find something tangled. It's about the following:
I have a form in access where when selecting a festive date (example December 25) and clicking on a button, a report is printed. (which is the result of a query). Now, if the user prints it today, January 19, it shows the report correctly. But if you print it again on January 28, the user wants to see the new, modified and / or deleted records between January 19 and 28. In other words, the user does not want to see the records that did not have any change.
So what I have thought is to create a table that stores the result of the first time the report was executed and then another table the second time they executed the report and make a comparison of tables.
What confuses me is that I do not have a date field in which the report was executed.
Could someone tell me if the previous one is a good solution and how can I do it? Do I should use a recordset?
Many thanks, I really appreciate any comment.
I am trying to get through my first challenge but I find something tangled. It's about the following:
I have a form in access where when selecting a festive date (example December 25) and clicking on a button, a report is printed. (which is the result of a query). Now, if the user prints it today, January 19, it shows the report correctly. But if you print it again on January 28, the user wants to see the new, modified and / or deleted records between January 19 and 28. In other words, the user does not want to see the records that did not have any change.
So what I have thought is to create a table that stores the result of the first time the report was executed and then another table the second time they executed the report and make a comparison of tables.
What confuses me is that I do not have a date field in which the report was executed.
Could someone tell me if the previous one is a good solution and how can I do it? Do I should use a recordset?
Many thanks, I really appreciate any comment.