Search results

vba_php: Not sure why you appear to have a dig at my post. It was posted as an alternative . If you have some constructive criticism i am always willing to learn. Ypma

Access2010 . When i was using access 2003 i used a Function which was called in the after update event of the field Full-name. I have included it as it answers both of your desired outcomes. This is just another way to skin the cat.. I Know some of the experts will not open attachments, so if...

Have you tried adding an or eg :TextField IS NULL OR TextField="" Just an idea Ypma

Mark_ Thank you very much, your solution worked without the EVAL without any problems ,putting inverted commas around the + sign and the extra zero after the column.(0),0) did the trick. Regards Ypma

Thank you for your response. 1 TheDbguy the Hashtag are not part of the control source ,referencing the control source with me.listbox was not accepted. Mark, i think you have a point , as the result I receive from my effort is indeed concatenating, So how i can i avoid that. The results of...

Please point me in the right direction . i have the results of four separate list boxes in four separate text boxes, No problem. I Now wish to add or sum of the four totals into one text box . i have tried the following in the control source of the text box : #...

Beti, as stated it is not common practice to store calculated field in tables , however you have asked the question. One way would be to set your control source to the field in the table and place your formula in the click event of the form field ' #Private Sub txtAmountRemaining_Click()...

Gasman, Just the result i am looking for . Can i request you upload my Demo with your updates included . Thanks for staying with me, don't confuse me with some who know what he is doing ./ Regards Ypma

Gasman: Thank you for the code , it probably needs tweaking as it opened up outlook,but did not send the emails.i have saved my demo as a ms2003 and hope you will be able to open it and solve my problem. Hopefully Ypma

theDbguy: Thanks for your suggestion i am hopeful that the rs!FFIDNO is inserted somewhere into the script. On entering your suggestion I receive an error message "Run time error" 3021 No current record. Clearly it does not like it have you any further idea's ? Regards Ypma

Gasman: sorry about the snippet. here is the full code from the send email command button. Private Sub SendeMail() Dim rs As Recordset Dim vRecipientList As String Dim vMsg As String Dim vSubject As String Dim vID As String Set rs =...

GasMan: Thank you for your input. The test example only shows three records , however there are nearly 200 team members. I was trying to give the user the ability to ask members to quote their id if replying . I have in the past used word merge and then send email from the word document . So...

theDbguy: Yes , the id is included in the query!! its the email addressees that are being picked up in the loop. I know some of you professional are not happy about opening up database , but i cannot show you my problem any other way. Regards Ypma

pbaldy: Thank you for looking at my Post. i fully understand that i must some how pull my FFIDNO into the body of the SQL. The how is what is stumping me and would appreciate a little more guidance . the following is part of the script . # Set rs = CurrentDb.OpenRecordset("SELECT * FROM...

In a previous post I received assistance in creating a module to send email message to a rs of members. This work well , but i would like to place an individual reference number for each email to enable me to ask the member to refer to it when responding. I assume this would require an extra...

theDBguy: You were right all along. I was having one of my many senior moments. i just could not workout why i should put my email address in, hey ho it works fine. Many thank again Regards Ypma

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