Microsoft Access VBA question.
First time user here at Experts Exchange so bear with me.
I have an access database loosely based on Allen Browne's famous recurring tasks database here: http://allenbrowne.com/AppRecur.html
I can't find a way to link to every event instance. He used a Cartesian query which I'm not familiar with.
I need a way to be able to retrieve every event instance so on other forms I can run a query for what's due, what's been completed, what's overdue, etc. and link to each instance for searching, adding attachments, deleting occurrences, transferring to others, etc.
What I'm assuming I need is a way to take the top part of his frmEvent and run an update or append query to a table based on the frequency and number of instances entered? Then each record will be in a table that I can more easily refer to.
Please advise! Many thanks in advance 😊