By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,829 Members | 670 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,829 IT Pros & Developers. It's quick & easy.

Drop down table

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
"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...
Nov 12 '05 #3

P: n/a
"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.
Nov 12 '05 #4

P: n/a
"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...
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.