Recent content by zashmore

Hi All, I have searched and searched, and searched some more. I still cannot get this to work. I have a simple Table of - [IDNo] [PaymentNo] [PaymentDate] [PaymentAmount] I want to create a running total in a query for each IDNo. What's the best way of doing this? DSum? Crosstab? Please help.

Ok I've done this and worked ok. However, I need to be able to Sum it all together in a report footer. What's the formula for adding it all together?

Hi All, I need to be able to have the staff in my dept. record their visits for the month. I have one query which works out how many working days per month for the next two years. I am having difficulties knowing where/how to enter the physical data. I have 7 members of staff that need to...

Hi All, My boss has asked me if I can change the visit log spreadsheet into a database to provide better reporting of time. I have attached an image of the spreadsheet and I need to turn this into a dbase. To be honest I have been racking my brains trying to think how to do this. I know...

Hi All, I have searched, and searched again but what I need is not here, unless I am being a plank. (Which is highly probable!!) I can find out how to query working days between two dates but what I need is slightly different. My staff fill in a spreadsheet at the moment with the visits...

Thanks all for your replys. By the time it took me to log back in to see the replys I have done them by hand. Good to know for future reference though. Thanks again.

Sorry to be a pain the A** and getting you to do the work but how would I input that? Cheers

I've looked but cannot find my answer. I am changing the way my works record repairs. At present they are using an excel worksheet but I said that Access would, of course, be much more productive. I have transferred 600+ addresses over but as it's previously in excel everything is in one...

Thanks For Your Reply Thanks for replying but nothing seemed to be working so I changed the format completely. I changed from a combo box to yes/no ticks and this is now the code which works A1 :D:D - Private Sub AgencyRefused_AfterUpdate() If Me.AgencyRefused = True Then...

Will i still need this bit? - Private Sub SetControlVisibility() Dim ctlToShow As Access.TextBox Me.WhyNoContact.Visible = False Me.WhySupportRefusedbyTenant.Visible = False Me.WhySupportRefusedbyAgency.Visible = False Me.SupportWorkerName.Visible = False Cheers

Unfortunately not No, just tried that and same error appears. Any other ideas or shall I give up and try again!!!:mad::mad: Cheers

I don't know what I'm changing to what. What's the name of the control that I need to change. Thanks

Confused!! :confused::confused::confused: Sorry, having a dim moment but i'm now very confused!!

Still got problems Thanks for that. I still have problems. when I input your code and try to run the form an error message appears "run time error '91' Object Variable or With Block Variable not set. When entering code screen "ctlToShow.Visible = True" is highlighted. Any ideas?? Cheers

Hi all, Thanks to the help previously I have managed to create a Combo Box to select information. I am getting good at this!!! On my form I have details of customers and my combo box allows me to update their progress. Once updated a new text box appears, which remains not visible, to allow...