I HAVE to make a few calculations on VB for access by the next three days.
Problem is i dont know any Visual Basic coding.
What i wanted to know is that i have a book that claims to be able to teach the reader Visual Basic 6 within 24 hours.
If i learn Visual Basic 6, or atleast the fundamental aspects of VB 6, Can i use this in Access for calculations?
I know that Access uses VBA, however Im not entirly sure if the language methods are similar.
~~
Note: I am calculating Tax on staff members wages. I am limited to what i can do. I cannot use SQL or other methods. It is not permitted within my course. Only VB.
Thank You
2007-03-12 08:48:07 · 7 answers · asked by Gurpz 2 in Computers & Internet ➔ Programming & Design
The fundamentals of VBA are exactly VB6, but you will need to learn a little about programming VBA for forms and such in Access in order to make full use of it.
I strongly suggest the following site in addition to any books you may already have:
http://www.functionx.com/vbaccess/
Good luck.
2007-03-12 08:51:20 · answer #1 · answered by Anonymous · 1⤊ 0⤋
I read the other comments and thought I'd add one or two.
Firstly, learning a programming language in 24 hours has the validity of perpertual motion machines. So don't expect too much in one day.
Secondly while VB and VBA are fundamentally the same VBA is just a bit cut down I think.
However "vb.net 2005(express edition)" is not the same. It is a different language which was provided as a transition to VB.Net. And is object oriented and more complex IMO.
When you are ready, write down the sort of functionality you need, and ask for code samples on this answers forum. I'm sure you'll get quick help.
Also enter into Google for example:
"vb6 loop example sourcecode"
or similar to get tons of help.
VB really is a terrific language to get the job done fast. Even though it has a few drawbacks.
Lloyd
2007-03-12 09:07:46 · answer #2 · answered by instantdegrees_scam 2 · 0⤊ 0⤋
Yes, VB6 within the Access realm is perfect
Most of the Office 2003, as well as Office 2007 have an almost exclusive link to VB6 at this point in time.
Some coding is done in the Access DB code language. But VB6 will be an asset since Excel, Word and all integrated Packages in Office rely solidly on VB6 to get the coding done
2007-03-12 08:50:29 · answer #3 · answered by Mictlan_KISS 6 · 1⤊ 0⤋
Yes you can do it easily in VB 6.0
Following that book, first make a simple Form in VB to add, subtract and mulltiply two numbers that the user inputs in 2 text boxes. Create 3 buttons and label it "Add", "Subtract" and "Multiply". On clicking the appropriate button, display the result in a 3rd text box.
If you are able to do it successfully, then you can also do the required calculations. First, input the salary in a text box and on click of a button, store the tax calculations in a variable and display its value in a second text box.
Finally, read how to manipulate MS. Access data and then do it ....
Good luck
Cheers!
2007-03-12 09:03:31 · answer #4 · answered by Anonymous · 0⤊ 0⤋
Yes, you should be able to complete the task using vb 6. If you want hands on practice while reading, you can download a free copy of vb.net 2005(express edition) it's for students only and will let you do what you want to do with access.
2007-03-12 08:51:55 · answer #5 · answered by Anonymous · 0⤊ 0⤋
VB is very simple actually to use
its not so much of understanding it
its more of talking yourself through it and some trial and error
there are many things to know but most of the basics would get you through your problem
try from For next statements, loops, and some arrays
2007-03-12 08:52:21 · answer #6 · answered by Cute W O the E 7 2 · 0⤊ 0⤋
I believe that VISUAL BASIC is a different language to VISUAL BASIC FOR APPLICATIONS.
2007-03-12 09:24:56 · answer #7 · answered by remember_lizzie 2 · 0⤊ 1⤋