I play a football management game in which I run a number of teams in different leagues. I receive my turn & other information via E:Mail.
Currently I have a self-written VBA application that interacts with an Access database to keep track of my teams and all my information such as Return-by date, Session number, Bank Balance, Fixture List, Scouting of other teams, etc. etc.
It has some bugs and also it has the restriction that whilst it is running I can't use any other Excel spreadsheets. I therefore want to rewrite it using SQL instead of Access and my original intention was to use VB.net via Visual Studio 2010 and Windows Forms, all of which I understand at a basic level.
However, I am also intending to learn Javascript at some point and I am wondering if I can use it somehow in this rewrite, and if so, if I am going the right way about it, or if I should be going down another path !!! I am a mainframe programmer by trade, though unemployed and therefore want to learn something that may be of use to me in finding work & I've always found that the best way to learn something new is if you (a) are enjoying what you are doing & (b) have an end product to work towards.
Would VB.net Windows Forms using VS2010 be a good way to do this ? Would I be better making it a Web Form ? Is it a feasible idea having Javascript applets to process data when I select a Button on my Form / Web Page ?!?
Any advice would be very helpful & gratefully received ...