Using 'column(n)' in a query/SQL

V

Vsn

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
 
V

Vsn

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Change criteria on a saved query using VBA 0
Printing SQL query results in a list of columns, instead of one long column 1
Need Help with a VBA subroutine 0
Adding a big matrix in Word 2013 5
Word macro that can call cells out of Excel for a find and replace 0
query or SQL string 3
WHERE [Characteristics].[abbrev] in () 1
Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server 0

Top