Search results for query: *

Ok i have made some changes and have made a bit of progress. I created a new form and placed the "contacts query" and "seminars subform" as subforms. They have been linked together and it is working like it was before except now the contacts form is continuous. I understand what you mean...

Thanks for your great input. I created a subform based on my contacts query and used it to show the Seminar fields in datasheet view. This was all done using the wizard relating the subform to the main form via the contactID. I tested it out with some searches and it shows up the seminar...

I have two tables. One is a list of contacts named "Contacts" and the other is a record of the seminars attended by each contact "Seminars" which is linked to by the ContactID of the Contacts table. So there is one record for each contact but each contact may attend a number of different...

thanks for your help Remou. The code you gave me for copying the email names to outlook works like a charm. I managed to get it to work by creating a new query that was the same as "contacts query" except it only showed the email field. Everything is working as it should for now.

I've had a minor breakthrough now. If i change the query from "email" to "contacts query" it opens up outlook and copies over all the e-mail adresses. The only problem is that it copies duplicates and null entries. There were two ways i thought could fix this. 1. still use "email" as the...

All right i have been doing some reading up and have figured out that it is not working properly because the fields from the form that the query references were not defined as paramaters. Ihave changed the code to fix this but now get a new error Run-Time error 3066 Query must have at least one...

I changed the code like you suggested but now i am getting the same error, different message. too few paramaters, expected 1. Again i ran the query and it returned just the EmailName field with a list of e-mail addresses for every record in the database. The Search form was open when i did...

I have tried it with the form either open or close. Thus far i haven't noticed any difference. Generally speaking though the search form will almost always be open when the email button is clicked.

This is my SQL code for Contacts Query. PHV helped me out alot with writing it as Access kept on butchering my code. If i view the results of the email query in access in datasheet view all the details there are correct. SELECT Contacts.ContactID, Contacts.SalutationID, Contacts.FirstName...

thanks for the swift response Remou. I have tried the revised code and it runs without errors. The only problem is that it grabs the e-mail addresses for every contact, not just the contacts i have just queried. I tried something along similar lines by changing that one line to Set rs =...

Sorry for double post but yes Remou you are right in that i am wanting to send one e-mail to all those people.

On this line of code Set rs = CurrentDb.OpenRecordset("Email") i get Run-Time error 3061 Too few paramaters. Expected 19. Any ideas? The query "email" is based up "contacts query" so i'm thinking that may be effecting things. here is the SQL code SELECT DISTINCT [Contacts Query].EmailName...

I thought i replied here saying that the reason it wasn't working is because i closed the original form and thus the parameters were lost but obviously i didn't. Well anyway yes that was the problem. Funnily enough though if i close the search form and then export as rtf it still works. They...

ok so the FAQ I was looking at is available from http://www.tek-tips.com/faqs.cfm?fid=2921 And i have used this code thus far except i have omitted any code relating to the subject or body of the e-mail as I will not be using them. In the email field of the code i somehow have to get it equal...

I have this query which searches according to a forms contents and displays the results. Based on these results i have made another query that only displays the EmailName field and only unique values and values that are not null. Want i want to do is to be able to send an e-mail to all of these...

Had a look at changing the code to DoCmd.OutputTo acOutputQuery, "Contacts Query", acFormatRTF which brings up a box to type in the where to save the file. Unfortunately it does not work though as it asks me what value the query should have for each field as it is getting its data from an open...

OK so i have made a macro using runcommand and then the export command. Is there any way to make *.rtf the default from withing the macro or easily in VBA? thanks.

I have a query to select specific contacts that works great thanks to PHV. I want to export this data for use in a mail merge. I've seen some great posts on automatically sending the data over but what i need isn't that advanced. Basically i want a button that will replicate me going...

WOW! it actually works. Thanks so much, i guess i should probably learn SQL now.

Here is the SQL code. I hope it makes sense to you. As you can see i am searching many fields and the chances of all of them being filled out are minimal. SELECT Contacts.ContactID, Contacts.SalutationID, Contacts.FirstName, Contacts.LastName, Contacts.Address1, Contacts.Address2...