Search results

Constructive advise would be appreciated for my question . I have created 3 queries . Query 1: counts Source = Product Transfer yearly. Query 2: counts Source "Not Product Transfer" yearly. Query 3 is the combined result of query 1 and 2 . Is there a more efficient way to produce the results...

Bob, thank you for your interest, I had a light bulb moment and realised the date I was trying to save was todays date and all I had to do was append Date() to the completed date field in the task .Problem resolved not solved Moke and Iscaac thank you for you input Regards Ypma

Thank you Moke, You are correct I am using a combox . I have entered If Me.Dirty Then Me.Dirty = False after the if code to insert the date , this is followed by the run append query . ,but the append query requires this date which has not been saved as the me.dirty appears to be ignored...

I like the sound of your suggestion and will work on it. I need my beauty sleep so will attempt your suggestion tomorrow. Regards Ypma

Isaac, thank you for responding to my post. I have tried using the Before update event, but still have the problem of not being able to save the record within that event . I can save the record on the lost focus event, however that is too late for the append query to run correctly as I stated in...

Hello fellow access users. I am attempting to save a record within script of the after an update event to allow another procedure to take place based on saved new details of the field Example: On the status changing to Completed, today date is inserted into the Date completed field of the...

Hope this helps File options Current Data base Regards Ypma

I am a happy bunny! It works just how i desired. I did make one small change in that i used " if sentOnbehalfofName = true as apposed to if sent fromshared = True Thanks again Regards Ypma

Thank you sxscheck , please advise based on my post 1 where should i insert the code you provided ? Regards Ypma

Not a fair comment as i apologised in advance see my post 1 , remind me how to add tags would have been friendlier

Thank you theDBguy for you quick response . i have not tried that , Minty and theDBguy, suggestions tried , however when email arrives the reply tab still wants to reply to the default sender . Any other suggestions ? i have tried printing on the Email Reply to the following email address...

By default, the email replies go to the email address that sent the email. I wish the reply to go to the enquires desk, email address. I have tried entering, dot reply “email address” in the code ,but without success . Any guidance on how I can achieve my aim would be appreciated #.To = Email...

jdraw: Thank you for putting your point of view across, i am guilty of expecting too much from the professionals members within this forum whom i hold in the highest esteem. In my own mitigation i am a part time user and help friend and family who use Access . As i approach my 80th birthday...

MajP. You are correct i failed to use Cancel = True?. i am marking this post as Solved to avoid any more flack from jdraw. Regards Ypma

JDraw. Thank you for your advice. i mistakenly thought my initial post was self explanatory,which it obviously was not . i will approach the problem from a different angle and if successful, i will this post as solved . Regards Ypma

Uncle Gizmo : Thank you for your reply. Not quite what i am trying to achieve , i wish for my procedure to cancel and not save the change,. if the answer if Yes and only resume if Answer is No . My coding seems to resume, even if answer is Yes . Should i be placing the script in on click event...

Seasonal Greetings . i have a small procedure error . The scenario is when a states is change to Booked . After update, actions programmed work as expected. I now wish to place a before update question and if the answer is Yes the sub is exited, without saving the status Booked. Private Sub...

Moke123. Thank you for your solution . Alas Access2010 appears to be working with access 2003 . i have thoroughly enjoyed seeing the cross fertilisation of ideas from a number of member. For me as a user, the post was very enlightening and instructive . Happy New Year to One and All...

IsladDogs: Fair comment, however it does recognise o'brian and changes it to O'Brian . Also macdonald becomes MacDonald. # If Mid$(strUpper, I, 3) = "mac" Then ' Make the "M" upper case Mid$(strUpper, I, 1) = UCase$(Mid$(strUpper, I, 1))...

Moke123 : Thank you for you comments you hit the nail on the head , point taken, i was just addressing the two desired outcome requested. Will also test further. Regards Ypma