กระทู้เก่าบอร์ด อ.สุภาพ ไชยา
320 3
URL.หัวข้อ /
URL
Sample: Jumping to a record as letters are typed in a text box.
ถามไว้ที่
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=access_2000&Number=110814&page=0&view=collapsed&sb=5&o=7&fpart=1
ดังนี้
Hi,
I would like to make a form with a list box (?) showing all the records available
in the database, with a text box on top. As letters are being typed into the text
box, I would like the 'record selector' or the 'cursor' to jump to the first record
that matches what is being typed. I saw this on another program made in
access and would like to do something similar.
The only way I can think of to do this right now is to run an SQL statement
everytime there is a keypress event in the text box, so the number of records in
the list box gets smaller and smaller (as it's being filtered by the 'where' clause).
But is there a way to do it so all the records remain but the cursor just jumps to
the specified record?
I thought about combo boxes, but I will have over 500 records so I don't know if
this is a good route, and also I have heard that combo boxes don't start
jumping until the letters typed match the first unique record. I would like it so that
as soon as one letter is typed it will jump to the first of its kind.
-- Sabrina
ดูตัวอย่างดีกว่าไม่ต้องแปล ที่ http://www.utteraccess.com/forums/uploads/111010-db4.mdb
โดยคุณ Jeff
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=access_2000&Number=110814&page=0&view=collapsed&sb=5&o=7&fpart=1
ดังนี้
Hi,
I would like to make a form with a list box (?) showing all the records available
in the database, with a text box on top. As letters are being typed into the text
box, I would like the 'record selector' or the 'cursor' to jump to the first record
that matches what is being typed. I saw this on another program made in
access and would like to do something similar.
The only way I can think of to do this right now is to run an SQL statement
everytime there is a keypress event in the text box, so the number of records in
the list box gets smaller and smaller (as it's being filtered by the 'where' clause).
But is there a way to do it so all the records remain but the cursor just jumps to
the specified record?
I thought about combo boxes, but I will have over 500 records so I don't know if
this is a good route, and also I have heard that combo boxes don't start
jumping until the letters typed match the first unique record. I would like it so that
as soon as one letter is typed it will jump to the first of its kind.
-- Sabrina
ดูตัวอย่างดีกว่าไม่ต้องแปล ที่ http://www.utteraccess.com/forums/uploads/111010-db4.mdb
โดยคุณ Jeff
3 Reply in this Topic. Dispaly 1 pages and you are on page number 1
1 @R01416
อยากได้ตัวอย่างนี้ค่ะ แต่ link ที่ให้มามันเข้าบ่อได้แล้วอ่ะค่ะ
ท่านอาจารย์สุภาพยังพอมีอยู่หรือเปล่าคะ หรือท่านอื่นๆ ก็ได้ค่ะ
ถ้ามีตัวอย่าง ขอดูมั่งได้อ๊ะเปล่าคะ
ขอบคุณค่ะ
2 @R01417
ให้เข้าไปดูกระทู้ต้นสังกัดที่ว่าได้ที่
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=access_2000&Number=111032&Forum=CatSearch-2&Words=--%20Sabrina&Match=Entire%20Phrase&Searchpage=0&Limit=25&Old=6months&Main=110814&Search=true#Post111032
หรือเอาตัวอย่างที่ http://www.utteraccess.com/forums/download.php?Number=111010 ดูใหม่นะครับ
3 @R01418
d/l ได้แล้วค่ะ แต่ไม่มี access2000
ขอบพระคุณมากค่ะ
ขออนุญาตตั้งกระทู้ใหม่นะคะ
ลองทำมาหลายชั่วโมงแล้ว แต่ไม่สำเร็จ
เรื่องการทำ filter และ combo box
Time: 0.1212s