Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » VBA

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

VBA

Resolved · Low Priority · Version 2003

Reply Thu 7 Aug 2008, 15:46Delegate Chloe said...

Chloe has attended:
Access VBA course

VBA

What are the main uses of Macros in Access and once you have learnt how to use VBA, do you need to use them again?

For upcoming training course dates see: Pricing & availability

Reply Tue 12 Aug 2008, 14:09Trainer Stephen said...

RE: VBA

Hi Chloe

Thank you for your question

Macros allow the developer to build a simple set of automated steps, thus improving the efficiency of a database application.

Once a developer is competent in VBA however Macros have very little utility. They cannot carry out the range of methods available in VBA and in general run a lot slower than the corresponding VBA code
Regards

Stephen

Access articles

· A Greater Understanding Of Your Business With Access Reports
· Mining For Data With Access
· It Is Important To Take Care Over Primary Key Assignment
· Sub-reports And Sub-forms In Access 2007
· Making The Transition To Access - Why You Might Need It

Please browse our web site to find out more about
ms+access+courses and other Microsoft training courses.

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips