By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,470 Members | 966 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,470 IT Pros & Developers. It's quick & easy.

Is editing Recurring Events possible?

P: 1
I'm trying to work with Allen Browne's sample database which allows you to schedule recurring events. If I do like Allen explains it, I want to add my own information on a recurring event like add an employee to an event. If I later decide to switch that employee for another employee, there is no history to show that the 1st employee ever was working on that particular event. the query just runs a new calculation based on the single Event record where now resides the new employee's ID instead of the old one. So my question is how do I keep track of history. Is it possible? is there a workaround? Update query maybe? do I use a form for that? mmm so many questions... please help me in the right direction.
Mar 27 '14 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,397
elpi

I certainly understand what you are asking; however, Allen isn't here to help explain how his calendar works nor is it quite fair to ask us to reverse engineer his work; however, I have read his site and the explanations given are quite clear as to how the calendar works.

From that, what I would do is create a table to act as a history log that has a relationship to the employee and the project. Each time a employee is assigned a project, record the date, the employee, and the project.

You will need to review Mr. Browne's interface to determine how to do create the entries and if you run into a snag, then post the particulars for a specific issue and we'll do our best for you.
Mar 28 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.