Search results

munkeyroot, This question was asked Yesterday and The DOC MAN responded , its worth a read. Regards Ypma

Colin, I have a cd " Running Microsoft Access 20000 Pt No 0970002173 for windows NT/98 if this would be of use I will try and zip it and send to you. Bob

in addition to PBaldy's advise. Have you considered using the hide duplicate option in the properties drop down of the each field . Plus grouping by in the header and footer' I have had a play with it and will upload my effort , which is not perfect, but might point you in another direction to...

Firstly thanks to all who responded to my request. In the end I achieved the result I desired as follows; 1 Created flyer in word 2 Merged the word doc to my database query , which contained the record set and the email addresses of the clients who need to receive this flyer. 3. Clicki...

Mark Yes please , I had not thought of a PDF . I use the word merge, all the records in the records set are available but am only able to send an email to the first record in the record set. The field in my code example EMAIL is the name of my email field . hence to email . Hope my...

Hello Mark_. The code I posted works fine by using a word document linked to the query record set and the record set had only one record so only one email sent . I am now trying to learn how to send to a number of emails addressee which with the advise received , but although it sends emails...

Pbaldy and Cronk, thank you very much for you very useful suggestions , I have one small problem where should I insert the additional code into my Function ? Would it be after the Send ? Regards and thanks again Ypma. I think I have got it and that is insert the code before the With itm ?

Good evening I require a little help in my email function . The following function sends an email to the first email address in the recordset I am trying to add a loop so that all the email addresses within the recordset receive this flyer. Plus each address is not aware of other addressees. So...

CJ, Thank you for your response, I only showed a couple of fields in my post , these records are imported and the Import number is the source providers ID , The id for each record is shown on my working query , sorry about that . I am only trying to fine duplicates of phone numbers to enable a...

Good morning programmers, I am happy with using the query wizard to find duplicate records which informs me the number of record that are duplicated, is this case the field was Phone numbers. What I am trying to achieve is a result that shows each record that is duplicated. Home Number...

Ridders. i have thrown in the towel on my effort and appreciate your valued points. It was only a trial and error on my part to see if i could be done ,but i have learnt something in the process which cannot be bad. Regards Ypma

Ridders , i can't dispute your calculations and have amended my function from MOD 7 to Mod 24 + 1 and it seems now to work is so would this be a fees able alternative to the public function , which i understand could be call for other date differences . I am only trying out different way of...

Arnelgp . i have been following this post and would like to know why a code in the control source could not be used or am i missing something ? #AgeAtDeath =DateDiff("m",[DOB],[DOD])\12 & " year(s), " & DateDiff("m",[DOB],[DOD]) Mod 12 & " month(s), " & DateDiff("d",[DOB],[DOD]) Mod 7 & "...

Rainbows . i am just a interested observer and notice your txt target date is named "Date Due " and your code should reflect this field name not the control name which differs Regards Ypma

Reshmi, i am no expert, and not sure what you mean by does not work , if you are trying to save as a ACCDE file have you tried pressing F11 to display the tables ,queries etc ? Other members might have other thoughts so please jump in . Regards Ypma

B Mart. Little confused as i did not reply on the subject post and cannot see y our post . Must have been bob fitz. You addressed you post to Bob and there are a few of us about . Regards Ypma

Ridders thanks for your time. Beetle, restricting clients who don't wish to to be contacted from the data source may be my best bet. The saga begins from the switchboard when users are trawling for old clients who's mortgages iare coming to an end, this is achieved by using a search key on the...

Ridderes and Ranman256 thank you very much for you prompt response. however i now know that any thing after the exit sub will not be executed senior moment , but back to my main problem , in that i cannot close the current form using the close form code within the On current event. please...

Greetings fellow access users. i am trying to close a form, from the on current event . i have the following code. #If Me.NoFuthercontactdesired = "Never" Then MsgBox " This client has requested not to be contacted." 'DoCmd.Close objectType:=acForm, ObjectName:=Me.Name Exit Sub Forms("Main...

Liz Johnson, my first thought without see your query, is that perhaps the totals field of the query does not have group by for "SalesandUseTaxNumber"otherr members might have further suggestions Regards Ypma