Drop Down List

H

Harddrive747

I have been able to create a drop down list using an SQL statement. It works
great, but I have a question of how to get a scroll bar to work with it.

I want it to have all the records in the drop down list, but I only want to
show say 5 or 6 at a time. Then be able to scroll down to find the rest.

Thanks for the help.
Terry
 
T

TJ

On the page with the Drop-Down.
Right click on the DD and select "Form Field Properties"

Middle Left the "Height:" box change the 1 to 5 ~ 6

TJ
|I have been able to create a drop down list using an SQL statement. It
works
| great, but I have a question of how to get a scroll bar to work with it.
|
| I want it to have all the records in the drop down list, but I only want
to
| show say 5 or 6 at a time. Then be able to scroll down to find the rest.
|
| Thanks for the help.
| Terry
 
H

Harddrive747

Tj, thanks for the reply. However, this isn't exactly what I'm looking for.

What I want to do is to keep one line showing in the drop down box. Then
when I click the down arrow, I want it to display a certain number of
records.

TJ, if you go to the following link and look in the upper right hand corner,
you will see United States and you click the down arrow, you will see what
I'm talking about.

http://www.adobe.com/products/acrobat/main.html

Thanks for your help.
Terry
 
K

Kathleen Anderson [MVP - FrontPage]

They are displaying all the entries when you click the down arrow, not just
5 or 6. I don't think that what you want can be done. The closest you can
get is to display 5 or 6 initially (instead of one).

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
 
T

TJ

Hi Terry,

Off hand I can't think of how to do what you are saying..
That page (when I used the Drop-Down) all were displayed except one. So the
scroll bar only moved one place. This might be a case of the area the
browser has to display the list.

My only thought (and I have no idea if this will work) is to try to modify
the code. (the grey code when in code view). As you most likely know the
group size is not available in the wizard (page5) But you might TRY to
change the code in code view (NOTE: after making the change save the page
while in code view or FP will change it back)
Look for:
i-maxrecords="256" i-groupsize="0"
Change to:
i-maxrecords="256" i-groupsize="6"

As I said I have no idea if that will work but it might?

TJ

| Tj, thanks for the reply. However, this isn't exactly what I'm looking
for.
|
| What I want to do is to keep one line showing in the drop down box. Then
| when I click the down arrow, I want it to display a certain number of
| records.
|
| TJ, if you go to the following link and look in the upper right hand
corner,
| you will see United States and you click the down arrow, you will see what
| I'm talking about.
|
| http://www.adobe.com/products/acrobat/main.html
|
| Thanks for your help.
| Terry
|
| "TJ" wrote:
|
| > On the page with the Drop-Down.
| > Right click on the DD and select "Form Field Properties"
| >
| > Middle Left the "Height:" box change the 1 to 5 ~ 6
| >
| > TJ
| > | > |I have been able to create a drop down list using an SQL statement. It
| > works
| > | great, but I have a question of how to get a scroll bar to work with
it.
| > |
| > | I want it to have all the records in the drop down list, but I only
want
| > to
| > | show say 5 or 6 at a time. Then be able to scroll down to find the
rest.
| > |
| > | Thanks for the help.
| > | Terry
| >
| >
| >
 
H

Harddrive747

TJ and everyone, I got my answer to this problem. The drop down list will
show everyone up to 20 records. Anything beyond that then you will
automatically get the scroll bar. My current table is at 20 records. I
tried one that had list 50 records and the scroll bar was there automatically.

Thanks for you help and TJ, about the groupsize to 6 caused only 6 records
to be returned.

So I eventually answered my own question :-D

Speaking of that, I still haven't gotten my duplicate record problem solved
yet.

Thanks again for the help.
Terry
 
T

TJ

| So I eventually answered my own question :-D
|
| Speaking of that, I still haven't gotten my duplicate record problem
solved
| yet.
============

What's that about... ???

TJ
 
T

TJ

Just guessing here, but what you might need is a Custom Query.
Copying from another Post (SELECT DISTINCT Query not working)
"SELECT DISTINCT Maincategory FROM Results"
"Results" being the table.. "Maincategory" the column (Field name)

This is the correct answer. For future reference, let me tell you why:

The DISTINCT Operator in SQL ensures that records that are identical are
combined into single records. Note that I said "records" not "columns." This
means that if you select more than one column in a record set, ALL columns
selected must be the same in order for 2 records to be combined. When you
use "SELECT *..." you are fetching ALL columns from the table, not just the
"Maincategory" column, and if, for example, that table has a primary key
field, such as an AutoNumber field, that field will not have the same value
in both records, and they will not be combined.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
I get paid good money to
solve puzzles for a living


-------------- Snip -------------------
|
| Speaking of that, I still haven't gotten my duplicate record problem
solved
| yet.

------------Snip----------------------
 
H

Harddrive747

TJ, if you take a look at the thread called duplicate records, it will tell
you what I'm trying to do.

So pick up that thread and I will continue it there.

Talk to ya.
Terry
 
Top