Search results

i'm writing a function to send an email with the option of attachements in microsoft access using vba. This is the code i'm using, it works fine but i need to be able to sne mulitple attachments. What would be the best way of doing this? Thanks code: Public Function SendEmail(strTo As String...

i'm writing a function to send an email with the option of attachements This is the code i'm using, it works fine but i need to be able to sne mulitple attachments. What would be the best way of doing this? Thanks code: Public Function SendEmail(strTo As String, strSubject As String, strBody...

i'm writing a function to send an email with the option of attachements This is the code i'm using, it works fine but i need to be able to sne mulitple attachments. What would be the best way of doing this? Thanks code: Public Function SendEmail(strTo As String, strSubject As String, strBody...

I'm using this code to send an email. How do i disable the outlook message A program is trying to automatucally send e-mail on you behalf. Do you want to allow it. Dim OutApp As Object Dim OutMail As Object Dim strbody As String Set OutApp = CreateObject("Outlook.Application")...

I'm writing some code to add a comment box into excel. How do i get it to add a multi line string into the comment box without showing a box at the end of each line. I used vbCrlf, is there another way? Thanks

I'm writing a form to filter a listbox by what is entered into a textbox. I need it to requery the listbox when the textbox changes on (keydown) but it does requery on any of the textbox procedures eg keydown onchange keypress etc. Is there another way of doing this. I can't understand why it...

How do i create a context pop menu in vba. I need to be able to right click on a listbox on a form and then have a pop up menu display several options. Does anyone know how to do this. Thanks

How do i create a context pop menu in vba. I need to be able to right click on a listbox on a form and then have a pop up menu display several options. Does anyone know how to do this. Thanks

I need to make a form close when you click off of it

I've created a popup menu form to be loaded when you cick on another form. I need to know how to get the popup menu form to close when you click off it. I've tried using lostfocus and deactivate but that didn't work. Modal is set to no. What code should i use and where would it go?