Search results

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

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

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

Count Dates within Date Range Problem. Hello, I have the following query that I need some assistance with. SELECT [LastName] & ", " & [FirstName] AS [Student Name], Count(tblAttendance.AttendanceDate) AS Attendance, GetDays([Enter Start Date],[Enter End Date],"46") AS [Total Classes]...

Hello, I'm using the following code to calculate the number of Monday's and Wednesday's in a selected month. Public Function GetWeekDays(pmoyr As String, pdays As String) As Integer '************************************************ 'Purpose: Compute number of weekdays ' in the...

Hello, I have an attendance report that displays student names, count of attendance for the month and the attendance percent. See the attached pdf. Currently the report will display the data for every month but that will inevitably make for a very long report. What I would like to do is only...

Hello, I found the following code that I want to use in my database but I'm not sure how I can test it and implement it if it returns what I'm looking for. Public Function countday(dt_from, dt_to) 'this function return an array of 7 integer (1 to 7) counting the number of monday, tuesday...

Hello, I'm running Access 2003 and I'm having problems with an IIF statement that I have in one of my reports. Here is what I have so far. =IIf((IsNull([Forms]![Attendance Form]![ThirdDate]) Or (Val([Field43])+7>=32),Null,Val([Field42])+7) This statement works but not in the way that I need...

Hello, I am running Access 2003 and I need some assistance with an Attendance Report for a Student database. I only run classes every Monday, Wednesday and Friday of each month. I want to be able to open the report and have all of the dates for those days of a specific month be inserted into...

Hello, I have a workbook with multiple worksheets and I need to apply 4 conditional formats to cells, that contain a date, in column E, based on the following criteria. If the current date in column E: Is between 28 and 35 days from Today() Is between 21 and 28 days from Today() Is between...

Hello, I recorded the following macro that filters the active worksheet copies the visible data only and pastes this into a new workbook. Range("G7").Select Selection.AutoFilter Field:=1, Criteria1:="SWD Nearline" Cells.Select Selection.SpecialCells(xlCellTypeVisible).Select...

Hello, I am running Excel 2003 and I want to use a macro that will enter the current date in the format dd-mmm-yy and the text UPDATE! into the selected cell. The result should look as follows. 04-Aug-08 UPDATE! The problem that I run into is when I run the macro the date format changes to...

Hello, I have a spreadsheet that displays which students had perfect attendance for each month. What I would like to do is to count the number of times each student's name is found in the spreadsheet. I've tried to do this using the pivot table wizard but I'm having difficulty getting the...

Hello, I have a small anoying problem that I'm hoping someone can help resolve. On my main form I have a text box that shows the current number of members that are in the database. The default count is for all members whether they are active or inactive. On this same form I have a list box...

Hello, I have a main form that contains a combo box named ViewActive that lets me selective Active=Yes, No or when I double-click it all records are displayed. When I select Yes then I only see active students when I use the record navigation to scroll through the records. On the same form I...

Hello, I am using the following code which combines detail records from 1 table into another. Private Sub cmdAppend_Click() On Error GoTo Err_Handler Dim cnn As ADODB.Connection Dim rsStu As ADODB.Recordset Dim rsStuList As ADODB.Recordset Dim rsDetails As ADODB.Recordset Dim SQL...

Hello, I have a receipt report where I am trying to combine the details of a student's order onto 1 receipt. Currently if an order from a student contains 2 different items I will get 2 receipts containing the details for each item. All of the information contained on both receipts is correct...

Hello, I have a receipt report where I am trying to combine the details of a student's order onto 1 receipt. Currently if an order from a student contains 2 different items I will get 2 receipts containing the details for each item. All of the information contained on both receipts is correct...

Hello, I have a query that lists members who have outstanding payments. The results of this query are being used to populate a winword mail merge document. The problem with this query is that if there are multiple members from the same family who owe then I will get an entry for each of them...