Need to link/query/append Recurring Task Instances

Microsoft Access VBA question.

Greetings Experts!

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 😊
recur.zip
LVL 1
Gemini GVBA & Database ProgrammerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gustav BrockCIOCommented:
The Edit button on each record opens a form.
That seems like what you are asking for.
0
Gustav BrockCIOCommented:
So it was the answer?
0
Gemini GVBA  & Database ProgrammerAuthor Commented:
No the edit button does link to exceptions but the individual instances do not query. For example when I put "between start and end date" in the event query parameter only the main item comes up. There is no way to query each instance for which ones are due , which were completed, or which ones were late. Am I missing something?
0
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

Gustav BrockCIOCommented:
It should be possible, but have in mind please, that most of us are busy with "real" work, which excludes more time-consuming tasks.

You might open a project in Gigs to sort this out.
0
Gemini GVBA  & Database ProgrammerAuthor Commented:
Yes I am busy as well, I've spent many hours researching this problem and I consider this "real work" as it applies to my job.  I don't know about gigs, I'm just looking for the correct way to query each instance of a recurring task. Sorry to bother you, hopefully there is somebody else out there able to help. Thank you for responding though.
0
Gustav BrockCIOCommented:
OK. No problem.
1
Gustav BrockCIOCommented:
I guess you can delete this now.

See:
https://www.experts-exchange.com/questions/29085529/
0
Gemini GVBA  & Database ProgrammerAuthor Commented:
No it still has not been solved. Please let somebody have the opportunity to suggest another option or advice. Thanks
0
Gustav BrockCIOCommented:
OK. Here you go (attached).
Recur.accdb
0
Gemini GVBA  & Database ProgrammerAuthor Commented:
Ok strange why my date parameter didn't work but yours did. Thanks!
0
Gustav BrockCIOCommented:
The magic touch!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.