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 libraryies

	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 libraryies

Resolved · Low Priority · Version 2003

Reply Tue 27 Jan 2009, 11:32Delegate Cameron said...

Cameron has attended:
Access VBA course
Access VBA course
Access Advanced course
Excel VBA Intro Intermediate course

VBA libraryies

What ref libraries should we have ticked for bug free code??

For upcoming training course dates see: Pricing & availability

Reply Mon 13 Apr 2009, 11:44Trainer Stephen said...

RE: VBA libraryies

Hi Cameron

Thank you for your question

I would suggest that apart from the default libraries you also have the DAO object model selected. In addition, if you wish to interface with other microsoft applications then you have those object models also selected. This will allow you to use a process known as early binding which makes your code much more robust. We cover this on the VBA excel advanced course

Regards

Stephen

Access articles

· Express Yourself With Microsoft Access
· Making Figures Talk For Themselves Thanks To Access
· Use Microsoft Access to manage your work/life balance
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Get A Head Start With Access 2010 Templates

Please browse our web site to find out more about
access database 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