Click here to Skip to main content
16,005,734 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralVariables, <>, and IF Statements Pin
Anonymous21-Apr-05 5:34
Anonymous21-Apr-05 5:34 
GeneralRe: Variables, <>, and IF Statements Pin
Dave Kreskowiak21-Apr-05 6:32
mveDave Kreskowiak21-Apr-05 6:32 
GeneralRe: Variables, <>, and IF Statements Pin
Anonymous21-Apr-05 6:49
Anonymous21-Apr-05 6:49 
GeneralRe: Variables, <>, and IF Statements Pin
Dave Kreskowiak21-Apr-05 7:30
mveDave Kreskowiak21-Apr-05 7:30 
GeneralRe: Variables, <>, and IF Statements Pin
Anonymous22-Apr-05 6:52
Anonymous22-Apr-05 6:52 
GeneralCR Help Pin
vertig073021-Apr-05 4:38
vertig073021-Apr-05 4:38 
GeneralRe: CR Help Pin
Jim Matthews21-Apr-05 5:20
Jim Matthews21-Apr-05 5:20 
GeneralRe: CR Help Pin
vertig073021-Apr-05 5:46
vertig073021-Apr-05 5:46 
Ok you asked for it

This converts decimals to fractions for reporting but when you have a whole number with out a decimal it display X 1/1 behind it and i am trying to only display the whole number in that case. Good Luck

NumberVar Dec;
NumberVar Zeroes;
NumberVar Denom;
NumberVar Numerator;
NumberVar Whole;
NumberVar CommonDenom;
StringVar StringDec;
StringVar FinalNumerator;
StringVar FinalDenom;
StringVar Fraction;

//Initialize the Decimal.
Dec := CDbl ({PROPOSAL.HEIGHT});

//Convert the Integer to a String to retrieve the Decimal value.
StringDec := ToText (Dec - (Truncate (Dec)), 10);

//Remove the trailing zeroes and get the exponent.
If StringDec [12] <> "0" then
Zeroes := 10;

If StringDec [12] = "0" then
Zeroes := 9
Else Zeroes := Zeroes;

If StringDec [12] = "0" and
StringDec [11] = "0" then
Zeroes := 8
Else Zeroes := Zeroes;

If StringDec [12] = "0" and
StringDec [11] = "0" and
StringDec [10] = "0" Then
Zeroes := 7
Else Zeroes := Zeroes;

If StringDec [12] = "0" and
StringDec [11] = "0" and
StringDec [10] = "0" and
StringDec [9] = "0" Then
Zeroes := 6
Else Zeroes := Zeroes;

If StringDec [12] = "0" and
StringDec [11] = "0" and
StringDec [10] = "0" and
StringDec [9] = "0" and
StringDec [8] = "0" Then
Zeroes := 5
Else Zeroes := Zeroes;

If StringDec [12] = "0" and
StringDec [11] = "0" and
StringDec [10] = "0" and
StringDec [9] = "0" and
StringDec [8] = "0" and
StringDec [7] = "0" Then
Zeroes := 4
Else Zeroes := Zeroes;

If StringDec [12] = "0" and
StringDec [11] = "0" and
StringDec [10] = "0" and
StringDec [9] = "0" and
StringDec [8] = "0" and
StringDec [7] = "0" and
StringDec [6] = "0" Then
Zeroes := 3
Else Zeroes := Zeroes;

If StringDec [12] = "0" and
StringDec [11] = "0" and
StringDec [10] = "0" and
StringDec [9] = "0" and
StringDec [8] = "0" and
StringDec [7] = "0" and
StringDec [6] = "0" and
StringDec [5] = "0" Then
Zeroes := 2
Else Zeroes := Zeroes;

If StringDec [12] = "0" and
StringDec [11] = "0" and
StringDec [10] = "0" and
StringDec [9] = "0" and
StringDec [8] = "0" and
StringDec [7] = "0" and
StringDec [6] = "0" and
StringDec [5] = "0" and
StringDec [4] = "0" Then
Zeroes := 1
Else Zeroes := Zeroes;

If StringDec [12] = "0" and
StringDec [11] = "0" and
StringDec [10] = "0" and
StringDec [9] = "0" and
StringDec [8] = "0" and
StringDec [7] = "0" and
StringDec [6] = "0" and
StringDec [5] = "0" and
StringDec [4] = "0" and
StringDec [3] = "0" Then
Zeroes := 0
Else Zeroes := Zeroes;

//Initialize the Denominator and Numerator.
Denom := Expo (10,Zeroes);
Numerator := ToNumber (StringDec [3 to (Zeroes + 2)]);


//Calculate the lowest common Denominator and Numerator.
If Dec - Truncate (Dec) = 0 Then
(Numerator := 1;
Denom := 1;)
else If Remainder (Numerator, 1250) = 0 Then
(Numerator := Numerator / 1250;
Denom := Denom / 1250;)
else If Remainder (Numerator, 625) = 0 Then
(Numerator := Numerator / 625;
Denom := Denom / 625;)
else If Remainder (Numerator, 25) = 0 Then
(Numerator := Numerator / 25;
Denom := Denom / 25;)
else If Remainder (Numerator, 5) = 0 Then
(Numerator := Numerator / 5;
Denom := Denom / 5;)
else if Remainder (Numerator, 2) = 0 then
(Numerator := Numerator / 2;
Denom := Denom / 2);


//Calculate the final values for the Numerator and Denominator.
If Remainder (Denom, Numerator) = 0 Then
(FinalNumerator := ToText ((Numerator / Numerator), 0);
FinalDenom := ToText ((Denom / Numerator), 0))
else (FinalNumerator := ToText (Numerator, 0);
FinalDenom := ToText (Denom, 0));

//Build the Fraction
Whole := (Truncate (Dec));
If Whole = 0 Then
FinalNumerator + "/" + FinalDenom
else
ToText (Whole, 0) + " " + FinalNumerator + "/" + FinalDenom;

James Kennelly
GeneralRe: CR Help Pin
Jim Matthews21-Apr-05 8:04
Jim Matthews21-Apr-05 8:04 
GeneralRe: CR Help Pin
vertig073021-Apr-05 8:21
vertig073021-Apr-05 8:21 
Questionhow to use the WMA codec in my application? Pin
ndanya20-Apr-05 23:20
ndanya20-Apr-05 23:20 
GeneralPowerpoint Event Handling using VBA Pin
Mohan vijay20-Apr-05 23:02
Mohan vijay20-Apr-05 23:02 
GeneralRe: Powerpoint Event Handling using VBA Pin
Dave Kreskowiak21-Apr-05 7:48
mveDave Kreskowiak21-Apr-05 7:48 
GeneralRe: Powerpoint Event Handling using VBA Pin
Mohan vijay22-Apr-05 6:19
Mohan vijay22-Apr-05 6:19 
GeneralRe: Powerpoint Event Handling using VBA Pin
Dave Kreskowiak23-Apr-05 2:48
mveDave Kreskowiak23-Apr-05 2:48 
GeneralRe: Powerpoint Event Handling using VBA Pin
Mohan vijay25-Apr-05 2:35
Mohan vijay25-Apr-05 2:35 
GeneralFind the subfolder of the Outlook calendar Pin
M.Ilangovan20-Apr-05 22:16
M.Ilangovan20-Apr-05 22:16 
GeneralPicture box image brightness, contrast, saturation adjustments Pin
Member 176653520-Apr-05 21:15
Member 176653520-Apr-05 21:15 
GeneralAlgorithm Pin
Jaymahinda20-Apr-05 19:17
Jaymahinda20-Apr-05 19:17 
GeneralRe: Algorithm Pin
Christian Graus20-Apr-05 20:21
protectorChristian Graus20-Apr-05 20:21 
GeneralRe: Algorithm Pin
Anonymous21-Apr-05 6:54
Anonymous21-Apr-05 6:54 
GeneralProgrmming the sound card Pin
Jaymahinda20-Apr-05 19:02
Jaymahinda20-Apr-05 19:02 
GeneralRe: Progrmming the sound card Pin
ndanya21-Apr-05 0:00
ndanya21-Apr-05 0:00 
GeneralAccessing dynamically added textbox Pin
nidhishri20-Apr-05 18:03
nidhishri20-Apr-05 18:03 
GeneralRe: Accessing dynamically added textbox Pin
Christian Graus20-Apr-05 18:35
protectorChristian Graus20-Apr-05 18:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.