Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-02 : 09:03:51
|
| Anna writes "Hi, I'm a student at a University trying to work on a minor database project which will later be program with visual basic.This is probably not a tough ? for your team, but it's definitely tough for me. On Access you can create a combo box (drop down menur) in order for you to make selections. On my project I have to do that, but I searched and searched on several SQL books and I just can't seem to find the way to do it.I came to the conclusion that doesn't exist for SQL am I right?If not can you please suggest a book that can help me or better yet tell me how to approach this problem. Thanking you in advance!Anna" |
|
|
Jay99
468 Posts |
Posted - 2002-04-02 : 10:08:12
|
| SQL Server establishes the data tier of an application, not the presentation layer. Access provides both data and presentation functionality.Access is kinda like a bicycle. You can hop on, peddle, turn, break and even do wheelies. SQL Server is more like a 800+HP Formula 1 race engine. By itself, it just sits there in its crate. It must be coupled with other tools to win a race.There is no SQL Server combo-box.Jay<O> |
 |
|
|
yakoo
Constraint Violating Yak Guru
312 Posts |
Posted - 2002-04-02 : 10:22:30
|
| If the presentation is going to be in a VB form you can use an ADO recordset to retireve data from your SQL/Access backend and then add those to your combo box.Add your combo box to your form.Then use the function AddItem to add the information to your combo box.it would be .AddItem(Item as string, [Index])Or you can look at the Properties DataField, DataFormat, DataMember, and DataSource to bind the records from a DB to the combo box. Take a look at VB help files instead of SQL BOL. This seems to be a VB question more than a SQL question. |
|
|
|
|
|
|
|
|
SQL (drop down menu????)