Search results

Hi James Thanks for the reply. It's a bit weird - the cell is simply blank unless I click in it at which point six zeros appear (00:00:00) because is is converting the total number of seconds accrued into hours, minutes and seconds. However, the calculation appears when I put the form into...

I have an Access 2007 database which was working happily in Windows XP Pro SP2. I have just upgraded to Windows 7 and all of a sudden some calculations in my forms and subforms are not working. Below is a typical example:- =Format(Int([TotalAccrued]/3600),"00") & ":" &...

Just recently whenever I close an Access database, I have been getting the error message:- "There was a problem sending the command to the program." I realise this was a prolem with ZoneAlarm a while ago, but I don't have this software. Also, when I open up a database from a shortcut it takes...

No Problem. Thanks again Just as a matter of interest. What do you do if you have more than three variables? Rob

Paul It's OK. I figured it out - thanks for pointing me in the right direction. Cheers Rob

Thanks Paul However, I am afraid I need this kind of thing spelt out for me. Where does the "Expression Is" condition go? Sorry to be so clueless. Cheers Rob

I have a continuous form (frmLiveProjects) – filtered by a query (qryClientProjectsFrm) from the main form (frmProjects). On frmProjects there is an option group (FrameProjectStatus) which has three alternate options. I would like to change the background colour of the fields for the various...

Paul Thanks a million - that works a treat. Cheers Rob

Thanks guys. Sorry to sound dim, but how do I create a field in my query into which the criteria you descrbe can be placed, and in what format should this field be as it is a calculation of the amount of time accrued between two dates. I am a bit confused. Cheers Rob

I have a database which records time spent on various projects and I would like to be able to calculate the time spent on any particular project between two selected dates. The report and the query behind it already works to display the time accrued on all the dates of a project, but I want to...

Wow Wayne Thanks, that looks great! Trouble is my knowledge of VBA is not too great. Could you please explain exactly where I put the public function - for example, which event on the form requiring the formatting does this piece of code reside in? Or am I missing something more basic? If...

Hi I have searched the forum but can't quite find what I am looking for. I have a continuous form and want to change the background colour of the fields for each record based on the settings derived from an option group on another form. Any help would be gratefully recieved. Cheers Rob

Thank you Rich Repeating the calculation works a treat - why on earth I didn't think of that beats me. Must have something to do with a distinct lack of inate brilliance. Thanks again. Rob

Hi edtab Thanks for the reply. NO, I still get the error when the formula goes in the report footer. Any other ideas? Rob

I have a report on which I list projects worked on in any given month and the time spent working on them. The total time spent for the month is a summed total created in the query which forms the control source of the report. On the report I then have a calculated field within the ProjectName...

I have a report on which I list projects worked on in any given month and the time spent working on them. The total time spent for the month is a summed total created in the query which forms the control source of the report. On the report I then have a calculated field within the ProjectName...

This must have been answered before, but I can't find it by searching so sorry for the dumb question. I input a time in hours and minutes in a field with a Short Time format. I would like then to convert this to seconds in a field with a number format so that I can total the seconds and then...

Hi RG Sorry for the hiatus, other things keep getting in the way. Thanks for all you help so far, I knew I'd get into trouble with the SQL part:- WHERE Month([RecordDate]) = Forms!YourFormName!YourMonthControl AND Year([RecordDate]) = Forms!YourFormName!YourYearControl First of all, can you...

OK, I know I need words of one syllabal, so please be patient. The field into which my selected date is going is now named txtInvoiceMonth and has the Control source - InvoiceMonth. My invisible unbound text boxes have the control sources =Year(Me.txtInvoiceMonth) and...

Hi RG Thanks for that - I tried the option using the two invisible text boxes, but just got the #Name? error message. When I pick the date it goes into a field call InvoiceMonth, so I put the control source in my invisible text box to:- =Year(Me.InvoiceMonth) and =Month(Me.InvoiceMonth), but...