Drop down table

[Vegard H. Villmones]

Hi.

I have a table containing a list of about 5000 numbers, and there is also in
existence one MSWord document for everyone of them numbers. I want to create
some sort of drop down menu (in a form) where when you click on each item in
the menu (consisting of the numbers) MSWord opens the document assosiated
with that number. Now it's the first part I'm curious about, the part with
opening Word is okay. Suggestions?

Vegard

[John Sheppard]

test
"Vegard H. Villmones" <vv******@c2i.net> wrote in message
news:5V*******************@news4.e.nsc.no...

Hi.

I have a table containing a list of about 5000 numbers, and there is also in existence one MSWord document for everyone of them numbers. I want to create some sort of drop down menu (in a form) where when you click on each item in the menu (consisting of the numbers) MSWord opens the document assosiated
with that number. Now it's the first part I'm curious about, the part with
opening Word is okay. Suggestions?

Vegard

[Pieter Linden]

"Vegard H. Villmones" <vv******@c2i.net> wrote in message news:<5V*******************@news4.e.nsc.no>...

Hi.

I have a table containing a list of about 5000 numbers, and there is also in
existence one MSWord document for everyone of them numbers. I want to create
some sort of drop down menu (in a form) where when you click on each item in
the menu (consisting of the numbers) MSWord opens the document assosiated
with that number. Now it's the first part I'm curious about, the part with
opening Word is okay. Suggestions?

Vegard

you mean a combobox or a multiselect listbox? populating a combobox
or a listbox with that many values is going to render your form pretty
unusable... you recognize that, right? I'd have an unbound textbox
that filtered the combo/listbox so I only got less than 20 values.
Otherwise, it's just a horrible design. Opening word is easy...

[Vegard H. Villmones]

"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf*************************@posting.google.co m...

"Vegard H. Villmones" <vv******@c2i.net> wrote in message news:<5V*******************@news4.e.nsc.no>...

I have a table containing a list of about 5000 numbers, and there is also in existence one MSWord document for everyone of them numbers. I want to create some sort of drop down menu (in a form) where when you click on each item in the menu (consisting of the numbers) MSWord opens the document assosiated with that number. Now it's the first part I'm curious about, the part with opening Word is okay. Suggestions?

you mean a combobox or a multiselect listbox?
I probably do yeah.
populating a combobox
or a listbox with that many values is going to render your form pretty
unusable... you recognize that, right?
I do I do.
I'd have an unbound textbox
that filtered the combo/listbox so I only got less than 20 values.
Otherwise, it's just a horrible design. Opening word is easy...

Anyways, I used a "list" to list all the numbers (with a query as source),
and on the doubleclick event word opens a document for the number dbl
clicked on. It doesn't look that pretty though. And the scrolling, in this
list, is kind of weird - if I drag the scroll bar to the bottom, it doesn't
go to the last record, instead it jumps up again (some 1/5 up), and I have
to drag it down like 5 times before it arrives at the bottom record.

[Pieter Linden]

"Vegard H. Villmones" <vv******@c2i.net> wrote in message news:<Ta*******************@news4.e.nsc.no>...

"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf*************************@posting.google.co m...

"Vegard H. Villmones" <vv******@c2i.net> wrote in message

news:<5V*******************@news4.e.nsc.no>...

I have a table containing a list of about 5000 numbers, and there is also in existence one MSWord document for everyone of them numbers. I want to create some sort of drop down menu (in a form) where when you click on each item in the menu (consisting of the numbers) MSWord opens the document assosiated with that number. Now it's the first part I'm curious about, the part with opening Word is okay. Suggestions?

you mean a combobox or a multiselect listbox?

I probably do yeah.

populating a combobox
or a listbox with that many values is going to render your form pretty
unusable... you recognize that, right?

I do I do.

I'd have an unbound textbox
that filtered the combo/listbox so I only got less than 20 values.
Otherwise, it's just a horrible design. Opening word is easy...

Anyways, I used a "list" to list all the numbers (with a query as source),
and on the doubleclick event word opens a document for the number dbl
clicked on. It doesn't look that pretty though. And the scrolling, in this
list, is kind of weird - if I drag the scroll bar to the bottom, it doesn't
go to the last record, instead it jumps up again (some 1/5 up), and I have
to drag it down like 5 times before it arrives at the bottom record.

you might not want to requery the list until you've entered like 3-5
characters in the combobox. otherwise, your list is gonna requery
like mad and you're going to get too many values in it to make it
useful. Do something like check the length of the text entered in the
textbox andthen requery the listbox. That might make the thing more
useable... and if that doesn't work, take Trevor's advice and
influence it with a hammer...