Recent content by Lennie

HI everyone I currently have below code in my on change event. Intention is to show partial matches to customer names as the user types so the user can select or if exact match to select match which will then populate my form. If Me.Combo119.ListIndex <> -1 Then Me.Form.Filter = "[Full...

HI, need help please. I currently have a form with below code that puts records generated from a search into the body of an email. The problem with below code is the table with the record is not in proper tabular format. Can someone please let me know what i need to add to the code or if certain...

Thanks for the suggestion Gasman. i saved the logo and the signature template in a common location and it is now working. Much appreciated for your assistance

i think what i was originally asking is the image associated with the signature. The signature bit for every user comes up with absolutely no issues. The image or the company logo at the bottom of each user signature is the bit thats missing. When the outlook window pops up, the bottom of the...

Hi Gasman you had C:\users\paul\appdata\roaming\. That "Paul" bit is always different. I replaced signImage=environ("appdata") and it does not bring the image on my signature.

thanks for looking at this June7 and Gasman. Tried using both "appdata" and "username" but didn't give me the result i'm after. THANKS guys

HI I currently have a code that will currently attach my signature on outlook together with the image. The issue i'm facing is that the image is specifically reading the image from my username directory. Please see below code under row signImage = "Lennie_files". If another user uses this button...

oh wow works perfectly. Thanking you so much Cronk. thank you thank you

There is a date filter that a user can enter and search by. The records on the form will be data between those dates.

thanks for looking into it Cronk. I changed it to what you suggested but still gave me the same results ie still displaying the entire query as opposed to just the records on the form

Hi, was wondering if someone can please take a look at my code because it is not giving me the output on the email body. Basically i have a button on my form that on the event it is clicked it should export all the records on the current form to the body of my email. The problem with my current...