Search results

Dank je wel Namliam for you comments, the demo was just a database to demonstrate the the question I was posing. The values would appear in a management report. As you can see I am not a professional programmer and only assist if asked by family members. For this project I will stick with...

Gasman, you have made a octogenarian a happy bunny , I am nearly at my desire outcome and will work with your solution. Many thanks Regards Ypma

Gasman, your SQL is almost there , however I need the Not PT sources to be counted as a whole and the PT sources separately. see below Desired out come ,without the dashes . Year--- Not PT----- P T 2019 ----1----- ---- 2 2020 ---- 6 ------ 2 I really like your script and have learn...

Namliam, Thank you very much for you response, its not quite the result I had in mind. As per my demo I only require two two totals per year . Example total for PR and total for Not PR , I hope this makes sense . If you would be so kind as to modify you SQL script so it reflect my result in...

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