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

Autofill query

Hi All

I have a combo box that sources from a field and enables me to autofill
if I have the properties as such:

Column count: 2
Bound Column: 1
Column Width: 0
Auto expand: yes

I think I can use the column width = 0 so it will read the second
column as the first column is just the ID and it is the second column
which is the important one.

However an error comes up namely: The value you entered isn't valid for
this field

Although the value is text and not numeric. This error doesn't allow
you to do anything more.

If anybody can help out with this it would be greatly appreciated.

Cheers,
Mike

Nov 13 '05 #1
1 1998
mi**@geographx.co.nz wrote:
Hi All

I have a combo box that sources from a field and enables me to autofill
if I have the properties as such:

Column count: 2
Bound Column: 1
Column Width: 0
Auto expand: yes

I think I can use the column width = 0 so it will read the second
column as the first column is just the ID and it is the second column
which is the important one.

However an error comes up namely: The value you entered isn't valid for
this field

Although the value is text and not numeric. This error doesn't allow
you to do anything more.

If anybody can help out with this it would be greatly appreciated.

Cheers,
Mike

I would think that you'd have something like
ColumnWidths 0";1"
Width = 1"

IOW, you have 2 columns, the first column is hidden. Setting the Width
to 0 would make it very difficult to select anything from the combo.
I'm not even sure if you could access the dropdown button.

Here is some code I put into the OnClick event of a combo box named
Combo0. Drop it into your OnClick event of your combo and change Combo0
to the name of your combo box.

Private Sub Combo0_Click()
Dim intIncrement As Integer
'see if columnheading is on or off. Returns 0 False or -1 True
intIncrement = (Me.Combo0.ColumnHeads = True)
'get the index of the selection and add the column headings
'value. Use Abs to convert -1 to 1
intIncrement = Me.Combo0.ListIndex + Abs(intIncrement)
MsgBox intIncrement & " " & Me.Combo0.Column(1, intIncrement)
End Sub

Important Combo/Listbox properties include ListIndex, ListCount,
ItemsSelected, ItemData, Column, and Selected. Look these up in OnLine
help and check out the examples for more clarification.
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Chris Sharman | last post by:
I'd like to design my pages to work cooperatively with browser autofill features. I've loked around, but can't find any good documentation on supported/unsupported field names...
1
by: shortbackandsides.no | last post by:
I'm having a lot of difficulty trying to persuade the Google toolbar autofill to act consistently, for example ======================= <html><head> <title>autofill test</title> </head><body>...
0
by: David Portabella | last post by:
Hello, I am a doing a survey about Autofill Web Forms softwares. Usually, they all collect information of the user once during the set-up phase (user knowledge base). Then, when the user...
1
by: Nick J | last post by:
Hi, I remember at one point access would autofill a text box when filtering by form, Like for example as I would type it would come up with matching records, similar to AutoComplete in Internet...
2
by: Andre Ranieri | last post by:
I'm retouching our corporate web site that, among other things, allows customers to log in and pay their invoices online. I noticed that on the checkout page, the credit card number textbox...
4
by: HTS | last post by:
I have written a membership database application (PHP + mySQL) and need to prevent autofill from filling in fields in a member record edit form. I know I can turn off autoFill in my browsers, I...
10
by: sandraz444 | last post by:
I have an expression in the query under my form to autofill the date under a certain condition but it wont write to the underlying table?? The date shows in the form but not the table. Does anyone...
1
by: Rissoman | last post by:
Hello, I have an issue were I have a zipcode textbox in an atlas ajax updatepanel. When you tab out of the zip textbox and the shipping is calculated. I know this works perfect! Then a user...
0
by: Randy | last post by:
Hi, I have some comboboxes that are created dynamically at run time based on user actions. I found a procedure on a message board to autofill the combobox text from the dataview that the...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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...

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.