|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 10th, 2009, 08:31 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Using 'column(n)' in a query/SQL
Hi all,
Can some one tell me how I can use the value of a combobox.column(1) in a query or SQL string? Like: Criterea = [Forms]![frmOverview]![cmbDateRange]!Column(2) I get the error message 'undefind function in expression'.............. Thx, Ludovic 
|
|
#2
October 10th, 2009, 08:46 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Using 'column(n)' in a query/SQL
Hi all,
I made a work-around with a function (below), which i call from the query. It seems to work the way i needed it. Function DateValue(Optional intColumn As Integer = 2) DateValue = Form_frmOverview.cmbDateRange.Column(intColumn) End Function Sorry to bother. Cheers, Ludovic "Vsn" vsn_hotmail_kom schreef in bericht ... Hi all, Can some one tell me how I can use the value of a combobox.column(1) in a query or SQL string? Like: Criterea = [Forms]![frmOverview]![cmbDateRange]!Column(2) I get the error message 'undefind function in expression'.............. Thx, Ludovic
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
