Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Cricker

  1. Cricker

    Send e-mail from access databases

    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...
  2. Cricker

    Can someone help with the margins

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

    Making a form EXE!!!!!

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

    Closing Sub Forms on a Form!!!!1

    Darrylle; Run-time error '424' Object Required cw
  5. Cricker

    Closing Sub Forms on a Form!!!!1

    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...
  6. Cricker

    Nee d some Help with QUERIES!!!!!!!!!!

    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...
  7. Cricker

    Using Access and Outlook - SENDING EMAILS!!!!!!

    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
  8. Cricker

    Certain Selections within COMBO'S!!!!

    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...
  9. Cricker

    Using Access and Outlook - SENDING EMAILS!!!!!!

    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...
  10. Cricker

    Need to send MASS EMAILS!!!!

    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...
  11. Cricker

    Problem with Email push button!!!

    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...
  12. Cricker

    Want to know if I can do this and how??

    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...
  13. Cricker

    Problem with Email push button!!!

    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...
  14. Cricker

    Want to know if I can do this and how??

    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
  15. Cricker

    Want to know if I can do this and how??

    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

Part and Inventory Search

Back
Top