Search results

Hi Ive created a search form on Access to search for peoples names and email addresses. I would like to use the results of the query to populate personal emails in Outlook (or groupwise) in a similar way to the way MS Word mail merge works... i.e. a seperate email for each email address that...

hi thanks for this, I still can't get it to work because when the combo boxes are left blank the query takes this as a null value and returns no results(because none of the publications or status's are left blank). the like "*" is in there to help deal with this, it acts as my wild card, so it...

trying again...

ok.. attachment is there this time

ok, i am loosing the will to live with this one. i still cant get this working, i can set up the query for one publication but not for multiple selection. i have attached the database, as you can see frmemail has five possible publications, i cant get this to work. the user needs to be able...

The lack of brain power seems to have continued until this morning. how comes I have to quote the original table the combos come from, surely using there contents as the source of the criteria of a query that queries the original table anyway would be enough. my god im confused kind regards...

by [field] do you mean what i type in different fields of the criteria. I tried typing in one field all that you noted apart from the word 'field' as i did not know how it was applicable. im not sure my brain is working properly today.

thanks for this. is this something i type into the criteria of the query or in code somewhere on the form? thanks again.

not quite... if the combos are blank then they do not count towards the results, if they are all left blank then they return all records.. any ideas?

Hi I have been trying to set up this query via VBA code but, with no luck, have gone back to the query in design view. Basically the parameters of the query are determined by combo boxes in a form. This is fine if one combo box indicates one criteria but a problem arisis when multiple combo...

hi, i have checked the DAO box as guided. It doesnt seem to want to run beyond the docomand below, also for a while it was asking me for parameters even though the parameters are being set by the combo boxes. Private Sub Command10_Click() Dim db As DAO.Database Dim qd As QueryDef Dim vWhere...

the message is Compile Error: user-define type not defined This same message appears when i put the DAO on as well thanks in advance

Hi I have set up a form to run a query, setting the following VBA to pick up values from the combo boxes in the form. The only problem is that I cant seem to get this working. When i press the command button it won't even get past the Dim db As Database line. Private Sub Command10_Click() On...

hi this is a long shot but is it possible to set up a macro which will send a column (email column) from the results of a query into the address bar of outlook? I know how to import and export data to/from outlook but this is a new one to me. all help much appreciated!

Hi All I have set up a form to run a query. There are 3 main variables; 'Status', 'Substatus' and 'Publications'. The publications variable has multiple choices on the form as it is likely i will be sending out more then one publication at a time. What I need to be able to do is that if a...

thanks bob, ive done it!!!!! almost dancing round the office with relief! i had to rename combo boxes because access was expecting an = before 1ststatus so i just changed it to first and secondstatus. then refereshed the code pane (deleted everything) and started again, with...

Requery wont work in subform. Hi bob thankyou for your reply, I understand what you mean by when it is in the main form you need to add .form so the database knows to requery when in the main from. However, I still can't seem to get it working. I have tried variation after variation of the...

Hi all I have a problem locating where to put my requery for a subform and, also, how quite to type it. Here is the relevant information the drop down list row source in the second combo ( named "2ndstatus") is dependent on th1 1st combo ("1ststatus"), this is done through a query that I have...

hi I have set up a subform with two combo boxes, one dependent on the other linked through a query. the subform works when it is by itself but i get prompted to type in a parameter when i use the subform in the main form, i have no idea why. I am also having trouble setting the Requery on the...

combo box code not working. thanks for this, I have changed where appropriate and also set up the tables slightly differently to reflect one to many relationships, but i still can't seem to get his working. I have attached the DB with wider related tables. thanks in advance for any help...