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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Toolman29

    Can you group certain controls in a form via VBA?

    Is it possible to group only certain controls in a form and then call that group to change the groups formats. Example: Say a form has 20 text boxes on it and one combo box. Based on the User's selection from the combo box different text boxes are enabled for input. Is it possible to group...
  2. Toolman29

    Lotus Notes Email Questions

    I have used the code below before, works fine. But I have two questions: 1) In the line starting "Set EmbedObj = AttachME.EMBEDOBJECT(.......", what exactly is the 1454 and is there ever anything that could be populated in the item after 1454? Each time I've see this code it's always...
  3. Toolman29

    PDF995 Bypass Save As

    I'm using Microsoft Access. I've got some code that will take an Access report and using PDF995 will create a PDF. What I'm wanting to do is bypass the PDF995 Save As popup box and either: 1) Save the file as the default name and default locations (I can rename the file and location through...
  4. Toolman29

    Looping issue in VBA

    Hi PHV, I've attempted to change the send line from the BCC to the To line (.SendTo). No change, still sends three emails to the first records [EmailAddress].
  5. Toolman29

    Looping issue in VBA

    This would be what the code looks like now after changing it to your suggestions. I'm seeing three emails being sent, all going to the email address of the first record of my query. The only difference between what you have posted and what I now have is spaces between some lines (one before...
  6. Toolman29

    Looping issue in VBA

    What's posted is the actual code for the On_Click command of a button on the interface. Interface has just two fields "Subject" and "Memo". The query is pulling from a table containing thousands of records. Through the query I've narrowed the recordset to three records. Running the query by...
  7. Toolman29

    Looping issue in VBA

    Thanks again PHV. I moved the line under Do Until rs.EOF. Before moving the line, my Sent box would show one email record. After moving the line, my Sent box shows three records (all going to the same [EmailAddress] location, the first record of my Recordset/query). BTW, the first...
  8. Toolman29

    Looping issue in VBA

    PHV - Thanks for the quick reply. Tried your suggestion and am still getting three emails sent out (my test record amount) to the first [EmailAddress] record. Second and third [EmailAddress] records are getting none.
  9. Toolman29

    Looping issue in VBA

    I'm needing some help with a small piece of code. I'm tring to send out an email through Lotus Notes, using a query that defines the emails to send on my bcc line. I've got everything working except for the loop. The loop current will go through and send the correct number of emails for the...

Part and Inventory Search

Back
Top