(952) 890-7770
Zkarlo.com provides discount and used laptop parts...
Answer
need the key for the microsoft 2007
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?
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 problemSep 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.Solution #1
posted on Sep 12, 2008
-
- hi,,
- u could find the link.. for label name..
- www.functionx.com/vbaccess/Lesson09.htm
- thank u sir..
Yes
No
Solution #2
posted on Sep 12, 2008
try this
Dim lbl as label
lbl.Caption = "string"
[Forms]![F3-subject index]![sn5] = label
hope it works
[Forms]![F3-subject index]!["sn"&CT].Caption=valuearray(CT)
next CT
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
Yes
No
Solution #3
posted on Sep 12, 2008
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
Yes
No
Solution #4
posted on Sep 12, 2008
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/
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.
Dim lbl as label
lbl.Caption = "string"
[Forms]![F3-subject index]![sn5] = label
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 syntaxDim 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
Yes
No
This Problem Also Relates To:
Sony Acid Music Studio 7 for PC (MSAMS7000)
Sony American Idol Extreme Music Creator Promo/Demo License for PC (2205808)
Apple iPlayMusic Beginner Guitar Lessons Full Version for Mac
Apple Mac OS X 10.4 Tiger Full Version for Mac (MA453ZA)
Belkin Easy-Transfer Cable for Windows XP and Windows Vista Business English DVD for PC
Encore The Print Shop 23 Deluxe Full Version for PC
Microsoft Access 2000 (077-01277) for PC
Popular Solutions for Business and Productivity
Questions and Unsolved Problems for Business and Productivity
Answer
I have XP and QuickBooks Pro 2007. QuickBooks PDF Converter shows up with my printers, but when I...
(More)
Answer
ddy79-433jv-2rxgx-mqfqp-pfdh8 The above code worked. I had used Magic Jelly Bean but it only gave me...
(More)
Answer
is textbridge 98 compatible with vista please?
Answer
how to integrate zinc6.1 with Tornado 2.2 IDE
Sponsored Links
Ask our Experts
Browse popular Problems
More Common Problems
Most Common Problems for:
For Business and Productivity...:
Related Products & Issues:
Top Business and Pro... Experts
Experience:
Experienced a lot in computer troubleshooting.
Knowledgeable about cellular phones.
Ask Me
Top Computer & Laptop Repair
