Search results

Again Thanks in advance to the communities help in furthering my understanding and learning of access... After some helpful replies in regards to the DCOUNT function I am still having troubles... So I can get my formula to work with =DCount("*","Client","[StockTypeCIT] = 'ROCK'") This...

:confused:Hi All, So again thankyou, in advance for help given in regards to this query I will simplify as much as I can on my ongoing learnign of Access so my question is this. I have a form lets call it 'Customer' and I have a table called orders how can I write 'Excel like' Countifs and...

Thanks so much, was trying to do this manually this certainly helped! Been so many years since I used access to any degree... Have one further question is it possible to embed the subform onto a single tab on my 'client' master form as at the moment the linked subform is on every tab?

Good Afternoon After a few days of not hitting any problems with my build I am now again here to ask for help... I have a master form lets call this 'client' and a subform which we will call 'orders' on each form is 'account number' Each form updates a different table 'client' updates...

Thank you so much! As soon as I read your reply I realised how foolish I had been, can't thank you enough! :)

Hi everyone, I have an after update event that populates, Date, Time and User into corresponding fields when the record status changes to closed. However... Whilst the information is recorded on the form it does not record to the underlying table is there any reason for this, or anything...

O.k Well I am now getting there, I have update a mixture of the code supplied by both of you and have the form now populating the time time the record was closed, the date the record was closed and the user id of the person who closed the record... I really appreciate the help thus far and if...

Appologies for only just returning to this issue, Thanks for the advice I have tried to apply this to my database sadly the field is not updating... Is there anything that could be preventing this it is driving me crazy! Regards Richard

Hi Guys I have a form in which I want to capture today's date when another field on that form is changed from active to Closed. In excel I would write an IF statement but can't get my head round what I would do in Access to achieve the same result. basically it's if (field name...