• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 25
  • Last Modified:

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
0
Gemini G
Asked:
Gemini G
  • 7
  • 4
1 Solution
 
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 7
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now