PDA

Click to See Complete Forum and Search --> : Appreciate suggestion


yinoway
Feb 2nd, 2004, 02:49 AM
I am wondering which to take to develop time recording-calculating software. Which is better Access or VBA?
I am old man accustomed to develop good old Basic Interpriter, during 1980.

My project does not require big size of memory nor data.
I would like to know which is easier to debug the flow.

If someone could help me, Apreciated.

yinoway

salvelinus
Feb 2nd, 2004, 10:16 AM
Not sure what you mean. VBA is part of Access. If you want to know if you could do your calculations w/o using VBA, maybe. Depends on what you need to do. I prefer using code, myself.
Do you mean Access or a stand alone Visual Basic app?

yinoway
Feb 2nd, 2004, 06:14 PM
Thank you, salvelinus!

I didn't realize VBA's part of ACCESS. I hve been taking each as the separate language but using same base.

On the surface, MS sells two separate program, aren't they?

salvelinus
Feb 2nd, 2004, 06:53 PM
MS sells Visual Basic.Net now, not sure if they still sell Visual Basic 6, which was the last version of "regular" Visual Basic.
Visual Basic is a separate programming language. You can use it to create your own programs, or use it to manipulate MS Office programs, including Access.
VBA stands for Visual Basic for Applications, meaning MS Office programs. I think it's included with most Office programs, at least at the Professional version and above. Maybe not above Office 2000, I haven't worked with anything above that.
Anyway, VBA is sort of a modified Visual Basic Lite, designed to work primarily with MS Office. You can access it several ways. The usual way I do it is to highlight the form I want, then click the yellow square icon on the toolbar.

yinoway
Feb 3rd, 2004, 10:44 PM
Thank you again, salvelinus:

VB is a base to tease with MS officees, that clears me.

Now I will go buy NT and start programming.

If you have any question regarding Japan, Japanese, I can answer any.
In the meantime, let's work.


;)

salvelinus
Feb 4th, 2004, 07:52 AM
VBA is the simplified version of VB, and VBA comes with at least some Office apps.
VB6 is the last version of regular Visual Basic.
NT is an operating system, like Windows 2000, or XP.
VB.Net has some similarities with VB6, but is basically a whole new language, even farther from VBA.

yinoway
Feb 4th, 2004, 08:52 PM
Hi!

I meant to say NET, not NT. Sorry about that.

You are suggesting to go for VB6 rather than NET, is that it?

As I finish development, I will put it on the net for free downloading. In that case, the programing base should be popular.

From this point of view, I take that you recommend rather VB6 than NET, am I reading right?

Appreciate your suggestion.

salvelinus
Feb 5th, 2004, 07:52 AM
Well, .Net will probably be the future of Windows programming, and it has advantages over VB6.
But VB6 is closer to VBA, has a huge base of support and existing apps, etc. It's really kind of your choice. If you're developing a Web app, or will be programming in the future, I'd choose .Net. I use it at work. At home I have VB6, so that's what I use there.
I only use VBA when I have to work on an existing project, or do something really small.

yinoway
Feb 5th, 2004, 11:42 PM
Thank you for your kind followup.

Whole thing is clear now.
:D