Search results

This is how I resolved my issue … Dim sPriceMatrixSource As String If Me.Cmb_Price_Matrix.Value = "Price Matrix 1" Then sPriceMatrixSource = "SELECT [Tbl_Price_Matrix_1].[HeightValue] FROM Tbl_Price_Matrix_1 GROUP BY [HeightValue]" Me.Cmb_Height.RowSource = sPriceMatrixSource...

Thank you guys for replying back, you pointed me to the right direction! cant believe it was so easy :eek:

Hi, I'm hoping that someone can point me in the right direction, I've searched online and cant seem to find the solution to my problem. I think its because i'm searching for the wrong thing. I have a combo box (Cmb_Price_Matrix) on my form that has two options, depending on what's has been...

Thanks guys, I will have a play with what you've suggested and come back to let you know how I get on. Your help is greatly appreciated! Have a good weekend.

I've looked at the DateAdd function but I cant figure out how it can give me the next service month based on the todays date. namliam, I want the next service interval based on todays date as a VBA solution, how would I go about achieving this result? thank you fro your suggestions, I've...

Hi, I've been trying to solve this problem for the past month and at the verge of destroying my PC! I've trawled through numerous web sites but just cant seem to figure this one out. I'm trying to get access to tell me what the next service moth is based on the start date, end date, and...