Käynnissä

Create a Task List Plug in for Existing MS Access/VBA Application

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.

Taidot: Tietokantaohjelmointi, Microsoft Access, Microsoft SQL Server, Visual Basic, Visual Basic for Apps

Näytä lisää: how to create a work order database in access, microsoft access task management database, microsoft access 2013 task management template, free microsoft access work order database template, access database task tracker, time tracking access database template, microsoft access project management template, access vba create outlook task, create task list php, convert existing ms access databases sql asp net web interface, create inventory project big company ms access free source code, create login page dreamweaver coldfusion ms access database, manage serial port ms access vba, ms access vba ado samples mssql, ms access vba code copy paste subform form, ms access vba code ftp download, ms access vba codes pdf, ms access vba developer jobs, ms access vba file list spaces, ms access vba ftp download

Tietoa työnantajasta:
( 3 arvostelua ) Vancouver, Canada

Projektin tunnus: #19634217

Myönnetty käyttäjälle:

jonathanpradas

Hello Sean. I wont be writing too much on my bid as you already know me. Thanks for this oppurtunity.

$160 CAD 3 päivässä
(55 Arvostelua)
5.4

10 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

VladimirLilenko

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 Lisää

$250 CAD 5 päivässä
(145 arvostelua)
6.4
jawadaman

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 Lisää

$250 CAD 7 päivässä
(81 arvostelua)
5.7
KellogITSolution

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 Lisää

$140 CAD 7 päivässä
(34 arvostelua)
4.9
NeilSargent

I have over 20 years experience developing applications in Access and Excel with advanced knowledge of SQL and VBA and particular skill in integrated Microsoft Office solutions based upon automation of Excel, Word and Lisää

$1800 CAD 14 päivässä
(4 arvostelua)
4.0
xinglong717

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.

$250 CAD 7 päivässä
(10 arvostelua)
3.7
bluebear1888

I am web and app program Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer to feel the greatest satisfaction with low price. If you want to dev Lisää

$100 CAD 3 päivässä
(1 arvostelu)
2.6
AhmedRagab321

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 ----------------------------------------------- Lisää

$200 CAD 13 päivässä
(0 arvostelua)
0.0
kmd715

Hello Hiring Manager, Greetings, We are Software Company based in India with 7+ year’s experience. We have huge experience in Web Designing & Development, Mobile Apps Development & Online Marketing. After careful Lisää

$140 CAD 7 päivässä
(0 arvostelua)
0.0
cooddooc

Hi!I'm very happy to have a chance of bidding your [login to view URL] can we talk?Please schedule a time? I am an excellent developer in this industry. If we work together, I will satisfy you fully. Please give me 10 minutes Lisää

$140 CAD 7 päivässä
(0 arvostelua)
0.0