473,385 Members | 1,863 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,385 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 2196
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: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
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...
0
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,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
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...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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...

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.