Tech Support

Join | Answer Questions | Sign In

Home | Business and Productivity Software | Is it possible to use...

Problem for Business and Productivity Software

Generic problem for all Business and Productivity Sof...

Is it possible to use a variable exp...

By Bushtrekker on Sep 12, 2008

" "

I want to place 100 different values for 100 different labels on a form. I can do it simply with the following loop, but VBA won't accept any syntax I have tried for the label name.
For CT = 1 to 100
[Forms]![F3-subject index]!["sn"&CT].Caption=valuearray(CT)
next CT
How can this loop be accomlished?

Comments:

Sep 12, 2008

- The solution didn't seem to address my problem

Sep 12, 2008

- This solution relates to excel. I am working with labels on an access form. Can my loop be performed in VBA or DAO for access? If so, what is the syntax?

Sep 12, 2008

- I already spent a day searching various forums and links such as the one you suggest. They do not address the particular question: "Can a variable be used in VBA to designate the label name on a form? If so, what is the syntax? IF not, can it be done in DAO? If so, what is the syntax?

Sep 12, 2008

- Coolguy008 suggests:
Dim lbl as label
lbl.Caption = "string"
[Forms]![F3-subject index]![sn5] = label
But, "sn5" in your solution is not a variable. I want to use a variable in the place of [sn5]. If this is a solution, you'll have to explain it to me.

Sep 12, 2008

- Yes, Suben, that is exactly what I did. But, that syntax doesn't work.

Ads by Google

Solution #1

posted on Sep 12, 2008

abhishek33

Rank: Master
Rating: 76%, 466 votes

- hi,,
- u could find the link.. for label name..
- www.functionx.com/vbaccess/Lesson09.htm

Was this helpful?

Yes

Solution #2

posted on Sep 12, 2008

suben

Rank: Wiz
Rating: 81%, 164 votes

try this
Dim lbl as label
lbl.Caption = "string"
[Forms]![F3-subject index]![sn5] = label

hope it works

Comments:

Sep 12, 2008

- or this
[Forms]![F3-subject index]!["sn"&CT].Caption=valuearray(CT)
next CT

Was this helpful?

Yes

Solution #3

posted on Sep 12, 2008

mohammed387

Rank: Master
Rating: 77%, 898 votes

download tis software and use it
Financial Excel All Programs Complete Edition

then check ur loop is correct in syntax

use tis below links for tutorial

http://www.lacher.com/toc/tutvba1.htm

http://www.blueclaw-db.com/access_createquerydef.htm

Was this helpful?

Yes

Solution #4

posted on Sep 12, 2008

coolguy008

Rank: Wiz Computers & Networking

Expert
Rating: 83%, 624 votes

HI,

Please click on the below link and go through the post.It will help you fix your problem.

http://www.dailydoseofexcel.com/archives/2006/12/04/writing-to-a-range-using-vba/

Comments:

Sep 12, 2008

- Please don't forget to accept the solution as fixya.

Sep 12, 2008

- Please don't forget to accept the solution as fixya.

Sep 12, 2008

- ok..please try out this syntax

Dim lbl as label
lbl.Caption = "string"
[Forms]![F3-subject index]![sn5] = label

I hope this will help and please don't forget to accept my solution.

Sep 12, 2008

- Did you already try this:

Dim lbl as label
lbl.Caption = "string"
[Forms]![F3-subject index]![sn5] = label

Was this helpful?

Yes

Solution #5

posted on Sep 12, 2008

maklean

Rank: Guru Computers & Networking

Expert
Rating: 86%, 654 votes

Have a look at some relative questions

Was this helpful?

Yes

This Problem Also Relates To: HP HP Integrated Lights Out (;iLO) Advanced Pack 1 server license Upgrade Version (452141-B21) Sony Media Software Pictures Sound Effects Series - Volumes 1 to 5 Volume License (SSDS2000) Sony Acid Music Studio 7 Full Version for PC (SAMS7000) Sony Acid Music Studio 7 for PC (MSAMS7000) Sony Acid Pro 6 Professional Music Workstation Full Version for PC Apple iWork 09 Family Pack Full Version for Mac Belkin Easy-Transfer Cable for Windows XP and Windows Vista Business English DVD for PC

Questions and Unsolved Problems for Business and Productivity

Business and Productivity Software

best software programme

Answer

I need to purchase a software programme that will enable me to scan or draw plans of buildings and... (More)

Business and Productivity Software

quicken 2001 deluxe

Answer

what are the disadvantages?

Microsoft Office Professional 2007 Full Version for PC

I NEED A MICOSOFT PUBLISHER 2007...

Answer

i need a micosoft publisher 2007 product key plzzzz

Visio Technical 4.5 Full Version for PC

i have a word file with flow chart...

Answer

i have a word file with flow chart which is made by visio software does not open in another... (More)

Intuit QuickBooks® Pro 2007 Full Version for Mac

fixing the reconcile date

Answer

fixing the reconcile date

Ads by Google

Didn't find what you were looking for?

Describe your Business and Productivity... problem:

Select a Category:

Get Immediate Assistance!

Related Products & Issues:

access f3 VB 6 0 A T V questions loop

See more Business and Productivity Software Problems

Answer this problem

Ask our Experts

Solve Your Problem Now!

Chat Live with an Expert

Chat Now

Top Business and... Experts

Geekman

Rank:

Guru

Expert

Rating:

85%, 2026 votes

budmrtn

Rank:

Guru

Expert

Rating:

88%, 340 votes

MrMark52

Rank:

Guru

Expert

Rating:

89%, 743 votes

Find more Business and... Experts

Top Computer & Laptop Repairmen
in Colton, CA

Zkarlo.com

(952) 890-7770

Zkarlo.com provides discount and used laptop parts...

LaptopOnCall Inc.

(513) 874-3306

We fix and repair laptop motherboard no video, no...

Get Listed!

Solve Your Problem Now!

Chat Live with an Expert

Chat Now

Solutions to Most Common Business and Productivity Software Problems See other Business and Productivity All Brands Find Tips Holiday

Browse Experts Popular & New Find Products Find Cars Find Manuals Find Warranty Service Plans Repair Service Directory Reviews & Ratings Tags

About FixYa News and Media Contact Terms Privacy Policy

Blog Advertisers Partners Careers FAQ

Click to verify BBB accreditation and to see a BBB report.

FixYa does not evaluate or guarantee the accuracy of any information provided through its proposed solutions, posts, or Expert Assistance Sessions. By entering this site you declare you read and agreed to its Terms. You may NOT copy or distribute the content that appears on this site without written permission from FixYa Ltd.
© 2005-2009, FixYa, Ltd. or its affiliates

What is this?

Solution

Clarification Request

Select

Share with your friends on Facebook

Add to My Products

Add the things you own to your My Products collection and get product information, solutions to problems, manuals & guides, tips and how-to's, reviews & ratings and local repair service - all in one easy place.