Datacontrol / Combo-box

Hi again guys,

Just some help wanted for my project I have Googled this and had many attempts just don’t be able to seem to get my head around it, I have a form with a data control linked to access 2003 and a combo-box when I load the form the combo-box is populated with the data from the data control but I want to know if it is possible to select an item from the dropdown box and then the data control jumps to that item. Making it possible to view stock levels for that particular item on separate captions.

Thanks

Oct 8 '07 #1

Subscribe Post Reply

1311

jrtox

Hi again guys,

Just some help wanted for my project I have Googled this and had many attempts just don’t be able to seem to get my head around it, I have a form with a data control linked to access 2003 and a combo-box when I load the form the combo-box is populated with the data from the data control but I want to know if it is possible to select an item from the dropdown box and then the data control jumps to that item. Making it possible to view stock levels for that particular item on separate captions.

Thanks

Hello,

Yeah its possible.
just build Query in which you SELECT a ReCord from Database WHERE field is equal to your combo box.

Expand|Select|Wrap|Line Numbers

SELECR * FROM TableName WHERE FieldName='" & ComboBox1.Text & "'

Tell me it is want you want

Regards
Phils. Ervin

Oct 8 '07 #2

DanAusitn

Hello,

Yeah its possible.
just build Query in which you SELECT a ReCord from Database WHERE field is equal to your combo box.

Expand|Select|Wrap|Line Numbers

SELECR * FROM TableName WHERE FieldName='" & ComboBox1.Text & "'

Tell me it is want you want

Regards
Phils. Ervin

thanks alot for answering my question i dont fully undestand your answer but now i know what to research

thanks

Oct 10 '07 #3

jamesd0142

469

256MB

Basically it means that the sql statement in your programme is changed depending on what value is chosen in your combo box, by the user.

Oct 10 '07 #4

jrtox

thanks alot for answering my question i dont fully undestand your answer but now i know what to research

thanks

Hello,

Maybe you could study in this Link.
http://www.thescripts.com/forum/thread718154.html

Download my attachment.

Regards
Phils Ervin

Oct 10 '07 #5

DanAusitn

Hello,

Maybe you could study in this Link.
http://www.thescripts.com/forum/thread718154.html

Download my attachment.

Regards
Phils Ervin

hi , thanks alot I looked over this but i dont thin this method applies to me im becoming quite confused about this now , i am a begginer you can download my project Here im not asking you to do my project for me but if you did have the time I would appreciate it if you could look at it and help me solve this problem because it is holding my project back

Thanks again

Oct 12 '07 #6

DanAusitn

anyone got any advice?

Oct 12 '07 #7

by: Harry Haller | last post by:

<select name="cboPlaces" id="cboPlaces"> <option value="3">Countryside</option> <option value="4">Forest</option> <option value="5">Mountain</option> <option value="6">Desert</option> <option...

Javascript

Need some combo advice

by: Tina McGibben | last post by:

I basically have a form with a subform with two combo boxes on the main form which filter the subform. The code below works except I cant seem to get it to show all the worksheets when there is...

Microsoft Access / VBA

Dynamic Combo driven

by: Al | last post by:

hi,I am using asp.net(vb) I am trying to create 3 combo boxes which are dependable on each other. when comb1 is selected, it shows the comb2 data based on the selection in combo1 and when combo2...

ASP.NET

best WebForm DataControl to bind to Hashtable

by: John A Grandy | last post by:

in ASP.NET 2.0 , what is the best WebForm DataControl to bind to a Hashtable ?

ASP.NET

Where is datacontrol of vb6 available in vb.net

by: Maruthi Seshidhar | last post by:

The datacontrol available in vb6 toolbox is not available in vb.net toolbox. where can I find it.

Visual Basic .NET

datatsource depending on other datasource (in datacontrol)

by: tarscher | last post by:

Hi all, I have a list containing objects. Each object also contains a list of objects. e.g.: A1: B1 - B2 - B3 A2: B1 - B2 - B3 - B4 A3: B1 - B2 - A4: B1 - B2 - B3

ASP.NET

Combo autocomplete stops completing

by: John | last post by:

AC2007 I changed my combo's row source and then the autocomplete stopped working. The combo is two columns, bound to the first. First column is primary key (ID). Second column is a...

Microsoft Access / VBA

Can i connect a Access database without using DataControl or ADODC..?

by: jackvel | last post by:

Hi Dudes... I want to connect the Access database with VB 6.0 without using DataControl and ADODC.. Which option should i use.? Plz send me the detailed procedure of doing the same.. Plz...

Visual Basic 4 / 5 / 6

adding, saving, editing database without adding adodc or datacontrol

by: jaz215 | last post by:

hi! how do i add a record in a database without using the datacontrol and adodc. i want to rework my code to using purely codes and not being dependent on the design on vb. so far i have. Set rs...

Visual Basic 4 / 5 / 6

sincronizing two combo boxes

by: User | last post by:

Hi people, Excuse if my question is silly, but... i have 2 combo boxes in my project they are binded to fields from same table... one is binded do Code field and another to Description field...

C# / C Sharp

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Similar topics