How to set a fixed number of data to be displayed in a row in a list box

Do you want to display several rows of data at the same time, or do you want to implement the next row of data in a text box at the touch of a button?

By default, the data obtained through the member variable m column is the first data of the column, so it is also the first data to be displayed;

If I want to show data in other rows, I know how to use a filter:

request data using id as filter

bool cisoview::frequery(const int& id)

The m idparam in this paragraph is the parameter that plays the role of filtering; Since there is usually a column of automatic ID in a data table of access, the ID can be used to uniquely locate the data of a certain row, so assign the id to m idparam to filter out the desired row of data.

Suppose the id of the second row of data is 2, then just assign 2 to m idparam, and use m idparam as a filter parameter to m strfilter ="[id] = ?"In this filter, the requery() function is called again, and the m column can get the data in the second row of the column column.

Right-click -Generator on the drop-down list box, select the corresponding table, and select the name field in the field to add to the right.

Then add ** to the click or interactivechange event in the drop-down list box, for example:

c1=alltrim(

sele * from table name where name=c1 into cursor"temp"

temp"&&& Put the results of the query into the control.

Select the row you want to display, right-click - > Data Actions - > set the current value as the default value, and you're done!

Assign a value to its property node or a local variable, 0 for the first row, 1 for the second line...

1. Copying.

Open the excel sheet, and the data is shown in the figure below. According to the material in column A, the density can be automatically found in the DUC:D column search area and displayed in column B.

2. First select the B2 cell, and enter the formula =vlookup() in this cell.

3. Select the cell where the value you want to find is located, for example, the one you need to find is mild steel, which is also A2, and then enter ","

4. Also enter the value of another cell that needs to be found at the end, that is, columns c and d.

5. After entering d, enter the column number containing the return value.

6. Then continue to enter 0 false in the back for an exact search (enter 1 ture for an approximate match).

7. After the input is completed, you can press the enter key on the keyboard.

8. After the result is obtained, place the mouse on the dot in the lower right corner of cell B2 to make the cursor become a crosshair.

9. Drag the cursor down to fill in.

10. In this way, you can make the effect of automatically bringing out the relevant data in another column after selecting the data in the drop-down list box.

Create an Excel sheet.

1.Clause. 1. Set the format information of the record table.

2. Create another word list in excel, which indicates the fixed items.

2.Set the excel drop-down menu item.

3.When column A is selected in the record table, the following columns are automatically changed.

Click on the grid C2 that needs to be changed, select the function vlookup (search and guidance), select A2 corresponding to C2 in the first box "Any", add "$" in front of A2, select the value in the reference attachment table in the second box, select C to F columns, and then add "$" in front of C, select the number "2" in the third box, and enter the number "0" in the fourth box. Representative: When you enter information in A2, you will find the same value as A2 in the attachment condition table, and column C2 will automatically reference the value of the second column corresponding to the attachment condition item.

4.After column A is selected in the record table, the next column is automatically changed, and the third column is automatically changed.

When C2 is set, select C2 and drag it back with the mouse, and then change the penultimate item "2" in the function to "3" and "4" (this value can be changed according to the value in the attachment table), when the back columns are set, directly select A2:E2, and drag it down with the mouse.

5.Check if the settings are correct.

Select an input from the drop-down menu in box A2 and see that the following column changes and compares with the "Attachments" table, which means that this function is set up.

du to all corresponding values.

The exact implementation depends on your data structure.

Under this structure of the landlord, the taxpayer identification number B6 is entered into the formula:

vlookup(b8,i:j,2,0).

**Can not see clearly.

However, for this kind of problem, there must be a data source table, that is, the question of where the data comes from Secondly, the vlookup function is generally used, and it is really not possible to check the usage, upload it clearly**, I will help you write the formula.

Do you want to display data in a drop-down list box in pb?

Two conditions must be met:

1. There is this data in the following list box, use ddlb to implement 2, and set ddlb to this data.

Just meet the above two conditions.

ddlb under the constructor event:

int li_list

li_list = 1

DDLB displays the first data when it is first opened.

This shouldn't affect you, you can use the property node-item name of the multi-column list box to connect a two-dimensional array of strings.

If you want to output five variables in one line, you can use the upstairs method.

a & " " & b & " " & c & " " & d & " " & e

If you want to output five rows inside an array, that's it:

arr is an array.

The listbox is a list box.

sub outputfiveperline(arr, listbox as listbox)

dim i as long, buffer as string

for i = lbound(arr) to ubound(arr)

buffer = buffer & arr(i) &" "

if (i - lbound(arr)) mod 5 = 4 then

buffer

buffer = ""

end if

nextend sub

One of the drawbacks of this function is that if the array size is not a multiple of 5, the rest will not be output.

.Version 2

Support for the library iext

i 0a super list box shop. Take the number of table entries ().

The first count cycle (a 1, i).

Contract Termination Date Superlist Box for Stores. Take the header (i, 4) to join the members (date array, contract termination date).

Expiration Date Array [i].

Superlist Box Shops. Set the header (i-1, 5, result array [i])i i 1

Counting cycle tail ().

The index of the superlist box starts from 0.

I don't quite understand what you mean, are you trying to get the number of superlist boxes? Super list box. Take the number of table entries ().

If not, please ask.