Search results

Ok I have tried writing an update query and have also tried the link sugested. In update to I have this: Field: Next Service Due Table: tblServiceDue Update To: [tblServiceDueTemp].[Next Service Due] Field: Start Date Table: tblServiceDue Update To...

Hello, I have a table exported from excel. I intially imported this in to access to form a list of due dates for services. Every week I get and e mail with the updated version. I am trying to figure out how to update the dates in the 1st table with the new weekly ones. I can't get it to...

Thanks for that. I have preceded the statement with abs(Sum[tex.....) it's working fine now. I have changed the text box names. Again many thanks.

abs gives something totally different. Sum was close, but just negative any ideas?

Hello, I am trying to calculate the percentage of occurence in a report. I am using the following code in the data source for the text box: =(Sum([Text6]="Boblat")/([Text12]/100)) When I run the report the percentage is correct it is just a negative figure. how can I correct this problem...

excellent it works now. I guess if I want to do teh opposite ie highlight dates in the future then the statement would become if date is between toady and date()+7 would give all dates between today and for the next 7 days. Many thanks for everyone who has helped.

Cheers people, it's working. Just to finish it off I have selected teh less than statement and put Date() in the filed. Is there anyway to show dates that are out of date by say 7 days? i.e if date in field is 7 days older or more then change colour?

no matter where I put the code on the subform, it does not acheive the required result. I've even tried using: If txtNextServiceDue.Value < Date Then txtNextServiceDue.BackColor = vbRed On the on timer even or on current even for the subform. Neither make the date change...

The other thing is if the date for a service due is empy then I get an error code. I've tried writing an if statement to only colour the background if service due is not null but I can't get it to work. something along the lines of If Me!frmServiceDue.Form.txtNextServiceDue <> Null then. . ...

Getting closer :D Just need a little tweak, at present I have the code : If CDate(Me!frmServiceDue.FORM.txtNextServiceDue) < Date() Then Me!frmServiceDue.FORM.txtNextServiceDue.BackColor = vbRed In the On Timer command for the main form. When I open a record that has a date that is over...

Am having a play using continuous from setting will keep you posted.

ok is there anyway to still displauy the data but not in datasheet view, so that I can highlight the dates that are overdue?

Still can't seem to get it to work. should I put the code on the subform instead? When the subform is displayed it is in datasheet view, does this mean it is still possible to highlight the dates that are over due? Thanks again.

progress sort of, the error message has gone but the background does not change colour. Not sure why, guys?

Ok, slightly changed, so that it does not flash, just is higlighted in red. When I try and run it though I get the following error: Run time Error '438': object doesn't support this property or method the code : If Me!frmServiceDue.txtNextServiceDue.Value < Date Then...

Ok, I have a subformt hat is populated by a combo box. When the user selects data from the combo this then lists a customer number, models, and date in the subform. The selection from the combo box executes a query based on customer name in combo box. The subform displays the models and...

ok, I'm doind something different now, thanks.

Thanks for the reply I figured that out over the weekend. Ta.

Hello, I have been playing around to see if it is possible to operate a combo box as a one shot operation. I.e you make a selection from the combo box then the combo box is disabled. Only prob is that I can't figure out how to do it. Possibly by using a message box to see if selection is...

Hello, There are no links to other data from the auto number. I just can't see how to format the number in the way described above! B