Search results

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

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

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

I need to implement some type of security on my database to limit the forms/reports users can access. When implemented it will be a split database on a network. I'd like to set it up so only certain users can edit/add data on certain forms. Also I want to have more than one user be able to...

Is is possible to copy queries, reports, modules, etc. from one database to another, and if so, how? I have some queries and reports in an inventory database I'd like to copy and use in another database without having to set them up or re-code them again. Thanks, Rod

I have a report based on a query. The query joins the Students table to the Schedules table based on Student-Id. The Schedules table also contains the student's classes. I have another query that joins the Schedules table to the Courses table by Class-Id. I use this query in a DLookUp for...

I would like to print a field from another table on a report. The table the report is based upon is Schedules. Using a field from Schedules, I'd like to read another table and print a field from that table. In the Control Source of my report field I thought I could enter an SQL statment...

I have a table containing 12 classes per student and 12 teachers per student. The table contains a class-id as the key into another table to retrieve a class description and a teacher-id as a key into a 3rd table to retrieve the teacher name. The 12 class descriptions and teachers are to print...

Hi, I have a Combo Box that contains two fields, the key field (StudentId) and another field (StudentName). As recommended by the Combo Box wizard, I'm hiding the key field so only the StudentName displays in the box. The wizard also allows me to save only one of those fields in my table so I...

I have 3 tables - the 1st contains a classid and class description, the 2nd contains a teacherid and a teacher name, the 3rd contains a studentid and the classid(s) of the classes they attend and the teacherid(s) of those classes. When I print a report using the 3rd table, only the id fields...