Search results

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...

Cool! Looks good to me. Will try it out. Thanks very much.

Hi all, I have a form with a combo box with the following selections: No Contact Support Commenced Refused by Agency Refused by Tenant What I want sounds simple, if i select one of these, for example, Refused by Agency a form pops up and asks to input reasons why. Or if Support Commenced is...

Sorry Rabbie Sorrie Rabbie, I was writing whilst you were replying. I have done that and it now works fine. Thanks for your help!!

I'll try and explain This is what I have got on the query - (Referral Date 1) set to between [Start Date] and [End Date] Another Expr to group them into Month Numbers. So in my Report I have a text box for Expr1 and another for =Count[Referral Date 1] What is the formula to total all of...

Not Working!! Thanks Rabbie. I've tried that, but it still does not work. The problem is that when I open the report I have pop-up boxes which asks you to input two different dates. When I try your formula, another pop-up appears and asks for the monthly total?? Any help again? Thanks