Create a Task List Plug in for Existing MS Access/VBA Application
$30-250 CAD
キャンセル
投稿日: 5年近く前
$30-250 CAD
完了時にお支払い
In this MS Access/VBA project, you will build a task/reminder system that will be plugged in to a an operational Access database that has fifty users.
When users logon to their database using the systems logon screen, their main menu will open up as usual (existing code). If they have any outstanding or recurring tasks in their queue, then your new task form will pop up in modal form above the main menu. They can review the list and click off checkboxes for any tasks they have completed, click OK, or cancel to resume their daily tasks.
For example, Sally is a user who belongs to the billing department. Each month, a set of pre-assigned tasks pops up on the first of the month: a report for this, a report for that, some billing entries; perhaps a phonecall to a client who needs information each month. Sally makes the phonecall, checks off that item in the list, then clicks OK to close the form. She runs some reports, opens the task list from a button somewhere in the menu, checks off the reports and closes the form with the OK button.
Features:
- A user with admin privileges can set up one-time or recurring tasks for other users.
- Other user roles can add tasks to their own list.
- System can trigger itself on user logon to calculate which tasks should show in the list.
- Tasks can be regular urgency or high-priority tasks.
- You can design the tables (SQL Server/linked tables).
- Tasks stay on the user's list until they check them off.
- A task can be set to leave a task in another user's list when completed. ex. Sally finished a report, John gets task to review report.
- A task can be set to call the existing SendMail VBA function to send an email to specified email address when completed.
- A file/case number (max. 8 chars) can be specified on a task.
- You will create a VBA sub/function that can be called from VBA to load a task into user's profile so that tasks can be hooked up to any other events in the system.
Conventions:
- Use LNC/hungarian naming conventions for objects and VBA.
- Current design uses ODBC with DAO. Please use the same and not ADO.
- Database format is .mdb, not .accdb.
- Design to 32-bit Office/VBA.
- Use the same colors and design feel of the current application.
- You will provide a file with the new objects (queries, forms, reports) and a SQL query with the create statements for objects on the SQL Server side.
Hello, dear sir!
I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality!
From the Access, of course, familiar.
Give me a chance to show what I can do!
Hi
I am interested in the project. I am an experienced MS Access application developer. I have developed many applications and have done many change requests here on freelancer.
If interested in hiring me then please let me know so that we can discuss the timelines, budget and scope accordingly.
Thanks
Regards
Jawad
Hello
I am working with MS-Access database and VBA for the past 18 years. I have also developed many important application using MS-Access as both front-end and back-end tool and have completed a good number of Access Projects through Freelancer.com. I would do your work and is ready to start right now. I have gone through your detail project specification. Give me the job, get it done, satisfy yourself and then make payment. I wont seek any payment from u until ur job is fully done as per your satisfaction. Customer satisfaction is much more important and my top most priority. No satisfaction no payment. Hope to hear positively from u.
Regards
John
I have many experiences in ACCESS, Excel VBA developing and data mining.
I'm software engineer and algorithm expert.
Your task is suitable with me.
I'm also perfected in C, C++, C#, SQL, PHP ....
Thank you.
Dear
I read your description and I have found that your job very interested
And it would be easy to be done at a short time
you can see my work in the profile
----------------------------------------------------
it would be nice to work with you sir :-D
Thanks