473,320 Members | 1,859 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

graduation project and I really need help

16
Hello

I have a drop down list that retrieves data from a data base.
Under that I have a textbox that I want to retrieve information also from the database depending on the previously selected item.

For example, if i select "Computer" from the dropdown list, the textbox should display "PC".

This is part of my graduation project and I really need help.
Thanks
Mar 13 '07 #1
3 1080
vijaydiwakar
579 512MB
Hello

I have a drop down list that retrieves data from a data base.
Under that I have a textbox that I want to retrieve information also from the database depending on the previously selected item.

For example, if i select "Computer" from the dropdown list, the textbox should display "PC".

This is part of my graduation project and I really need help.
Thanks
So.......
Where is the problem.........?
just fire one qry which will retrive related data from db wrt id stored in combobox
Mar 13 '07 #2
ummaria
16
So.......
Where is the problem.........?
just fire one qry which will retrive related data from db wrt id stored in combobox
I did that, but I dont seem to get the write code on the event handler for the combobox
Mar 13 '07 #3
cmrhema
375 256MB
I did that, but I dont seem to get the write code on the event handler for the combobox
Write down the code in the combo click event or combo keyup event
MyRs.Open "select id from details where name=" & Trim(Combo1.Text), MyCon, adOpenDynamic, adLockOptimistic
Text1.Text = Trim(MyRs("id"))
MyRs.Close

I presume you are using ADO connection
Here Myrs is the recordset, Mycon is the connection
details is the name of the table
name is the field which will be populated in your combobox which contains computer etc
id is the field which should be retrieved which contains PC etc
Change accordingly to your respective field and see whether you succeed. Next time onwards kindly put on the code.
Mar 13 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

51
by: nospam | last post by:
THIS IS the DOTNETJUNKIES MESSAGE ------------------------- We're Sorry As many of you know we have recently launched SqlJunkies.com. We have overhauled our runtime and will be using it on...
15
by: cody | last post by:
We have a huge project, the solutuion spans 50 projects growing. Everytime I want to start the project I have to wait nearly over 1 minute for the compiler to complete building. This is...
18
by: JKop | last post by:
Here's what I know so far: You have a C++ project. You have source files in it. When you go to compile it, first thing the preprocessor sticks the header files into each source file. So now...
10
by: TokiDoki | last post by:
Hello there, I have been programming python for a little while, now. But as I am beginning to do more complex stuff, I am running into small organization problems. It is possible that what I...
6
by: JonSteng | last post by:
..Net Visual Studio Professional 2003 Version 7.1.3088 ..Net Framework 1.1 SP1 Version 1.1.4322 IIS 5.1 Windows XP Professional SP2 Micron T3000 Laptop (1.5 GHz; 1GB RAM; 40GB HD with 17GB Free)...
3
by: Jerad Rose | last post by:
This is regarding Visual Studio 2003 (framework 1.1). We have several projects/libraries. Of course, many of these reference each other. If we only had one solution, we would simply add all of...
0
by: gunimpi | last post by:
http://www.vbforums.com/showthread.php?p=2745431#post2745431 ******************************************************** VB6 OR VBA & Webbrowser DOM Tiny $50 Mini Project Programmer help wanted...
24
by: =?Utf-8?B?RHIuIFMu?= | last post by:
I am incorporating three existing programs into a new "all in one" program. I have added the three projects to the new all in one project. How do I instruct the new initial menu to launch the main...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.