Recent content by eckert1961

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...

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

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...

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

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...

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...

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

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...

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...

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...

Would anyone have any pointers? Chris

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...

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...

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...

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...