Recent content by SandyUK

Please ignore. Schoolboy error on the properties of the of the report having the "Has module" set to NO Its a Friday and i didn't notice the scroll bar had reappeared covering this last choice on the properties. Take it easy Adrian

Hello I wanted to add some VB to a report but when i opened the VBA the class object for the report was missing (not a class module that I had created) the one that is directly of the tree Microsoft Access Class Objects. It was there in the past and i cannot find any way to recreate it. I have...

Thats one of things that i had tried but when you do that you get an error (attached)

Thanks for the advice not 100% sure what you meant but i think thats because my original post may not have been very clear. I have attached an example of what i have done so far. What i am trying to achieve is the Total downtime minutes for each of the different reasons for downtime when you run...

I am trying to display a series of totals in a report footer which are made up of calculated fields in a query DtMinBreak: IIf([Reason]="Break",[DownTimeMins],"") The query runs correctly and when I view it the relevant data is there for each row. Therefore I thought it would be a simple...

Stef Thank you very much for the replies the examples you sent were great and I have learnt a new trick which is simple and very effective. Hope life is treatng you well. Regards Adrian

Hello everyone I have read the FAQ on cascading combo boxes and have managed to apply the theory to my DB's data input form (frmDataEntry) which is very cool and prevents a lot of errors however in doing so it no longer populates the underlying table (tblProductionDetails). I am at a loss as...