Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
1
Hi All,
Quick question for you and sorry my first post is a question.
I am designing a series of programs for me to use at work, 3 in total. I have designed these at the moment in Excel using macros buttons to input data into a cell and then move to next sheet for next bit of info. As such I am relatively ok with VBA in excel.
I now however want to take the next step and more these excel files over to a stand alone programs. Essentially I am looking to design programs that move through multiple screens using buttons to input data into a database/spreadsheet that can be recalled for user viewing etc...
I did C at uni using dos prompts however have never worked with GUI's before in stand alone programs. The equipment they will be used on is touchscreen (finger not stylus) and so big buttons and sequential input rather than a 'form' with drop downs is the way to go. I have the apptitude to teach myself a programming language however which language is most suited to this application?
Any help you can give is appreciated and hope I can help others in the future.
Cheers in advance
Will
4 replies to this topic
Back to top|
|
|
#2
Posted 31 August 2011 - 06:09 AM
WingedPanther
-
- Moderators
-
- 16,831 posts
A spammer's worst nightmare
- Location:Upstate, South Carolina
- Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
- Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others
Start with choosing the operating system, and understanding how the OS will interpret contact on the touchscreen. If you're talking about Windows, any .NET language should be fine.
#3
Posted 31 August 2011 - 06:18 AM
William Fuller
-
- Members
-
- 3 posts
Newbie
Hi,
Cheers for that. It will be on windows and the touchscreen is treated as a single mouse click (or hold for double click). I posted her thinking given I know a fair bit of vba might be easier to transfer to vb.net Looked at a few tutorials and can see how forms can be set up to link to mdf file in visual studio so was thinking do the same as I have with excel, multiple sheets (forms) for each data cell on a row linked to an mdf database? How does this sound to you pros?
Cheers
Will
Cheers for that. It will be on windows and the touchscreen is treated as a single mouse click (or hold for double click). I posted her thinking given I know a fair bit of vba might be easier to transfer to vb.net Looked at a few tutorials and can see how forms can be set up to link to mdf file in visual studio so was thinking do the same as I have with excel, multiple sheets (forms) for each data cell on a row linked to an mdf database? How does this sound to you pros?
Cheers
Will
#4
Posted 31 August 2011 - 11:55 AM
WingedPanther
-
- Moderators
-
- 16,831 posts
A spammer's worst nightmare
- Location:Upstate, South Carolina
- Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
- Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others
That sounds very close to what I would do. VB.NET and vba will have similar syntax, though there will be differences to learn.
#5
Posted 31 August 2011 - 01:02 PM
William Fuller
-
- Members
-
- 3 posts
Newbie
Hey,
Cheers for your help on this. My main issue is at the moment I cannot rule out people altering data in master sheet or running macros manually etc... hence the reason for a program which will be run and additional features protected by password only for me.
Can anyone recommend any good reference/self teach books for vb?
Cheers
Will
Cheers for your help on this. My main issue is at the moment I cannot rule out people altering data in master sheet or running macros manually etc... hence the reason for a program which will be run and additional features protected by password only for me.
Can anyone recommend any good reference/self teach books for vb?
Cheers
Will
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users
