473,406 Members | 2,816 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,406 software developers and data experts.

Combobox List

173 100+
Hi,

i have a combobox that lists company names....

selecting the company name automatically populates the address fields (address line 1,2, 3 and postcode)....

in the combobox i have 5 columns, company name, address1, address 2, address 3 and postcode.......

in the Column width, i have 8,0... which only shows the company name ( as i want)...I ONLY WANT TO SHOW THE COMPANY NAME

but theres a scrollbar in the combobox that still takes me to the other columns(address 1, 2, 3 and postcode).. HOW DO I GET RID OF THIS SCROLLBAR???

thanks
Dec 15 '06 #1
11 2197
cyberdwarf
218 Expert 100+
Hi,


Try setting the column widths to zero for those columns you don't want to see

HTH

Steve
Dec 15 '06 #2
MMcCarthy
14,534 Expert Mod 8TB
Column Width 8cm ;0cm ;0cm ;0cm ;0cm

Mary

Hi,

i have a combobox that lists company names....

selecting the company name automatically populates the address fields (address line 1,2, 3 and postcode)....

in the combobox i have 5 columns, company name, address1, address 2, address 3 and postcode.......

in the Column width, i have 8,0... which only shows the company name ( as i want)...I ONLY WANT TO SHOW THE COMPANY NAME

but theres a scrollbar in the combobox that still takes me to the other columns(address 1, 2, 3 and postcode).. HOW DO I GET RID OF THIS SCROLLBAR???

thanks
Dec 15 '06 #3
Beany
173 100+
cheers mary
Dec 15 '06 #4
Beany
173 100+
Thats working now Mary.......

the address fields populate now.........

but the fields cannot be manually edited?? why is that

i want it to populate...(which it is doing) but i want it to be manually accesible.... so if i want to add a new address, i can just write into the fields??

how can i do this?
Dec 15 '06 #5
MMcCarthy
14,534 Expert Mod 8TB
Thats working now Mary.......

the address fields populate now.........

but the fields cannot be manually edited?? why is that

i want it to populate...(which it is doing) but i want it to be manually accesible.... so if i want to add a new address, i can just write into the fields??

how can i do this?
You can't with a list.

You will need a subform or popup form to do this.

Mary
Dec 15 '06 #6
Beany
173 100+
You can't with a list.

You will need a subform or popup form to do this.

Mary

so will the popup form insert new details into these fields?

do u have any ideas?
Dec 15 '06 #7
MMcCarthy
14,534 Expert Mod 8TB
so will the popup form insert new details into these fields?

do u have any ideas?
If the form has the table as it's record source it will allow you to edit and add records as normal. Then in the On Close event of the form requery the list on the first form.

Expand|Select|Wrap|Line Numbers
  1. [Forms]![FirstFormName]![ListboxName].Requery
Mary
Dec 15 '06 #8
Beany
173 100+
this is not clear to me..........

so you suggest that...............

i have an additional button that will take me to a new form where i can input the new address details.......... and this will then update the table fields.............

once that is done, it will show in the list of the combobox??? is that right?
Dec 16 '06 #9
MMcCarthy
14,534 Expert Mod 8TB
this is not clear to me..........

so you suggest that...............

i have an additional button that will take me to a new form where i can input the new address details.......... and this will then update the table fields.............

once that is done, it will show in the list of the combobox??? is that right?
As long as you requery the list yes

Mary
Dec 16 '06 #10
NeoPa
32,556 Expert Mod 16PB
Alternatively, you can populate the list with literal data.
If you set the RowSourceType to "Value List" then you provide a string with all the values included.
This can then be updated in code to add any new items that are required.
If you already have the data stored in your database, though, this would not seem to be a clever way to go unless the additions were always considered temporary or session scoped.
Dec 17 '06 #11
Beany
173 100+
i have a form that has the address details plus other details.........

i can select the name of the site and it automatically populates the address fields (and the next step would be to fill in the rest of the form)......

for a new address........ i have a button that takes me to a new form where i can input the new address.....

what im worried about is, if i add the new details to the table from my new address form......it adds and i can select it from the combobox to get it to populate................., but then if i fill in the rest of the form and click the add button, will it add it as a new record?????

i want it to add to the record which has the new address............

do i make sense??:(
Dec 18 '06 #12

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

Similar topics

7
by: NCrum | last post by:
I want to set the Default value of a Combobox for any changeable record and have got this working but it is totaly unsatisfactory see the code below I loop through the items in the Combo looking...
2
by: SKarnis | last post by:
We are trying to rebuild a current Access 2002 (XP) mdb program to VB.NET with a SQL database - we are having problems with a suitable combobox. There are many threads discussing multiple column...
6
by: tbrown | last post by:
I have a combobox with items like this: {one,two,three}. The selected index is 0, so "one" appears in the combobox text. When the user drops down the list, and selects "two", for example, I...
4
by: =?Utf-8?B?UmljaA==?= | last post by:
Greetings, I have to load 30,000 unique names into a combox. Filling a dataTable takes only a few milliseconds. But populating the combobox and displaying the list takes several seconds - way...
19
by: active | last post by:
I'm using a ComboBox to display objects of a class I've defined, say CQQ. Works great except somehow I occasionally set an Item to a String object instead of an object of type CQQ. It looks...
5
by: active | last post by:
I tried to use a datasource with a combobox and it didn't work completely so I build a small test that was much more straight forward then the app. The test was to see if the combobox dropdown...
4
by: Jerad Rose | last post by:
I'm baffled by this -- is there not a typed object used for ComboBox Items? Best I can tell, all of the methods for ComboBox that accept an Item are of type Object. Why in the world is a...
19
by: billa856 | last post by:
Hi, I have to use the table(PRODUCTION) already generated in MS Access in which all fields are of TEXT type.fields like (orderdate,palletno,customercode,itemno,pono,carto n,pcs,totalquantity)Now i...
1
by: Andrus | last post by:
I need to enter null value from combobox to business object property. My combobox datasource does not contain ValueMember with null value. So I tried to create combobox which stores null to bound...
3
by: Marc Gravell | last post by:
Sure; just set the DataSource, DisplayMember and ValueMember of a DataGridViewComboBoxColumn (below ). Marc using System.Collections.Generic; using System.Windows.Forms; using...
0
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
1
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...
0
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...
0
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...
0
Oralloy
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,...
0
jinu1996
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...
0
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...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
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...

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.