Recent content by OSCSLeo

  1. O

    report based on 30 days

    Generate a query based with the following criteria Evaluation Date field < Date() -30 This will show you dates of evaluations greater than 30 days from todays date.
  2. O

    Problem with Acviewpreview

    I assume the punctuation you have between the DoCmd are typos. Why not cut and paste your code for others to view it and see if they are able to figure it out. HTH
  3. O

    How to append two memo fields

    you can construct a query that concantenates both memo fields then append it to the table you want to add it to. HTH
  4. O

    Email Problem

    You can use the following code to open outlook prior to executing your email Dim stAppName As String stAppName = "C:\Program Files\Microsoft Office97\Office\Outlook.EXE" Call Shell(stAppName, 1) HTH
  5. O

    Hide Zero Value Field/Column

    If your referring to fields that are blank In the criteria for the field that are required to be filled enter: Is Not Null If you really mean "Zero" or a negative number then in the criteria put: > 0 HTH
  6. O

    Due_Date field < 7 days away

    In your query due_date field try < Date()+7 HTH
  7. O

    Query by Recordset in a loop

    Thanks Harry that worked great. Appreciate the help.
  8. O

    Query by Recordset in a loop

    Harry, Here is the code from program, I feel Im almost there, I pulled out the email part, and did an open report instead while getting it to work. I believe Im having syntax errors in the Mystring. Thanks for the assist Private Sub Command4_Click() Dim MyRS As Recordset Dim MyQD As QueryDef...
  9. O

    Query by Recordset in a loop

    Thanks, Will give it a shot and let you know. Appreciate the assistance. Jeff
  10. O

    Query by Recordset in a loop

    Jack, Yes your right, but what I want to do with the report is email the individual's report to the person, so it would have to be a totally separate report, not a subreport. Sorry if I was unclear as to the intent. Jeff
  11. O

    Query by Recordset in a loop

    Thanks for the reply. What I want to do is print one record per report (separate report for each person, looping through the name list til each person has his report of missions he is assigned to.
  12. O

    Query by Recordset in a loop

    Here is more information The problem seems to be either I'm not getting the sql statement filtered by strName or if that is occurring. The events report does not see that as a recordset source..or the more likely conclusion Im all hosed up..grin... Help appreciated Private Sub...
  13. O

    Query by Recordset in a loop

    I have 2 tables a "Name" Table containing "LASTNAME" and "Events" Table containing "LASTNAME" and "MISSIONS" I have a query called "Events" I have a report that is based on "Events" which lists all personnel assigned to a mission. What I would like to do is print out a report for each...
See more
Back
Top Bottom