User Profile

Collapse

Profile Sidebar

Collapse
axkoam
axkoam
Last Activity: Jul 6 '12, 05:17 PM
Joined: Jun 22 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • axkoam
    replied to Filter a Report Based on an Attribute a to be Emailed VBA
    in Access
    Thanks. This is the code I wrote for anyone following along.

    Code:
    Public Function parse_WorkflowNew()
    Dim rs As ADODB.Recordset, str_getSend As String
    Dim rs_Missing As ADODB.Recordset
    
    Set rs = New ADODB.Recordset
    Set rs_Missing = New ADODB.Recordset
    
    rs_Missing.Open "Select Mfg_Cd from q_AuthToRoute Where [E-Mail] is null Group by Mfg_Cd", CurrentProject.Connection,
    ...
    See more | Go to post
    Last edited by axkoam; Jul 3 '12, 05:48 PM. Reason: Clarify information.

      Leave a comment:

    • axkoam
      replied to Filter a Report Based on an Attribute a to be Emailed VBA
      in Access
      Is the filter a query? Or does Access have something special designated for filtering? I'm a little confused here.
      See more | Go to post

        Leave a comment:

      • axkoam
        started a topic Filter a Report Based on an Attribute a to be Emailed VBA
        in Access

        Filter a Report Based on an Attribute a to be Emailed VBA

        I'm using Windows 7, Access 2007, Outlook 2010

        Background:
        My situation is that I have a report that I need to email out to different people using vba. I've written the script to generate the email, attach the report (actually in the body of the email) and send it to the correct people.

        Issue:
        My issue is that I want to send only the relevant records from the report to each person. I've put the relevant...
        See more | Go to post
        • axkoam
          started a topic Filter Access Report to Email, Relevant Records Only
          in Access

          Filter Access Report to Email, Relevant Records Only

          Microsoft Access 2007.

          Background: I have a query that received work orders from out client system and runs them through access. Once in Access, an employee goes through the query output and organizes the records (mentally) by product_code. There can be be 1 or more records of a certain product_code and there are 129 total different product_codes. Say, a typical time the employee runs this query they might see 25 different records...
          See more | Go to post
          No activity results to display
          Show More
          Working...