PDA

View Full Version : New to VBA (Access)


simon4amiee
24th March 2009, 09:39
New to VBA
Good morning, I am just starting out in VBA, having gone through Access 2000 manual, and now on VBA for dummies manual, and it seriously does take some getting used to, Im assuming this is a good site for any help, any other good manuals around to assist.

Regards

Simon

Astaroth
24th March 2009, 11:34
Always found VBA very painful to write. Depending on what you are wanting to do there may be better options

simon4amiee
24th March 2009, 11:48
Its more understanding it than writing it, yes im finding it hard!

spreadsheetsdirect
24th March 2009, 11:53
Main problem with VBA in Access is that some things need about 5 or 6 lines to do the same as a single line in Excel.

greenbox
24th March 2009, 12:10
hi Simon,

If your learning access VBA for the first time, im sure it could be pretty daunting. Do you have any other programming experience ?

If not I would start off by trying to learn the basics such as:
if / else 's , looping, functions.

I'm an access vba expert , but im not sure that there will be many vba guys here as its a general It forum.

But take a look at www.access-programmers.co.uk/ (http://www.access-programmers.co.uk/) which has a good forum for asking your access VBA questions.

regards
Louis

Green Box Software

simon4amiee
24th March 2009, 12:25
yes on that forum as well as here, yeah just starting to learn the basics now using that VBA for dummies!

Walk-IT
24th March 2009, 17:24
I've been writing Access database for years, you'll find that experience and practice count for a lot, but to get you started, there are hundreds of sample database available that will help give you ideas on how to successfully structure your code and work Access and its peculiarities.

the Utter Access forums are worth joining, there a re lots of people sharing databases on there that should help.
(sorry I cant post links yet so you'll have to google it!)