Search results for query: *

Bonjour!!!! I am having a little problem with sending emails. I have this code put in so far and it works fine but one thing is wrong... Actually 2 things. First I want to use a query so i can take only certain email addresses and send them to certain people. When i try a query i get an error...

Can someone help with the margins on a report. I would like to have them set permanently to .5". Thanks in advance cw

I'm looking to hoe to make a form .exe so the user can click on it... cw

Darrylle; Run-time error '424' Object Required cw

Bonjour!!!! I am having little trouble closing a subform. I have a Main Form with a Sub Form on it. When the Main opens i have the Sub Form hidden. when I click on a button I got the form coming up. On the Sub Form I have a button to (hopefully) close the Sub Form and have the original Main Form...

I have a database set up for peoples info (Name, Address, Phone Number and so on). On that form I have a Sub Form so I can put in there complaints when they call. There is Main / Sub / SubSub Issues. Now I want to be able to query Main Issues for PLANNING (one of many in the list). I would like...

ad2: Thanks for the info. I'm having one prob though. This line i'm getting an error message - qdf.Parameters(0) = _ Forms!FRM_Main!Command71 RUN TIME ERROR '3265' Item not found in this collection Do u have any idea how I can fix this?? cw

I am looking for some help with regarding Combo Boxes. I have 3 Combo's (Main Issues - Issues - SubIssues). When a user selects something in the Main Issues it all depends on what he/she selects that will be able for the Issues and so on with the Sub Issues. I don't want the user to c all...

I need MAJOR HELP!!! I have a database set up with people's personal info and emails. I need to beable to do a search (ex - evryone who lives on a certain street) and send them an email. Basically I need to be able to use a push button and then get all the emails that were found and place...

I have this dbase set up using Access 97. There is info for LOTS of people. I have a subform also set up on the mainform. I need to do a search for a specific item on the subform and be able to get EVERYONE'S EMAIL also. Got that done (through a Query). Now I need to get all those Email...

The database is for the use of 2 people. They need to find everyone with an email who lives in a certain area and on a street. Here is the SQL... SELECT ConstituentTable.ConstTableID, ConstituentTable.email1, ConstituentTable.email2, TBLIssueCategory.Issue, TBLsubIssues.SubName FROM...

Okay. I changed the form. The subform is now changed into a form not in dataview. These are the names: Main Form - ConstituentTable ** do u need this??? SubForm - QRYTEST Tables: TBLControl ** this is where i get the ID's for each to bring up the name - ID Number value...

I am using Access 97 and I have this push button that retreives Emails from constituents in my database. I also have a search set up for the Constituents Street on the Query; which works fine when I try the Query. A run time error comes up when I hit the button. Run time error '3061' To few...

Yes it's in Data sheet view. The fileds on the subform are Combo boxes. Yes, that is what I'm trying to do. But I have a form outside that to add more Main Issues, Sub Issues and Issues. Chris

I'm finishing off someone elses program. Not a nice one. They have a subform on a form that is a table with all those headings - Main Issue - Sub Issue - Issue. Each heading is from another table that all the info is inputted. Making sense??? Chris

Somewhat confusing but I'll try to understand it. I am using a Table format for the sub-form. So how could I use that for the table?? Chris

I have a form created and a sub-form on the bottom. On the sub-form I have a table for it with three headings. 1. Main Issue 2. Sub Issue 3. Issue Under each Main Issue there is a Sub Issue but only certain Sub Issues pertain to the Main Issue and same with the the Issue regarding the Sub...

This is my code for the Send Email... I have a query also set up... Like sometimes I have to search for people living on a specific street.... Sub SendEmail() Dim db As DAO.Database Dim rs As DAO.Recordset Dim qdf As DAO.QueryDef Dim strEmail As String strEmail = "" Set db = CurrentDb...

I have this database set up with a push button to send out Emails to people who have Emails. The server only lets you send out 165 Emails at a time. I need to send out sometimes up to 1500. How can I do this?????? Thanks cw

Sub SendMail() Set lobjOutlook = CreateObject("Outlook.application") Set lobjMail = lobjOutlook.CreateItem(0) Let lobjMail.Subject = "TESTING E-Mail" Let lobjMail.To = "mdjohnston@statestreetkc.com" lobjMail.Send End Sub This code works when I put in a person in...