Set a PM=Conn. Execute (" SELECT the username, credits FROM pre_common_member order BY credits DESC ")
Text1. Text=PM (" credits ")

The results can only display the biggest fraction in text1,
I want to make data can be displayed, at least in the first five,


Format is as follows:
How much credit the first username:
How much credit second username:
How much credit third username:
How much credit fourth username:
Fifth username: how many points

CodePudding user response:

 Dim As Long I 
Dim s As String 

Set a PM=Conn. Execute (" SELECT the username, credits FROM pre_common_member order BY credits DESC ") 

For I=1 To 5 
S=s & amp; "The first" & amp; Mid $(" 12345 ", I, 1) & amp; "Name" & amp; PM (" username ") & amp; ":" & amp; PM (" credits ") & amp; VbCrLf 
Next 
Text1. Text=s 

CodePudding user response:

Want to put five personal information on the same output text controls?
This is ugly.
Neatly to also is not not, but have to spend bit of idea on the length of the string concatenation, why don't you with form controls or list control directly?

CodePudding user response:

Thanks to the second floor, solved!!!!!!

CodePudding user response:

Don't red means like or not,,, because the output of the user name is the same, the integral is the same,,

CodePudding user response:

Next add words in front of the PM. MoveNext

CodePudding user response:

Thanks for a great,!!!!!!!!!! In addition to the points and how to give you good!! ,,,!!!!!!

Buy snacks to you bad

Qq 379666389