The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Steps in vba

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Steps in vba

Resolved · Medium Priority · Version 2007

ReplyTue 16 Mar 2010, 10:08Delegate Aquila said...

Steps in vba

Hi

I want a macro to copy steps of rows eg, every 5th row. How would I write this?

For upcoming training course dates see: Pricing & availability

ReplyTue 16 Mar 2010, 16:48Trainer Anthony said...

RE: steps in vba

Hi Aquila, thanks for your query. Set up a loop down through your data (i.e. something like For NumRows = 1 To ....CurrentRegion.Rows.Count) and put "Step 5" at the end. Then within the loop put your copying code. That code will then only apply to every 5th row.

Hope this helps, let me know how you get on.

Anthony

ReplyWed 17 Mar 2010, 09:14Delegate Aquila said...

RE: steps in vba

yep thanks that works! Just had a look through our code last week, and saw it used there too. thanks again.

Access articles

· How To Change The Data Displayed In A Linked Field In An Access Table
· Access VBA Handling Errors and Debugging Code
· The Importance Of Backing Up In Access
· Want To Get Started With Macros In Microsoft Access?
· Sub-reports And Sub-forms In Access 2007

Please browse our web site to find out more about
access database microsoft training and other Microsoft training courses.

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

I'd like to buy one.