access courses in london - What is a loop?

The UK's most regular instructor-led training courses.
Training information: access courses in london · Microsoft.access.courses · Microsoft Office VBA training

Resolved · Low Priority · Version Standard

What is a loop?

Yanti has attended:
Excel Advanced course

by - delegate Yanti [7 posts] (2007 Jul 23 Mon, 09:47) Reply

what is a loop?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 9 Wed	Southwark	6	book now	£214	£230
2003/XP	2008 Jul 16 Wed	Bayswater	6	book now	£195	£205
2007	2008 Jul 25 Fri	Bloomsbury	3	book now	£240	£245
2003/XP	2008 Jul 30 Wed	Bloomsbury	0	FULL
2003/XP	2008 Aug 6 Wed	Southwark	6	book now	£214	£230
2003/XP	2008 Aug 18 Mon	Bayswater	5	book now	£195	£205
Full Schedule: See all 57 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: what is a loop?

by - trainer Tracy platinum contributer [586 posts] (2007 Jul 23 Mon, 10:38) Reply

Hi Yanti,

A loop is basically just a set of statements that run until a condition is set.

For example:

i=0

if i <= 10

do something
i++

The above is pseudocode for a loop, this loop will do something until i reaches 10.

Hope this helps
Tracy

· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· The Benefits of Certified Microsoft Training in Access
· Access VBA Handling Errors and Debugging Code
· Learn about Subqueries in Access Courses
· Want to Become the Office Hero? MS Project Training Could be the Answer

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips