473,320 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,320 software developers and data experts.

Combo Box not editable

Hi
How do i put a combo box not editable?


Second question:

How can i disable access error msg's, and do own windows msg.

Thx
Sep 6 '06 #1
5 17297
MMcCarthy
14,534 Expert Mod 8TB
In the combo box control go to properties and in the Data tab set the Locked property to yes.

Access Error Messages that are automatically created by the wizards usually use an Err.Description message. Just replace that with the message you want the user to see.

Hi
How do i put a combo box not editable?


Second question:

How can i disable access error msg's, and do own windows msg.

Thx
Sep 7 '06 #2
In the combo box control go to properties and in the Data tab set the Locked property to yes.

Access Error Messages that are automatically created by the wizards usually use an Err.Description message. Just replace that with the message you want the user to see.
Thx.

About Error Messages, where can i find that part of code???
Sep 7 '06 #3
In the combo box control go to properties and in the Data tab set the Locked property to yes.

Access Error Messages that are automatically created by the wizards usually use an Err.Description message. Just replace that with the message you want the user to see.

About combo box, i need to force the choose of one listed, and not permit write in combo box, cause if i lock it can´t be modified.
Sep 7 '06 #4
PEB
1,418 Expert 1GB
This function permit to visualise the errors with their standard messages!

Activation is: MsgBox ErrorString(Err.NUMBER)

In this function you can type your own messages for the different numbers of errors!

Function ErrorString(ByVal lngError As Long) As String

Const conAppError = "Application-defined or " & "object-defined error"

On Error Resume Next
Err.Raise lngError

If Err.Description = conAppError Then
ErrorString = AccessError(lngError)
ElseIf Err.Description = vbNullString Then
MsgBox "No error string associated with this number."
Else
ErrorString = Err.Description
End If

End Function
Sep 7 '06 #5
PEB
1,418 Expert 1GB
And about your combobox!
So it wouldn't be locked! You want to introduce values only from the list wan't you?

So you have to activate the property Limit to list!
Sep 7 '06 #6

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

Similar topics

5
by: mik18 | last post by:
Is there a limit to the number of rows a combo box can contain within Access 2002? I have a list of drug names with all the NDC codes which contains over 200,000 records. I do have this filtered...
1
by: Steve B. | last post by:
Using VS 2003 1. I Connect to a MS-Access dB, create a DataAdapter (DA1) for Table1 and a DateSet (DS) with Table1 2. I populate a Datagrid and associated Textboxes (TB -Text) w/ the DS.DA1 -...
0
by: Nick | last post by:
Hi people, I have a custom control combo box in a windows application that has a list of items to be displayed. there are currently 17 items that are bound to the table that acts as the data...
2
by: C#Newbie | last post by:
So here is my problem, I have a program that i would like to have some control similar to a combo box. However, I don't want it to be editable. How can I do this? Also, when my server pass...
1
by: The Eclectic Electric | last post by:
I'd be very grateful if anyone could help me with this. From my limited knowledge of Javascript I don't think it is possible, but I'll punt anyway. I downloaded and very slightly adapted this...
3
by: John | last post by:
I keep creating combo boxes over and over again without any luck. I want the combo box to look up values of which I can select them. Currently I can create the combo box but can not select anything...
1
by: teddy86 | last post by:
Hi.... i have a combo box....in the run time i want to select values from that combo box..............this combo box should not be editable ie. if i typed anything in that box it should not accept...
0
by: dudeja.rajat | last post by:
On Mon, Aug 25, 2008 at 12:57 PM, <dudeja.rajat@gmail.comwrote: Ok...now I found the way to do that. But I'm stuck further. my code is as below: main module ********************** myRoot...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
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...
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.