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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.