How to create a form where employees can submit certain requests, and would also complete the below actions? (NEARLY IMPOSSIBLE)

I am using visual basic, and I need to create a form that employees can use to submit certain requests, and once a request is submitted the data will be stored in an access/excel database, and an email is sent to their manager with a link to view the request (manager email address will be included in the form field by a combobox), once the manager clicks on thelink they will be able to view the request and from there they can accept it or reject it...(if request is accepted then its data should be stored in a seperate access/excel database for accepted requests, and if request is rejected then employee should receive an email advising request is rejected, and the request data should be stored in a seperate access/excel database for rejected requests.
Any help or advise will be HIGHLY APPRECIATED.
Adham TarekAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pcelbaCommented:
Why would you need to reinvent the wheel?

This functionality (and much more which could be possible problem) is implemented e.g. in the Trac ticketing system. It is open source (written in Python) and it works as expected... Everything you need is to download Python 2.x and the Trac... More info: http://trac.edgewall.org/

Trac plugins allow to create tickets via e-mail, Trac allows to assign certain person to solve the request, Trac offers reports which can show the overall progress, collect information about the time spent on requests and you may also use Trac to create Wiki pages for whatever purpose you need.

Trac is oriented to software development so you may find some functionality useless but you may find many more such systems which could be better for your purpose. Just search the web.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If you must create it in .NET you could certainly do so.

The System.Net.Mail namespace allows you to easily create and send emails from .NET. It's often as simple as setting the SMTP server, login details, and then creating and sending the email.

You would use the System.Data.OLEDB namespace to manage the data. Open a connection to your database to read/write data, and then go from there. You can manage the data manually (read from the db, show the data on your form, and then capture/save) or you can use bound controls.

There are tons of sample projects around the net. You might have to cobble a few of them together to get all the features needed. but they're out there.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.