Posts tagged with 'loop', page 1 of 1

loop

Len or Loop

December 23, 2011 by JP

question image

So I decided to test another assumption of mine: that Len is the fastest method for checking the length of a string, and therefore if a string variable is empty. The next series of posts will explore that in more detail.

Filed Under: VBA

Tagged With: comparison test, For, Len, loop

List all MS Access queries in database

July 22, 2011 by JP

Comments

In my quest to optimize my Access queries, I wanted to view the underlying SQL for each query. However I have dozens of queries and manually examining each one is a hardship. Here's how I did it with VBA.

Filed Under: Access

Tagged With: loop, query, SQL

Processing multiple emails

August 25, 2008 by JP

1 Comment(s)

In Highlight And Move Multiple Emails, I demonstrated a technique for processing several emails at once and moving them to another folder. Here is another example that shows how you can save attachments from several selected emails, then delete them.

Filed Under: Outlook, VBA

Tagged With: loop, SaveAsFile