Re: Distributable Commercial Apps Access Vs Delphi



The logic goes like this:

Microsoft creates stuff that is supposed to be easy to use so that
everyone will buy it. VBA is easy to use, but since it is a high level
language (has lots of stuff prebuilt into it) you lose a lot of control.
So when projects become more complex and sophisticated, a high level
language like VBA will become inadequate. For what it is - VBA is quite
sophisticated, but it just can't compete with OOP based platforms.

The newer platform, .Net, also created by Microsoft, overcomes the
inadequacies of VBA by introducing OOP where it previously did not exist
(VB2005). So you still have the ease of use of VB with the robustness
and functionality of OOP. VB.Net is way easier to learn than Java (or
C# to some degree), but the beauty is that you still have (almost) pure
VB (almost no {} brackets to worry about, and there are no ; semicolons
at all to deal with). And VB.Net supports every object supported by C#.

C#
TextBox txt = TextBox1;
txt.Text = "Hello World";

VB.Net
Dim txt As TextBox = TextBox1
txt.Text = "Hello World"

For large scale/multi tiered projects, that are mostly windows based,
Net is a definite contender.


Rich

*** Sent via Developersdex http://www.developersdex.com ***
.



Relevant Pages

  • Re: Distributable Commercial Apps Access Vs Delphi
    ... Access is a great desktop database tool - for small projects. ... but do not possess any OOP ... big things .Net has done over VBA - one thing is reducing I/O. ... For Each txt As TextBox in txttt:Debug.Write:Next ...
    (comp.databases.ms-access)
  • Re: PPT VBA - Clicking on non-existent textbox?
    ... Monsieur Ziggie, bon soir. ... This bit of appears to be VBA has a SNOBOL's chance of helping you do the deed, ... > is fine until I have more text than I can reasonably show in the textbox. ... Steve Rindsberg, PPT MVP ...
    (microsoft.public.powerpoint)
  • Re: How to Make Tabbing work from VBA
    ... Microsoft has made the decision to retire VBA because by design it cannot be ... > tab key properly generates an Exit event. ... > I implement the _Enter and _Exit methods of each textbox to display a debug ...
    (microsoft.public.mac.office.word)
  • Re: Can I get formulas to work in Powerpoint (excel cut and paste
    ... Seems weird that you can multiply textbox values fine but not add them. ... This tells VBA to treat the text as values. ... > How can you add values (vs. multiple)? ... >> You can do this in PowerPoint by incorporating some VBA. ...
    (microsoft.public.powerpoint)
  • Re: New to .NET
    ... My favorite VBA book was published by WROX as well, ... Textboxes hold String object data, ... data formatted, you don't format the textbox, you format the data. ... Datatypes for text in a textbox... ...
    (microsoft.public.dotnet.languages.vb)