access training courses - Excel VBA loops

Resolved · Low Priority · Version Standard

Tue 2 Oct 2007, 09:42 Delegate Sameer said...

Sameer has attended:
Excel VBA Intro Intermediate course

Excel VBA loops

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 ?

Fri 5 Oct 2007, 09:54 Trainer David said...

RE: Excel VBA loops

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000

View all Access hints and tips