Recent content by Rick-K

Great news Norm, glad I could be of help (albeit maybe more help without the typo's :) ), for me the only thanks I need is knowing that your issue is sorted and that I have been able to put something back into this forum as a way of thanking them for what I have already got out of it, I have...

Hi Norm, seems you have found the flaw in my idea of using on entry as the event. If you advance to the next record while that is the current field it becomes the current field in the next record. Idea 1 use the double click event instead, that way the date won't be inserted unless you double...

Hi, I'm pretty sure it doesn't need to be saved in between, I think the error is in my typing, there should be a space between the quotes at the end of the Iif() function or alternativly use Bobs much neater MN = Nz(memorandum, " ") Sadly I can't test it at the moment as Apple have not brought...

Hi Norm, reading this on my iPhone which doesn't show the attachments, can you copy and paste the code into the message please. Rick

Thanks Bob, you spotted my deliberate error too :). I put the IIF() in as well because otherwise he may get an error if Memorandum is Null Also, obviously it should be Memorandum not MaintNotes, that's the name of the field in my database doh!!! Rick

Hi Norm No worries, that was me being lazy, only works in some circumstances, try using MN = IIf(Me.MaintNotes <> Null, Me.MaintNotes, "") That should do the trick Rick

Hi sorry, I obviously confused things by sending my procedure as is although some of it will not be of use to you . The Getuser() function is one of my own modules which gets the name of the user logged into the database so that this is recorded along with the date and time. Unless you have a...

Hi admsvcs I had exactly the same query as you which I originally got round by using a temporary field to enter my data in and then pasting in into the memo field with the current Users ID and date/time stamp, rather a convoluted solution but it did the job. Having looked at what was suggested...

Bob Thanks for the fast response, however I fear that will not work as surely it will return "01/04/2010" for today's date while I need "01/04/2011" However your idea was sufficient to unblock the thought process and this ="01/04/" & IIf(Month(Date())<4,Year(Date())-1,Year(Date())) Does work...

Hi, I have a very simple task that I am getting really confused over. I have a form which calculates the totals of various currency fields in records between 2 dates which can be changed by the user but which start at "default" dates when the form is loaded. The default end date is the...