Hello.
I have a form with a series 5 combo-boxes. All 4 contain the same
query which lists Parts based on a productID from a previous form.
i.e.
cboPart1 = Part ID, Part, ProductID Where ProductID =
Form!frmName!cb oProductID
cboPart2 = Part ID, Part, ProductID Where ProductID =
Form!frmName!cb oProductID
cboPart3 = Part ID, Part, ProductID Where ProductID =
Form!frmName!cb oProductID
cboPart4 = Part ID, Part, ProductID Where ProductID =
Form!frmName!cb oProductID
cboPart5 = Part ID, Part, ProductID Where ProductID =
Form!frmName!cb oProductID
Now when I open this form I want it to select a specific row for each
combo box
cboPart1 = Row1
cboPart2 = Row2
cboPart3 = Row3
cboPart4 = Row4
cboPart5 = Row5
The PartID stored in the 1st column can be any number becuase of the
filter so I just can't set its value to 1-5.
I need a way to say open the combo box and select a specific row.
Ideas methods?
Thanks in advance. 1 2923
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
You could use the ComboBox property ListIndex (zero-based) in the
form's OnCurrent event procedure to set the ComboBoxes. E.g.:
cboPart1.ListIn dex = 0
cboPart2.ListIn dex = 1
cboPart3.ListIn dex = 2
.... etc. ...
Also, see the Access help articles on ListIndex and ListCount.
HTH,
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBP/zZZIechKqOuFEgE QKjjQCgi+U3B28R ofEmjCqW5MOaOEu IiwoAoPC5
I6FWhaHlN9QZbHh rxqDF5Qtz
=lO+I
-----END PGP SIGNATURE-----
Ryann wrote: Hello.
I have a form with a series 5 combo-boxes. All 4 contain the same query which lists Parts based on a productID from a previous form. i.e.
cboPart1 = Part ID, Part, ProductID Where ProductID = Form!frmName!cb oProductID cboPart2 = Part ID, Part, ProductID Where ProductID = Form!frmName!cb oProductID cboPart3 = Part ID, Part, ProductID Where ProductID = Form!frmName!cb oProductID cboPart4 = Part ID, Part, ProductID Where ProductID = Form!frmName!cb oProductID cboPart5 = Part ID, Part, ProductID Where ProductID = Form!frmName!cb oProductID
Now when I open this form I want it to select a specific row for each combo box
cboPart1 = Row1 cboPart2 = Row2 cboPart3 = Row3 cboPart4 = Row4 cboPart5 = Row5
The PartID stored in the 1st column can be any number becuase of the filter so I just can't set its value to 1-5.
I need a way to say open the combo box and select a specific row.
Ideas methods?
Thanks in advance. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: mr_burns |
last post by:
hi,
using javascript, how do i select an option in a combo box? i have
tried looking on the internet but dont really know what i should be
searching for. what i want to happen is that when a function is called
a line of code will select a specific option in a combo box. something
like:
//excuse the dodgy syntax
|
by: Jos? |
last post by:
This one droves me completely mad. I did not succeed to exploit the
track given to me by Bob.
I have :
three tables : Clubs, Persons and ClubsPersons that join the two first
in a many to many relationship.
Club has two (2) fields : ClubId (Autonumber) and ClubName (Text).
Peoples has two(2) fields : (PersonId (Autonumber) and PersonName
(Text)
ClubsPersons has two (2) fields : ClubId (LongInteger) and PersonId
|
by: Sebastian Santacroe |
last post by:
Hello,
I've got a datagrid with two columns and no data. I want
to add data programmically (from DB).
When I try to use sintax like:
dataset.Tables("Department").Rows(0).Item("Percentage
Used") = 10
(you can assume the grid is binded to this dataset table)
I get an error telling me row 0 does not exist. I'm
assuming I need to use a New command to add rows in a
|
by: Agnes |
last post by:
I set my datagrid's datasource programmically . However , as the form load,
I found that every column width is the same,
Question 1) How can i adjust it programmically ???
Question 2) I need to do some specail effect as the user press 'enter' in
the 3rd column, how can i know the user press 'enter' in the 3rd column ??
Thanks in advance
From Agnes
|
by: Vmusic |
last post by:
Hi,
I'm using MS Access 2002. I have a form with a combo box built from a
query that returns one column, and that one column is the bound column.
How do you use VBA to programmatically change which row in the combo
box is selected??
I looked at the forum and the answers aren't very clear. Of course the
MS Access help file is worthless.
| |
by: jjyconsulting |
last post by:
Newbie needing some help. I have a tblParticipants. The fields
include gender, education_level, income, occupation etc., I'm trying to
create a form where a user can run a query from the form and just
choose the appropriate criterias from the combo boxes to get the
results. I also want the query to run even if there is not a value in
all the combo boxes ie., i want just all males with income level of
over $100,000...Any insights or help...
|
by: tee |
last post by:
Hi,
How do i sort datagridview programmically, current i have the following code
but i keep get the error saying "DataGridView control must be bound to an
IBindingList object to be sorted.", What is IBindingList and how would i go
about using it.
Here are my code
private void dataGridView1_ColumnHeaderMouseClick(object sender,
|
by: mygirl22 |
last post by:
Hi,
I used this code to created 2 combo boxes General and Specific...and Only show Specific (Combo B) when Combo A is chosen.....
What i need now is to know how to assign specific values to the items in combo b (Specific).???
If i chose a sode, Fanta, i want the total price to be $20.00 (this price will show up in the finial price box....Please Help!!
drinkComboBox.Items.Clear() 'Clears the old items out of the drinkComboBox
...
|
by: guinb |
last post by:
i have a form with 2 boxes for start date and end date as well as 2 combo boxes for serial number and aircraft type. if i select a specific value for each then the rerport is generated just fine but if i select 'all' in the combo box for serial number then the report will come back with nothing in it. where should i start to look for the problem at?
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |