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
11 2197
Hi,
Try setting the column widths to zero for those columns you don't want to see
HTH
Steve
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
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?
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
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?
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. - [Forms]![FirstFormName]![ListboxName].Requery
Mary
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?
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
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.
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??:(
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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
|
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: 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...
|
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...
|
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,...
|
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...
|
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...
|
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...
|
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...
| |