whats lower than or equals to if statement? <= not working :<

B

Brendan Reynolds

h3llz said:
whats lower than or equals to if statement? <= not working :<
Click to expand...


<= is the correct syntax for less then or equal to in VBA. Perhaps if you
post the actual code that's not working for you, some one may be able to see
what the problem is.

The data-type of the variables or constants being compared may make a
difference, too. Numbers or dates may not always compare the way you might
expect if they are being compared as text.
 
H

h3llz

i = "1"
Do While i < (QryDat.Fields.Item("quantity") + 1)
cmoSelectQuantity.AddItem i
i = (i + 1)
Loop
i used the qrydat once, maybe can only use the same field once? first time
 
H

h3llz

thanks anyway, i found the problem, im using txtProductQuantity.Caption for
the highest point
 
B

Bob Quintal

i = "1"
Do While i < (QryDat.Fields.Item("quantity") +
1)
cmoSelectQuantity.AddItem i
i = (i + 1)
Loop
i used the qrydat once, maybe can only use the same field once?
first time on vb =] (i know php, html etc)
Click to expand...

You are setting the value of the variable i to a string containing
one instance of ascii character 49, not the number 1.

change to i = 1
 
Top