Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access vba

ResolvedVersion 2003

Craig has attended:
Excel VBA Advanced course
Access VBA course

Access VBA 2003

Hi Antony,

Further to our course on Thursday & Friday.

Are you able to provide me further links for sites that contain good Access Add-ins to further progress my coding skills.

Also what would you recommend book wise for quick and easy referencing.

As discussed as well my email address for contact is craig.edwards77@ymail.com

Look forward to hearing from you.

Kind regards,
Craig

RE: Access VBA 2003

Hello Craig,

A few books we use are:
Access 2003 power programming with VBA by Allen G. Taylor, Virginia Andersen

and an excellent guide called:
Access VBA programming by Charles Edward Brown, Ron Petrusha

Although there are numerous books available these 2 are ones we find the most useful.
A website with useful resourses:
http://www.access-programmers.co.uk/
It has free content and forums.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark (Antony is away til new year)
Microsoft Office Specialist Trainer

Tue 13 Dec 2011: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.