Ok, this is a fairly simple project, i know how to do it myself have done somthing similar many years ago, but dont have the time to start researching the code on how to do each thing again.
Ok well here is the background of the project. This database is for a independent record labels database (mine). this database will contain all information about the artists, monthley sales, release information, expiration of contract date, will generate unique barcode number for each release (eg. BTBR00005518), billing details for each artist, also creating a unique id for each artist. On each particular song entry, need to put the % amount that song is getting in royalties (this will be needed for when exporting sales reports with profit & loss)
The front end I want to look like this. You open up the program / dbase you get a screen, with search boxes for either artist, release number, tittle, country, month / year, contract expiration date, music style.
then say you search for artist, you can then bring up the artist profile where it will say all of their information, you can then click a button on the profile to add a new release by artist or new remix by artist, that will then bring you to a page where you enter all the info about the release
back on the home screen, would also want a button where you can enter new artist
with the contract expirary date, would want it to give me a 1month prior pop up messege and continue to do that, until i have selected if the contract has been renewed (i then put the new contract date in) or if the contract has been cancelled and not renewed.
On the home screen would want to be able to press a button and print off reports where i can choose the fields to be preasent in the reports.
Now this is where it may get a little tricky as i haven't done this before on access so not sure what would be involved.
On the home screen want to be able to press enter quartely sales figures. it will then take you to a screen where you can enter the release number, press enter then enter unit sales press enter then next sceen enter income.
after this has all been entered on the home screen, would want to be able to export sales reports where i can select the parameters i.e from when to when, or for a particular release, in total etc. as well have it exporting to a line graph as well, unit sales, income & net income.
If possible can this be turned into a proper .exe program, with this program I will be taking all rights to it, and all updates will be sent to you and you will be paid accordingly for the edits and updates, with future similar jobs to follow if impressed.
Would also like to have a 1 month period after completion for ironing out of bugs.
Thanks
Respected Sir,
Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy
with attention to detail. Looking forward to your prompt reply.
Kindest regards.
i can complete this project in Visual Basic language. i have an experience of developing many vb projects. is u provide me an opportunity, can finish this project upto your satisfaction.
thanks