Solved

Visual Basic simple Question

Posted on 2004-04-12
7
194 Views
Last Modified: 2013-11-25
I have a question that has frustrated me while doing my homework. We do not get grades on it. I am 58 and taking it as a 'recreational' subject with the intention to know as much as possible.

I have a txtBox where one enters a Number. I then have a Summary Box which supposed to take the contents of the box and plases it on command into a lbl box. The intention is to accumulate numbers in the Summary box. For some reason it does not work. I can accumulate numbers from a lblbox to a lbl Box but from a txt Box to a lable summary box results in a blank entry.

The 'Sales' commands work as shown below:

Dim curWeeklySales As Currency
Dim SummaryWeeklySales1 As Currency
curWeeklySales = Val(txtWeeklySales)
lblSummaryWeeklySales1.Caption = FormatNumber(curWeeklySales) _
+ Val(lblSummaryWeeklySales1.Caption)

The following where out of frustration gave the cammand a number, resulted in a blank.

Dim curSummaryWeeklyPay1 As Currency
  lblSummaryWeeklyPay1.Caption = 10000 This results in a blank
 lblSummaryWeeklyPay1.Caption = Val(LblPay1.Caption) This also results in a blank

gonzal13(Joe)

0
Comment
Question by:gonzal13
7 Comments
 
LVL 11

Expert Comment

by:bingie
ID: 10810199
>>Dim curSummaryWeeklyPay1 As Currency
    lblSummaryWeeklyPay1.Caption = 10000 This results in a blank
    lblSummaryWeeklyPay1.Caption = Val(LblPay1.Caption) This also results in a blank

This works ok for me, are you sure the label names are correct?

Also where is LblPay1.Caption getting its value from? If its blank then lblSummaryWeeklyPay1 will be blank.

Can you post your whole code? i.e. Everything under the button click?
0
 
LVL 13

Author Comment

by:gonzal13
ID: 10810351
Please note that the last line of code istxt instead of lbl

   lblSummaryWeeklyPay1.Caption = Val(LblPay1.Caption) This also results in a blank

The above is the complete code for this mnu command

In frustration to see what would happen I forced lblSummaryWeeklyPay1.caption to = 10000

gonzal13(Joe)

Oh, since Microsoft introduced VB.net, the VB6 books can be had at 20 percent of their value on Amazon and half.com
0
 
LVL 19

Expert Comment

by:BrianGEFF719
ID: 10810849
Try this:

lblSummaryWeeklyPay1.Caption = Val(LblPay1.text) This also results in a blank


I know that doesnt make much sense because you have it defined as lblPay1.

But you said "Please note that the last line of code istxt instead of lbl"
I am assuming that you mean its a text box and not a label.


So to get text from a text box you can either do, Text1 or Text1.text.


Good Luck
-Brian
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 19

Accepted Solution

by:
BrianGEFF719 earned 50 total points
ID: 10810850
lblSummaryWeeklyPay1.Caption = Val(LblPay1.text)
0
 
LVL 19

Expert Comment

by:BrianGEFF719
ID: 10810851
lblSummaryWeeklyPay1.Caption = Val(LblPay1.text)
0
 
LVL 13

Author Comment

by:gonzal13
ID: 10815310
Hi:

I shall take your notes to the professor today (Tuesday)

my final version that does not work is
lblSummaryWeeklyPay1.Caption = Val(txtPay1.text)
0
 
LVL 1

Expert Comment

by:MortimerCat
ID: 10817891
lblSummaryWeeklyPay1.Caption = Val(txtPay1.text)

This should work, even if txtPay1.text is blank, the label would come out as zero.

Just a suggestion, have you made the Label forecolor the same as the backcolor? For example printing blue characters on a blue background.  Or have you made the label too small or too big, and the characters are falling of the form?

May I suggest you put some text into the caption properties at design time, just to prove you can see it.


0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now