OK after several weeks of work I have gotten my DB about as far as my meager skills can take it.
I need an accomplished programmer well skilled in VBA, SQL and Access to help me complete this project.
1 - The person needs to take the time to truly understand the DB I have created. If you don't have a full understanding of how it is supposed to work, you will not be able to complete this job successfully. I imagine that we will have at least 2 telephone conversations, as you get a working knowledge of what the DB is supposed to accomplish and what it needs to be completed.
2 - Then I want that person to go through each line of code that I have written. Looking for ways to streamline it, incorporate error catching and troubleshoot potential problems. (ie: I have just this morning found a problem in a line of code that is based on user input, if the input is 0 this code cannot divide by 0 and I am getting errors)
3 - Once the DB is complete and all the queries, reports, and forms work the way they are supposed to. Then I need you to build a simple security access into the DB. A basic Login with a username and a password and based on such will allow access to certain buttons on the Switchboard. I tried to setup security using "Access User Level Security" but I find it too cumbersome. I have a very clear and what I believe is a simple way to lock down the DB. I am only looking to stop tinkerers and busybodies not build FortKnox, and I want you to use my ideas to build this security feature.
4 - After the above 3 are complete, I will split the DB into a FE and BE and deploy it for limited use to my local user base. Once live people get theirs hands on it. I am positive weak spots and bugs will be revealed and the ones I can't solve myself I will expect to be able to call on you for guidance with. Don't worry I will pay well prior to this time (I will be paying once you have completed the first 3 steps.)
I am giving preference to programmers that live in a relatively close time zone. I am price sensitive and value conscious. Please do not bid, if you honestly don't have the skill set to complete the above stated. Do not bid, if you are not going to give this project the time and effort that I am expecting to pay for.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
I prefer that all the code be written in VBA only because I have knowledge of VBA but if it makes more sense to build it in SQL then so be it.