Search results for query: *

I'm not sure that would help anyone but you're right I should definitely explain my solution. So here it is !! I just kept column 1 'emailname' as bound column and used the .column(i,j) to point to the second column for opening the detailed form i.e. DoCmd.OpenForm...

Well thx for your help again !! I managed to sort out my prob differently so everything works fine Cheers Marti

Thanx Redapples !! Sorry to get back to you so late but I was away for 3 weeks ! Setting the list index to 1 does the trick. Unfortunately I just found out I cannot use the EmailName in column 1. Well actually I can but I can't use the column 1 as bound column then. I need to have the column 2...

Hi all, I’m trying to create a report based on the results of an sql query. The sql query returns a series of result in a listbox called lstresults. What I would like to do is use this listbox as the source for a report . But I don’t know how to proceed ? My knowledge of access is still very...

Ok I've just tried your code. And it works fine ! Thx a million ! Unfortunately I have column heads in my listbox so when using your solution of having the Email column twice and hiding the first column, I get 'Email Name ;' followed by all the correct email addresses in the 'To box of Outlook...

Thanks Red Apples !! I really appreciate you took the time to answer. I will try your code and let you know how I got on.

Thanks for your reply readapple. I had looked at the other posts but they didn't seem to match my particular need plus I'm quite a newbie in SQL. So please bear with me OK so here is my code; Private Sub RefreshQuery() Dim SQL As String Dim SQLWhere As String SQL = "SELECT OrganisationID...

I have an SQL query that returns a list of contact names and other info such as email names. I would like to have a command button that opens up outlook and gets all the email names listed in my query results box (lstresults) in the "To" field of outlook. I could setup the opening up...

I've created a multicriteria search form for a contact management database. Now I would like to have a button on my form that would create a report based on the results of the search (lstresults). How can I do that ? Thanks in advance for your help Here is the code I'm using Dim SQL As String...