VB old problem, I haven t found it for a long time

Variant data, a very special type of data, can be stored in many things.

1: dim arrx (2) as variant arr(2) 3 elements, but element 0 is not used.

2: What does arrx (1) (2) mean?

The arrx (1) variant element is given an array countersa ()arrx (1) (2) which represents the number of the array with a subscript of 2 (i.e., countersa (2)) in the arrx array with a variant element with a subscript of 1 (i.e., arrx (1)), so msgbox arrx (1) (2) is displayed as 5

What does arrx (2) (3) mean? I don't understand!

The same goes for the above.

You can define dim arrx (1 to 2) as variant in this way, so that the subscripts are 1 and 2, and you can think of a few as many.

There are 3 elements in dim arrx(2) as variantarrx(2), which are arrx(0), arrx(1), and arrx(2).

The second question must be that the landlord wrote it wrong! arrx(1)(2) does not allow this format in VB!

msgbox( arrx(1) &arrx(2) )'The full array name must be written.

This is a recursive function, and you have to look at it layer by layer.

text1=disp(s,len(s)) is called disp(s,6),6>1, so it is recursive to disp(s,1), then the if condition is not established, and the recursion depth is in the end.

The first result is.

Note that s is addressed, s=vlausi goes back to the previous level, has changed, s=v+i+laus=vilaus and then up.

Back to the top floor. At this point, disp returns, text1="visual" 。

All caps.

I know vlausi.,But how to run it again.,My f8 single-step execution.,I found that the disp end function came 5 times again.。。。 So I can't figure it out ... Ask God for an answer.

The key is that the mid(s,l,len(s)-l) is an invalid character.

There is an invalid qualifier in it.

** Below:

private sub cmd1_click()for i=1 to 1000

cmd2_click

nextend sub

It is recommended that you abstract the ** to be executed in cmd2 click() into a separate sub, and then call this sub in cmd1 click().

Write a separate method for ** to be executed by button b, execute this method when button b is pressed, and loop 1000 times when button A is pressed.

private sub et()

msgbox "2aaa"

end sub

private sub cmd1_click()for i=1 to 1000

etnext

end sub

private sub command2_click()etend sub

with"order by"

It is recommended that your table header should not be in Chinese, otherwise it will not be very convenient.

This like is originally a fuzzy match for string types, but what is the point of using like for numeric and date data?

micro0369 Friend is right, three kinds of data suitable for the comparison of the operation symbol!

I would like to remind you that for date-type fields, you should pay attention to the !! when performing relational operations

We all know that for string types, use single quotes, for example:

select * from table name where name='Zhang San'"

select * from table name where name='" & "'"

For date types, you need to use a pound sign, i.e. a symbol, for example:

select * from table name where date of birth >=

select * from table name where date of birth >=" & cdate( &"#

Determine the data type, and then spell it into an SQL

integers:fields can be used with = > = <= value characters with like = > = <='value'

Date can = > = < = date value.

Convert all fields into character type data, and then, the values that come in later are also converted into characters, and you're good to go.

s = select * from translate where " a + b + order by " d

This refers to the following:

s = select * from translate where "A + Jianchang + B + Order by" d

In other words, both sides of b need to be marked with single quotation marks.

The second or misspelled into ro.

The string combination is a bit messy, you can set a breakpoint to check whether the string combination effect is correct when interrupting.

You're right.,Press the first display "11", "2 seconds" and then wait for 2 seconds and then display "22", but,Because you don't have control back in the program.,The display starts to execute the next command without refreshing.,As a result, the program doesn't get control.,All are not displayed.,When the program ends and then displays,It becomes "2 seconds" and "22" are displayed together,That:

Modify it to see it:

static sub delayloop(delaytime)loopfinish = timer + delaytimedo while timer < loopfinishloop

end sub

private sub form_click()print "11"

print "2 seconds"

doevents 'This is the key !! Put control back into the system so you can see the results.

call delayloop(2)

print "22"

end sub

This kind of loop takes up the CPU too much, it is similar to an endless loop, and it cannot be used in programming at all, that is, it appears in the homework or presentation of a boring teacher in teaching.

It's so bad that I can't print out the text properly.