Recent content by ali32uk

OK thanks i understand

I ve tried the code, unfortunately it does nt work, even if I select 1st of month its still picks up the else function Ali

Hi All I m trying to use conditional formatting on a textbox on a continuous form, to find if the TxtMonth Date value is between Startdate and enddate date values, as below: Problem i m having is that it only checks if the day value is between day values of startdate and enddate, so for...

Thank you will give it a try

Hi All I m hoping this is simple one.. I just want to check if the date entered is 1st of the month, if not display a msgbox for user to correct? Appreciate your help thank you Ali

Thank you for your help!

Hi All thought this would be simple, turns out for me its not... I m trying to do the following I have a "Startdate" field on a form, and a combo box "comboMonths" and an enddate field, based on the user choosing a date in startdate and then selecting either 3, 6 or 12 from the combo box, I m...

sorry I should add, I m looking to repeat this for different date so If StartDate falls between 01/11/2015 and 30/11/2015 then change the back colour of a textbox to red elseif StartDate falls between 01/12/2015 and 31/12/2015 then change the back colour of a textbox to red elseif StartDate...

Hi All Apologies but I dont know where to go with this, I just want to do an if statement which says if StartDate falls between 01/11/2015 and 30/11/2015 then change the back colour of a textbox to red can any one help?? I m a bit out of practice and not done coding for many years... so you...

Hi All I m looking for a little help with an access DB I m creating, it has a sub form called SubPromotedProducts, on opening the the master form Step2_AssetAssignment, I d like 5 new records to be entered into the subform automatically, as below this image shows the desired result, so 5...

Hi I would appreciate anyone's help with this I have a continuous form which I m using the backcolor function to change a text box [Order_Frequency_100] color based on the value in another textbox [Rating100] Code: Private Sub Form_Current() If Me.Rating100.Value < 4.5 Or...

Hi I m using the following as criteria in my query Between DateAdd("m",-12,Date()) And DateAdd("m",-6,Date()) which works great but does nt quite do what i m looking for. this takes from the current date, ideally what i want is from the last full month, i.e. today is 28th July, so it filters...

HI thanks for your response I ve tried this but unfortunately it just places " & TxtRecordvalue & " in the table field... am I doing something wrong? SQL UPDATE ExportTable SET ExportTable.recordvalue = '" & txtrecordvalue & "'; BR Alastair

Hi All Last question for today... I want to use an update query to update every value in a table column "recordvalue" to the value entered in my form TxtRecordvalue, I know I should know this but for the life of me I cant figure it Any help appreciated! Alastair

Perfect thankyou, it just the way its needed for person its being outputted too