Recent content by ler1992

  1. L

    Sending Emails

    Attachments Does anyone know how to add an attachment with using the SMTP method?
  2. L

    Select Records For Report Not Working

    Pat, With the syntax strID = "vendor_id = " & rstVendorID.Fields("vendor_id") my strID variable is set to "vendor_id = 1181" (1181=the vendor id in the table) this, generates a "Data type mismatch" error With the code I have, in debug I can see that the value of strID is being set correctly...
  3. L

    Select Records For Report Not Working

    I added DB_OPEN_DYNASET to the Set rstVendorID = CurrentDb.OpenRecordset("tblVendorID") line but got the same results. Other ideas?
  4. L

    Select Records For Report Not Working

    Can anyone tell me why this isn't working? From frmMenu the user clicks button Generate Report. In code I want to read the value of field vendor_id from table tblVendorID and put it into variable strID. I want to use this variable to open report rptApprovals. This report's record source is...
  5. L

    For Each

    For each record in a table I want to perform a series of statements, including sendobject via e-mail. Below is the help example. I know the group section of the statement is my recordset but I'm not sure what the element would be. For Each element In group [statements] [Exit For] [statements]...
  6. L

    For Each

    Can I use the For Each statement for each record in a table? If so, can you help me with the format of the statement? For Each record In Table!tblVendorID statements Next ??? Strugling with VBA Lisa
See more
Back
Top Bottom