access training courses - Excel VBA loops

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

Resolved · Low Priority · Version Standard

Excel VBA loops

Sameer has attended:
Excel VBA course

by - delegate Sameer [1 post] (2007 Oct 2 Tue, 09:42) Reply

dummy question: is it possible to accientally create a loop that will not stop running and if so how can it be broken ? escape button ?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 10 Thu + 11 Fri	Southwark	3	book now	£475	£495
2003/XP	2008 Aug 7 Thu + 8 Fri	Southwark	7	book now	£345	£399
2003/XP	2008 Sep 4 Thu + 5 Fri	Southwark	5	book now	£450	£485
2003/XP	2008 Oct 20 Mon + 21 Tue	Southwark	8	book now	£275	£399
2003/XP	2008 Nov 6 Thu + 7 Fri	Southwark	8	book now	£275	£399
2003/XP	2008 Dec 4 Thu + 5 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 17 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Excel VBA loops

by - trainer David gold contributer [428 posts] (2007 Oct 5 Fri, 09:54) Reply

Hi Sameer

You can create a loop that does not end. To stop it running you can press the end key on the keyboard or if the worst comes to the worst, just restart your computer.

Once you have stopped the loop then I suggest you go in and change your code so that you do not have an no ending loop again.

Hope this helps
David

· Why consider Access Visual Basic training?
· Microsoft Access Mistakes to Avoid
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Innovation with Microsoft Access
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips