Search results

Hi Gina !!! just would like to take the time to thank you for sparing some time to help me in my thread . it works Great !!!! :D:D:D:D thanks again SHANE :cool: http://www.access-programmers.co.uk/forums/showthread.php?p=1366205#post1366205

thanks Gina !!!! works great!! thanks VbaInt!! For your Help cheers shane

right I made record in the criteria but still not showing I have attach strip down db with only my tables and query to show I get what your say now just down understand why its now working thanks shane

so this needs to be added to the field criteria, as when I do it makes a new column then when I run it shows no records but not asking for find last :) cheer shane

ok lol right I now tried :banghead: Between Date() And +30 now its only asking for find last value when I run it thanks shane

right I now I got this between [FindLast] And [NextService]-Date()+30 but it asking for a value for find last and next service when run thanks shane

so that say on that link it should be value 1 value2 between [FindLast],[NextService]- Date() + 30 god know what I'm doing wrong here thanks shane

right I have tried [NextService] between date+30 with no luck :banghead::banghead::confused: cheers shane p.s will this need to be in my criteria

you must not need a lot sleep :) right lets start again In my query I find last service date from my table using a calculated field like so FindLast: DMax("[MaskServiceDate]","[MaskServiceTbl]","([ImpMaskID]= " & [MaskID] & ")") then I calculated the next service date by what user...

sorry I am totally lost where the hell would I use between it is 2am nearly lol does it need to be in my statement above NextService: DateAdd("m",[MaskServiceMonths],[FindLast] between ??) thanks shane

hi vbaInet nice to see you again so yes it would be + 30 Days thanks shane

hi I have query with a calculate field to finds the next service due date but I'm having a problem getting it to only show services due dates in the next 30 days for some reason I cant add a criteria date()-30 here's what I have to calculate the next service it takes service intervals...

sorry lol my bad silly question I have solved it thanks again vbainet shane

hi thanks worked great but now how do I make it work on a range say 4 days up to 10 days before If Me.NextService > Date - 10 Then Me.overdue.Visible = True Else Me.overdue.Visible = False End If If Me.ExMask = True Then Me.Combo74.Enabled = False Else Me.Combo74.Enabled = True End If...

hi , all right i'm trying to make a label show if the date in my next service field is 10 days till its due this what I have on a on current form event this works great but would like the message to appear 10 days before the date is passed If Me.NextService < Date Then...

hi VbaInet just response before I close the thread after take on board your finding and doing a lot reading and research I ended up doing a complete re-design of my db:banghead: reduce sub forms and I run everything from one query I have resolved the issues in this thread by using the dmax...

ok here's copy of my db open form "frmplant" Select Plant Type From Combo Box then press command button " Add service" this will open From "frmpopupPlantservice with sub from plantservicetbl subform this will give you the service details of the plant item then you will see text...

Right .... Yes I want to get highest date from datedue this is calculated field in my query So it would be First part the field = datedue Second part is Query name = qtyplantservice Thanks Shane

right... ServiceID increments automatically right? answer yes first part: datedue second part: plantservicetbl subform : query builder thanks shane

serviceId is the primary key impPlantitemId is the Plant item id the link between plant item and plant service if this helps thanks shane