Search results

  1. E

    Select Next Record

    Hello PNGBill, Thanks very much for all of the information. Unfortunately, I'm having difficulty understanding all of it. In Step 2 how do I add 1 to the GradeAttempting field? In your 2nd Post you provided information re. FindNext and FindRecord actions. Do I run these commands agains the...
  2. E

    Select Next Record

    Hello, Is any additional information or clarification required? I really would appreciate some assistance. Regards, Chris
  3. E

    Select Next Record

    Hello, I'm not sure if a query or code is the best method to accomplish what I need. I have an Access 2003 database with a main form, Members. On this form I have two checkboxes labeled Ready and Active. I also have a combobox, GradeAttempting. Currently the control source for the combobox on...
  4. E

    VBA Doesn't Open Mail Merge Word Document.

    Well this is embarrasing. It turns out that my path was incorrect. I changed the path to "K:\My Documents\Email Receipt.doc". Now when I run the code the mail merge document opens without error. Regards, Chris
  5. E

    VBA Doesn't Open Mail Merge Word Document.

    It turns out that I was wrong when I stated that when I run the code Word opens but not the document, "Email Receipt.doc". Nothing actually happens, including no error reported when I run the code. If I change the filename to any regular document then everything runs without a problem. Any...
  6. E

    VBA Doesn't Open Mail Merge Word Document.

    SOLVED:VBA Doesn't Open Mail Merge Word Document. Hello, I have an email mail merge document, "Email Receipt.doc" that I created in Winword 2003. In my Access 2003 database I want to open this document from a command button on my main form. I added the following code. Dim objWord As...
  7. E

    Need module to add dates to report.

    I'm surprised that no one has responded. Any suggestion on what information I need to provide to have this move forward? Chris
  8. E

    Need module to add dates to report.

    I've spent quite a bit of time searching this forum and others to see if something similar has already been done and so far I've found nothing. Then again I'm not a VBA programmer so I may have stumbled across it and not have recognized it. I have found similar posts in this forum but none of...
  9. E

    Need module to add dates to report.

    I've attached a sample database that only contains the attendance report. Hopefully, this will give everyone, who might be able to assist me with this, an understanding of how the report is designed. Especially the column headings that I want to populate with the required dates. Please let me...
  10. E

    Need module to add dates to report.

    Hello DCrake, Thank you for you reply. I am using a select query. Here is the SQL view. SELECT DISTINCTROW Members.LastName, Members.FirstName, ClassTypes.ClassName, Members.Active FROM ClassTypes RIGHT JOIN Members ON ClassTypes.ClassTypeID = Members.ClassTypeID WHERE...
  11. E

    Need module to add dates to report.

    Would anyone have any pointers? Chris
  12. E

    Need module to add dates to report.

    Hello, This is actually a continuation of the following post. I thought that it might be cleaner if I started a new post since the original one is several months old. http://www.access-programmers.co.uk/...d.php?t=157053 I have a database that I use to track student's personal, grading and...
  13. E

    Sorting Issue

    Hello, I apologize for the late reply, however, today was my first opportunity to work on this issue again. I was able to resolve the sorting problem. I added a sortfield to my GradeTypes table and then added the new field to my reports Record Source query. Finally, I added SortField to...
  14. E

    Sorting Issue

    Hello, I have a report with a Group Header, GradeAttempting, that I want to sort in the following order. GradeAttempting Junior 10th Kyu Junior 9th Kyu Junior 8th Kyu Junior 7th Kyu Junior 6th Kyu Junior 5th Kyu Junior 4th Kyu Junior 3rd Kyu Junior 2nd Kyu Junior 1st Kyu Junior Shodan-Ho...
  15. E

    Date Range

    Hi Brian, I implemented your recommendations and this is what I ended up with. SELECT [LastName] & ", " & [FirstName] AS [Student Name], Count(tblAttendance.AttendanceDate) AS Attendance, GetDays([Enter Start Date],[Enter End Date],"46") AS [Total Classes] FROM Members INNER JOIN...
  16. E

    Date Range

    Thanks Brian, I added Members.Active to GROUP BY and now the query runs. However, I don't get a total COUNT of Attendance per Member. What I get is the name displayed multiple times with a Count of Attendance showing 1 for each line. To clarify, if I run the query from 01-Sep-08 to 31-Oct-08...
  17. E

    Date Range

    Thanks for the replies. I tried Brian's suggestion and I get the following error when I run the query. You tried to execute a query that does not include the specified expression 'Active' as part of an aggregate function. Any thoughts? Regards, Chris
  18. E

    Date Range

    Re: Date Range - SOLUTION :D Success!!!!! After many hours of trial and error I finally have a query that gives me the desired results. What I had to do was create 2 querys. Query1: SELECT [LastName] & ", " & [FirstName] AS [Student Name], tblAttendance.AttendanceDate AS Attendance...
  19. E

    Date Range

    I created the following query to count the AttendanceDate. SELECT DISTINCTROW Members.FirstName, Members.LastName, Count(*) AS [Count Of tblAttendance], Members.Active FROM Members INNER JOIN tblAttendance ON Members.MemberID = tblAttendance.MemberID GROUP BY Members.FirstName...
  20. E

    Date Range

    Hello, GetDays is a Public Function that counts the number of Wednesday's and Friday's within a date range. I also need this query to count the number of AttendanceDate that a student attends during this same period. In other words the dates that I enter for the GetDays function also needs to...
Back
Top Bottom