Codejock Developer Community : Combobox with Database http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 15 May 2026 16:32:44 +0000 Thu, 05 Jun 2008 06:23:45 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=10903 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Combobox with Database : Hi, I&#039;m a little...]]> http://forum.codejock.com/forum_posts.asp?TID=10903&PID=36302&title=combobox-with-database#36302 Author: Aaron
Subject: 10903
Posted: 05 June 2008 at 6:23am

Hi,
 
I'm a little confused right now
 
I looked in the help (first time I didn't read it properly) and thought this is going to solve your problem and it did ?!?! but why, see Remarks
 

Remarks

If True, then you can only choose from the list of constraints added.

If False, then you can type a custom response not listed in the list of constraints.

 
Why does this property has an influence on this ???
Please explain....
 
 
And @wismerhill
This will have the same effect and you can only select the items in the combo:
 
''Column.EditOptions.ConstraintEdit = False
Column.EditOptions.AllowEdit = False
 
In the help:

Remarks

If False, then any editing features will not be used.  The Combo button and Expand buttons will not be displayed. 

If True, then all ReportRecordItems can be edited, you will need to set the EditOptions to false for each column that can not be edited, or you can set the EditOptions for each individual ReportRecordItem.

Now, this is helpfull isn't it?  
 
Well it works @wismerhill , right? Maybe we will get a reply of the supportteam and clear things....
 
 
]]> Thu, 05 Jun 2008 06:23:45 +0000 http://forum.codejock.com/forum_posts.asp?TID=10903&PID=36302&title=combobox-with-database#36302 <![CDATA[Combobox with Database : Thanks to Aaron, my problem was...]]> http://forum.codejock.com/forum_posts.asp?TID=10903&PID=36299&title=combobox-with-database#36299 Author: wismerhill
Subject: 10903
Posted: 05 June 2008 at 5:34am

Thanks to Aaron, my problem was solved.

The solution is to declare for my combobox : Column.EditOptions.ConstraintEdit = False
 
]]> Thu, 05 Jun 2008 05:34:46 +0000 http://forum.codejock.com/forum_posts.asp?TID=10903&PID=36299&title=combobox-with-database#36299 <![CDATA[Combobox with Database : Of course, I upload you a samp...]]> http://forum.codejock.com/forum_posts.asp?TID=10903&PID=36290&title=combobox-with-database#36290 Author: wismerhill
Subject: 10903
Posted: 05 June 2008 at 3:29am

Of course,

I upload you a sample.

uploads/20080605_032849_Sample.zip
]]> Thu, 05 Jun 2008 03:29:27 +0000 http://forum.codejock.com/forum_posts.asp?TID=10903&PID=36290&title=combobox-with-database#36290 <![CDATA[Combobox with Database : Hi, Can you upload a sample?...]]> http://forum.codejock.com/forum_posts.asp?TID=10903&PID=36287&title=combobox-with-database#36287 Author: Aaron
Subject: 10903
Posted: 05 June 2008 at 2:34am

Hi,
 
Can you upload a sample?
]]> Thu, 05 Jun 2008 02:34:55 +0000 http://forum.codejock.com/forum_posts.asp?TID=10903&PID=36287&title=combobox-with-database#36287 <![CDATA[Combobox with Database : Hello, I have a combobox in the...]]> http://forum.codejock.com/forum_posts.asp?TID=10903&PID=36250&title=combobox-with-database#36250 Author: wismerhill
Subject: 10903
Posted: 04 June 2008 at 11:24am

Hello,

I have a combobox in the first column of a report control. The data source of this combobox is the result of a recordset :

RptControl_TA.Columns.Column(0).EditOptions.Constraints.Add RsTA.Fields("CODE_TA").Value & " - " & RsTA.Fields("LIB_TA").Value, i + 1


When i want to load the data, i add to the combobox column the following information (the same caption as before).
Record.AddItem RsListe.Fields("CODE_TA").Value & " - " & RsListe.Fields("LIB_TA").Value

But the combobox is empty.

I can only recover some information when i use Record.AddItem 1 (where 1 is the second parameter : i+1)

Can we use the caption to fill the combobox ?
Else i will need to use a tab to save the caption and the data code and research for each record the good caption.

Thanks
]]> Wed, 04 Jun 2008 11:24:16 +0000 http://forum.codejock.com/forum_posts.asp?TID=10903&PID=36250&title=combobox-with-database#36250