Howdy all,
Some background: I need a solution for tracking environmental compliance at a chemical plant. The solution will be used by 4 or five employees that all have Access XP installed, with the possibilty that remote users (Divisional Management) may want to look in and see how we're doing (remote viewing of whatever management system we implement). Our company implements Lotus Notes (v7) with Domino.
I'm a technical user in Access - fairly comfortable with VBA, but I don't want to reinvent the wheel. I'm not experienced with Lotus Notes/Domino code or databases, and frankly don't understand the "document based" architecture vs. the relational db used in Access.
What I want is an application that allows us to track deadlines (report dates, regulatory compliance dates, project dates) and the tasks associated with those dates (recordkeeping, milestone tasks for projects, and actual sending of reports, etc...). The tasks will need to regenerate (ie, recurring dates) after completion and maintain a history of completion. Tasks should also be viewable from some sort of Calendar.
We could have a custom Lotus Database built for our department that lets us put a bunch of tasks in and categorize them (report, recordkeeping, compliance review, etc...), but we lose the relationship between a deadline of some sort and all of the related tasks that must be completed in order to meet the deadline. Access would be a great tool for tracking deadlines and related tasks, but calendaring those tasks and regenerating them would be cumbersome, especially when there are apps out there designed to do just that.
Sorry so lengthy, but I want to find a good solution - even if it's a hybrid Access db / notes calendar or something.
Has anyone out there built anything to achieve a similar purpose? Does anyone have any suggestions?
Some background: I need a solution for tracking environmental compliance at a chemical plant. The solution will be used by 4 or five employees that all have Access XP installed, with the possibilty that remote users (Divisional Management) may want to look in and see how we're doing (remote viewing of whatever management system we implement). Our company implements Lotus Notes (v7) with Domino.
I'm a technical user in Access - fairly comfortable with VBA, but I don't want to reinvent the wheel. I'm not experienced with Lotus Notes/Domino code or databases, and frankly don't understand the "document based" architecture vs. the relational db used in Access.
What I want is an application that allows us to track deadlines (report dates, regulatory compliance dates, project dates) and the tasks associated with those dates (recordkeeping, milestone tasks for projects, and actual sending of reports, etc...). The tasks will need to regenerate (ie, recurring dates) after completion and maintain a history of completion. Tasks should also be viewable from some sort of Calendar.
We could have a custom Lotus Database built for our department that lets us put a bunch of tasks in and categorize them (report, recordkeeping, compliance review, etc...), but we lose the relationship between a deadline of some sort and all of the related tasks that must be completed in order to meet the deadline. Access would be a great tool for tracking deadlines and related tasks, but calendaring those tasks and regenerating them would be cumbersome, especially when there are apps out there designed to do just that.
Sorry so lengthy, but I want to find a good solution - even if it's a hybrid Access db / notes calendar or something.
Has anyone out there built anything to achieve a similar purpose? Does anyone have any suggestions?
