Search results

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

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