Search results

theDBguy: Yes i did try your suggestion , but it still did not put any of the addressee in the bbc section of the email , to ensure blind copies . i am assuming i would see any bbc addressees on my sent copy. Regards Ypma

Gasman: Thank you for providing me with a link, however unless i am missing something it is not what i am after. i am using late binding to avoid references to Outlook . Thank again Regards Ypma

TheDBguy: Thank you for getting back to me , I think there is a misunderstanding . I will be sending to a number of members and don't wish the other member to see who else has had a copy . bcc I value you input so if you have another idea please let me know , i will take a look at Gasman...

Advice or suggestions would be appreciated. I have a sub to send emails to a number of members, which performs how i desire . There is a but and that is ,I need to send blind copies "bcc" How would I achieve my aim using my current script below: #Private Sub SendeMail() Dim rs As...

theDBguy: Most excellent, now i can continue with my little project. thanks again for your patients Regards Ypma

theDbguy: The £64 i quoted in my last should have been £65 , which is on the left of form Field Amount Due . This is only one record the other three instalment fields ignore ,as i will programme them once i have sorted how to get the £65 into the appropriate field, depending on if the check...

theDBguy: The 193 is the sum total of the fee paid from the three records which have all been checked as paid. I was using the Dsum expression to give me a clue on how to get the amount £64 in the new box, if the check box has been checked. Eventually i will be working with the instalments...

theDbGuy. Thank your assistance to date. I am happy to send a copy of my project. Note i am not a professional i just enjoy creating small database for my and friends and extended family. The form will open with the Flash screen . click Button "Details Form" In the general form , click fees...

theDbGuy: i liked your script , however it brings up an error . i did not think it required a Domain reference as i am only trying to total the active record . as mentioned in my original Op i managed to get the Dsum to work. if i wished to. just have the amount in the paid field i would have...

Thanks theDBbadguy . If there the check box is not check , the fee paid will be zero Hope this explains my question ? YPMA

Further assistance is respectfully requested . In my form i have field named Total Paid, I wish to have the amount amount Due reflected in the field if the check boxes has been checked when paid. I Successfully produced a Dsum #=DSum("AmountDue","FeeDueQuery","Paidinfull =-1")# Which...

Minty: Sorted many thanks . removing the brackets did the trick. Ypma

theDBGuy: Thank you for getting back to me. Your suggestion produced an error message ," the form named is not recognised. or does not exist. " I double checked the spelling of the Named form. Any other suggestions ?

Assistance would be appreciated. i have a Flash form which has a combo box , i am trying to open the Contact Details form with the record ID selected in combo box. My efforts open the form as a new record . # DoCmd.OpenForm "Contact Details", acNormal, "", "Combo288.column(0)=[Forms]![Contact...

Amir: Not sure from you example exactly what your result should be. If you are looking for duplicates IE Where Box and Product are the same ? Then use the query wizard to find duplicates. Hope this is of help to you? Regards Ypma Reread your post, and realise you want the product that is in...

CJ London, thank you for the Late Binding Link . Not tested yet, but it appears be the answer to my problem. Regards Ypma

Good Morning from the UK. I am currently testing out MS office 2019 on my home laptop. All seems fine even when I open a database created in MS 2010, all the References are updated from Office 14 to Office 16 , However when I try the reverse and open a database in MS 2010 ,created in Office...

C J London:Appreciated the fact that you had not tested it . i used the alternative code you supplied #Me.date_sent = date_sent + Time()# and the time zones do not match, hence my question. i am using UK time zone and when the using code produced a time in the future as shown in my post...

CJ London: As an exercise i tried your code in the after update event #Me.date_sent = date_sent + Time()#. I triggered the Now() resulting in 26/09/2019 17:10:42. I then used the date picker to enter today's date resulting in: 27/09/2019 04:50:55. Note, I am using UK time and date should this...

Pat, I did not fix my initial problem but worked around it. Normally I trigger a general date using the after update event.# eg me.dateconfirmed= now# My user wanted to be able to change this date by using the date picker, which of cause only produces the short date . Wrongly I thought i could...