Search results

Hello, Thank you for your answer it's working as expected, but as I have a lot of criterias, it will become very hard to manage the query with references. I think I will duplicate this query :( See attached a print screen of my actual query. Thanks again for your time. @+ Michel.

PARAMETERS Status Text ( 255 ); SELECT Table_Import_VPBank_Deals.[Type of Trade], IIf(IsNull([Registerred_name])=True,"No Name configured",[Registerred_name]) AS Registered_name, Table_Import_VPBank_Deals.Isin, Table_Import_VPBank_Deals.[Order Date and Time], Table_Import_VPBank_Deals.[Trade...

Hello JHB, Thank you for your remark, but if I tried only with the parameter[Status] it's working correctly. Now I would like to add another criteria which is a result of a combobox in the form itself. If I input it in the query like: Like...

Thank you for your answer, but must I have to replace this statement in the query itself or in the VBA code? I tried to insert it in the VBA but the "Like" expression is not recognize :( Here what I tried: 'Supply the parameter value 'Like...

Hello, As I am very lost in this kind of request I'm asking you some help... Thanks of this forum I'm able now to run a query with one parameter. The code is: Dim dbs As DAO.Database Dim qdf As DAO.QueryDef Dim rst As DAO.Recordset Set dbs = CurrentDb 'Get the parameter query Set qdf =...

Hello, Thank you very much for your answer it's working exactly how I would like. I didn't know that you cannot open a query but you have to pass the information directly in a list or combobox :o Michel.

Hello, In Access 2003 I create a query which for one field was link to a value on a form. Now I have to duplicate this form and instead to duplicate this query I wanted to use a parameter inside this query for one field and then via VBA call this query and give a value for this parameter...