Recent content by upsman

I would like to print a picture on a report behind the report data. The picture prints fine on all pages of the report except the first page; I can't get it to show up on the first page. I have the following code in the On Format event of the detail line; If Me.Office = "home" Then...

Hi. I have a table containing student grades. This table contains grades for multiple school years and I use a field called 'SchoolYr' to select the grades for the year I want. I'd like to create one form with multiple tabs representing the different school years. For instance, I'd have...

Hello, I'm using the following statement as the control source for a field on a report to calculate number of absences in a quarter. Sum(IIf([NewAttendance].[Absent],1,0)) This works fine if a student has missed at least 1 day. But if they had perfect attendance that quarter, the field...

Here is my SQL if it helps: SELECT DISTINCTROW Students.StudentID, Students.AdminDate, NewAttendance.Year, CalcQtr1Days([AdminDate]) AS DaysEnrolled1, [DaysEnrolled1]-(NZ([DaysAbsent1])) AS DaysPresent1, Sum(NZ([NewAttendance].[Absent]))*-1 AS DaysAbsent1, Sum(Abs([NewAttendance].[Excused])) AS...

I have a query where I'm selecting fields from two tables - Students and Attendance. I have selected option 2 in my Join Properties, i.e "Include ALL records from Students and only those from Attendance where the joined fields are equal". The tables are joined by StudentID. Either I'm...

I am using a function to calculate the number of days in a quarter. I have the Control Source for field "A" set to =CalcQtr1Days([AdminDate]). I am calling CalcQtr1Days and passing the AdminDate. It calculates the number of days I'm looking for and returns that number in my field. Then, I...

I have 3 tables - Students, which contains all students; Attendance, which contains dates a particular student was absent; and AttendanceCtrl which contains Quarter beginning/ending dates. I need to be able to calculate the number of days a student was present, absent, tardy in a quarter. The...

I have a combobox where users can select classes. In the AfterUpdate event for that combobox I have the following code: Me.ClassCode = DLookup("[ClassCode]", "Classes", "[ClassID] = " & Me.ClassID.Column(0)) I want to populate the Class Code field based on the class they select. The code...

Pat, Yes, I think the margins are the problem. At home, where it works correctly, the bottom margin is 0.5 but at work it's 0.5216 or something like that. I tried changing it to 0.5 but it won't stick. If I get out of Page Setup and them go back in, it's back to the original settings. Any...

I have a report setup to print labels. I used the report wizard to set up the format and I'm using Avery labels #8460. The labels are supposed to print 3 across and 10 down, so 30 labels. I created the labels at home but when I take the report to work and import it into the database there, it...

I have two subforms on a tabbed page. Both subforms read/write data from the same table. The first subform is in dataset view and consists of 5-6 fields on the line containing class information. The second subform consists of two memo-type fields where users can enter comments. The fields...

When I open a form, it displays the first record from the table that I defined as it's Record Source. I want the form to open with all the fields blank so the user can begin entering data. What do I need to do to get the form to open without any data in the fields? Thanks Rod

I have a form with a 'Save' button. To keep certain users from editing the form, I've disabled the edit, add, and delete functions of the form based on the user's security level. When a user with a low security level opens the form, a message box pops-up that says "SaveRecord isn't available...

I need to be able to print 2 database records on a single report line. It needs to be a 2-up report but they are not labels. Here's an example db record 1 dbrecord 1 db record 1 db record2 db record 2 db record 3 field 1 field 2 field 3 field 1...

I need to print 2 records on a single line of a report so I'm attempting to concatenate the 2 records into one but I keep getting errors. Here's my code: Me!txtPrintLn = Me![ClassName] & " " & Me![InstructorID] & " " & Me![RoomNumber] When it runs, it says it can't find the field 'ClassName'...