advanced access training - VBA modules vs Macros

The UK's most regular instructor-led training courses.
Training information: advanced access training · Access training · VBA courses London UK

Resolved · Low Priority · Version Standard

VBA modules vs Macros

Matthew has attended:
Access VBA course

by - delegate Matthew [1 post] (2007 Sep 14 Fri, 15:40) Reply

If an operation can be performed using either a Macro or a VBA module, which would you recommend?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 4 Thu + 5 Fri	Southwark	0	FULL
2003	2008 Oct 20 Mon + 21 Tue	Southwark	6	book now	£450	£485
2003	2008 Nov 6 Thu + 7 Fri	Southwark	6	book now	£450	£485
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 15 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: VBA modules vs Macros

by - delegate Jo [2 posts] (2007 Sep 18 Tue, 14:22) Reply

VBA offers the opportunity of error trapping giving a meaningfull description of the error and its location- from this you may arrive at a SOLUTION A LITTLE QUICKER.

BUT for the VBA newbie who wants to see results pdq and is prepared to breakdown the steps involved in the process of macro automation - macros will be a usefull tool, but in the event of an error ..ooops is all you will probably get or even worse nothing at all and only when something isn't where it should be or is appearing randomly will you encounter the 'macro menace'
NB

Macros do not offer a complete solution you will at some point have to resort to VBA in developing a bespoke solution.

regards
jO

· Access VBA Training Adds Power to your Databases
· Reasons to Consider Microsoft Access Training
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database
· Want to Become the Office Hero? MS Project Training Could be the Answer
· Get More Out of MS Access Courses

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips