Search results for query: *

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...

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

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...

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 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

HI I have an update query which has 5m lines, one of the columns is a date column, what I d like to do is change the day part of the date to be 01. for example Current Afterupdate 26/12/2014 01/12/2014 27/10/2014 01/10/2014 18/02/2015 01/02/2015 27/10/2014 01/10/2014 07/11/2014...

Hi All I have a fairly simple continous form which I am using for contacts, this is embedded subform (subformcontacts) into a master form (customer) so I have a customer and the subform i populate with contacts for that customer. In some cases a contact can be in multiple customers, I was...

Hi I m looking for some help, I have 2 tables which hold list of items. table 1 as below ReqID Item A001 acb11 A001 200011 A001 10011 A001 a1221 A002 1-11122 A002 2266859 A002 ab2112 A002 R441 A002 1-33244 A002 ACB12 Table 2 as below QuoteID Item X01 acb11 X01 200011 X01...

Hi All this is really confusing and me and cant figure the reason.. I have 2 queries - an append query and a delete query, they are exactly the same other than the type (append/delete) I even copied the append query and just changed the type once copied... So my question is why are they...

Hi I m using a update query to delete everything in a column which is after the last "-". the code is as below The trouble I m having is that some of the fields don't have any "-" in them and so it deletes the whole entry which is not what I m looking for UPDATE [PRODUCTREGISTER SCP] SET...

Hi All I would appreciate some help on the below I am currently using the below Private Sub Form_Load() If Me.Rolling_Year_Change.Value < 0 And Me.YTD_Change.Value > 0 Then Me.Text147.Value = "The last 12 months are showing a decrease in spend, the YTD spend is increasing" ElseIf...