Search results

If you want to read the data from the combo box in the format yes/no, 0-10, rather than just the number of the selected row, then you need to make the column containing that data the bound column and assign it to a variable of the correct type. Try setting intResponseID to be a variant and then...

You're referencing a recordset that you haven't declared or opened which is most likely the source of your error message. Are you trying to select the current value then repopulate the combo based on that, as Bob suggests? In which case try intResponseID = Me.cboResponse

Do you have Windows set to display extensions for known file types on that folder?

Solution using a single query You can do as Michael suggests, but it in a single query, with the following SQL SELECT AccountNumberField, TransactionField FROM ExampleTable WHERE AccountNumberField IN ( SELECT AccountNumberField FROM ExampleTable GROUP BY AccountNumberField HAVING...

Maybe I misunderstand what you're trying to do, but surely you've got your dates backwards? Shouldn't you be selecting records where today's date Date() is Between DateAdd("m",([months between services]-2),CompletionDate) And DateAdd("m",([months between services]-0),CompletionDate) At the...

You need a sub-query to handle the WHERE statement. I think this should do what you want: select z.code_number, z.vehicle_number, z.company_code, z.fc_valid_to, i.next_due_date from ((select v.code_number, v.vehicle_number, v.company_code, r.fc_valid_to from vehicledetails as v left join...

When I do things like this I always force the numbers to more digits than you'll ever need to make sure your quote reference is unique. ie use 0130 and 0003 to create quote reference 01300003. Otherwise quote 3 for company 131 is the same as quote 13 for company 13 etc. :eek: