Search results

Hi Elweb I dont know a thing , But I will have a play with youre code :-) I shall drop a reply and let you know how I get on :-) Thanks Jimmy

Another question on how might be the best way to do things with dates ? I have a simple database which is a fault database. I get an email request to investigate something and I log it and give it a ticket number. If I email back , I put the comments that I sent in the email in the update...

Hi neileg Ok now all sorted. Chuffed, many thanks for this. Its really sorted me out. br Jimmy

Hi neileg Still trying to use the expression bulder to do this. Can I confirm some action points with you ? So I have a form based on a table or query. Say I have a field within this table or query called "count" This is a field that has a value of 1 , so every time there is a new record...

Hi Neileg Can you be more specific ? For instance I have a table that has filed of different colours Red , green , blue If I create a form from this table , Do I build an expression to show the dcount total of these words , or a macro , or code ? That's what I'm struggling with. Can I use...

Hi Folks More questions from the newbie :eek: I have a very simple table with a field that will have only the values open or closed I created a query based on this table and used the count function (to count open or closed cases) and in the next querie field I used the group by open. This...

Hi Elweb Thats great, i have used subforms before and I would like to thank you for the time and effort. Again manty thanks for this, It will do nicely Cheers Jimmy

Ok all sorted Private Sub OPENCLOSED_AfterUpdate() If OPENCLOSED.Value = "Closed" Then DATECLOSED.Value = Now() Else: DATECLOSED.Value = "" End If End Sub Cheers Jimmy

Hi I have an after update even on a field on a form. If the user selects Clsoed in obe filed it autoupdatwes another filed with the date and time of closure as follows:- However I need another statement (else), so that if he changes the status back to open then the DATECOSED FIELD is...

Hi Folks I’m a newbie here, so as usual it’s always followed by a plea for help. I’m From Scotland (live in Engerland) I used to dabble with access in 95 and I can see it’s changed quite a bit. I need a logging system for keeping details of faults that we have passed to various departments/...