As a newbie to the forum, please accept my apologies if this in the wrong place. ( and apologies if this a long post )
I operate a consultancy service ( construction ) and wish to monitor what has been done and what is left to do on a number of projects. Until recently I have managed this via a series of Excel spread sheets, summarising various data on the "front" sheet. That was fine until I am now running some 25 or more projects, the Excel system is getting a little messy - and having secured the instructions from clients that will be increasing my work load numbers significantly, I am seeking to use a more suitable solution.
The tasks for each project wil vary and some are charged on a lump sum basis whilst others are on an Hourly + expenses rate.
At present I can click on the Excel page for each job and see what needs to be done, when various documents were received and when our response / action was completed
I can also see on my summary sheet, how much ( fees ) are currently unearned and how much is compeleted and to be invoiced.
I have visions of incorporating my sales ledger into the system too ( in time - I know I need to crawl before I sprint )
I have some experience of VB programming ( though I am struggling some of the new features and different ways of doing things since my last programming session )
Now first of all, do you agree that what I am seeking to do is possible ? Has anyone already written a programme for this ? ( or similar that could be adapted )
any constructive comments would be appreciated please
My main issue at present is trying to get a database to work ( it's different from the early VB version I had on cardbaord floppies ) I am assuing that this is the best way to populate Comboboxes etc when selecting a project to edit / record ? So any pointers to Youtube or similar would be appreciated please
many thanks for reading this far ( not sure I could have