Search results

Hi I have a spreadsheet and need to archive the records on several worksheets without removing them. To do this I would like to format the text on each record to strikethrough. I have written this code but it isn't working right: Sub Archive_Calculate() Dim r As Range, cell As Range On Error...

Hi I am attempting to create database for my schools athletics carnival and need to be able to calculate participation points and PlacePoints then add them together, hence my two queries: I have a query which gives me the following results: qryParticipation House1 House2 50...

Hi I have a form ICTOutcomes and when I open it on its own it works fine. The form has two subforms, the second of which is updated by a masterlink OutcomeIDLink unbound txt field. Here is the problem: When I open ICTOutcomes form frmClasses using the following code Private Sub...

I have the following code on frmClasses which closes this form and opens frmCompetencies, so far, everything works fine... Private Sub CmdCompetencies_Click() On Error GoTo Err_CmdCompetencies_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmCompetencies"...

Hi my report opens fine except that I can't access it without closing the form which has the following code to open the report: My question is, is there a way to open the report and maintain a focus on the report until you close it? Private Sub CmdPreviewAllStudents_Click() On Error GoTo...

Hi I have a form with multiple subforms. The main form frmclasses First Tab frmAtt then subfrmAttClassList which when a student is selected updates subfrmAttComments [This works fine] I am also attempting to run another subform off a query and have it updated when a student is selected but...

Hi I have a commandbutton which invokes an append query. The idea is when I add a student to a class the student is allocated a number of units, elements and competencies which they need to become competent in. I could run the append query for the whole class without paramater for...

Hi I am stumped on the next stage of my database. Within a school faculty there will be many book titles and copies of each. I am attempted to streamline the process of recording the books on the shelf and those borrowed to students. At present this is recorded by hand which leads to incomplete...

Hi I am trying to count the number of records in a subform where the value of the field [work] is "None", "Poor", "Good", ... etc I wondered if DCount would work but can't get it right. Note: I am trying to calculate this in the header of the sum form and pick up the value in the main form...

Hi I am trying to create a db for teachers to record grades of students based on numerous assignments and found a sample db for class records on Microsoft site which has been a great help. My database named Grades.mdb works well up to a point, my stumbling point is with frmAssignments and...

Hi I hope someone can help me, I have no idea what is wrong with this code: Note: studentID_DblClick is on a subform of frmClasses named subfrmMakeClasses Private Sub StudentID_DblClick(Cancel As Integer) ViewStudents End Sub Private Sub ViewStudents() On Error GoTo Err_ViewStudents...

Hi I have created the following delete query, without a parameter DELETE [tblStudents&Classes].*, [tblStudents&Classes].StudentID FROM [tblStudents&Classes]; What I would like to be able to do is double click on a field in a form to invoke the deletion. Could someone please tell me how to go...

Hi I have a db I have been working on for keeping record of student competencies and guess what I want to do will involve maketable queries and intricate forms. The db works at the moment but it is very tedious selecting each student, then allocating units, elements, competencies. What I am...

Hi I have a main form with values in subforms which I need to update other subforms by means of a click. The following code works fine with SubjectID but NOT UnitID. there are also no error messages, just nothing happens. Can anyone tell me if there is something wrong with the code? Option...

I have a form with two subforms and need to update a field in one subform based on the selection on other subform. Is this possible? The main form is frmBehaviour SubfrmBehaviour has StudentID and when this field is selected subfrmBehaviourPoints updates, however the StudentID field does not...

Hi I have a problem with a form and two subforms Main Form: frmClasses from table tblClasses and includes [ClassID] and [Class] only This first subform allows me to see all the students belonging to a particular class. : subfrmClasses from SELECT DISTINCTROW [tblStudents&Classes].StudentID...

Hi I have the following query which tallies the daily points and need to be able to select the week from mon-fri and for the year to date. I have spent hours on this without success. If anyone could help I would appreciate it. ::::Selects Daily tally:::::::: SELECT...

Can someone please tell me why when I select several but not all the tabs on my form that the formatting toolbar displays, only to disappear when another tab is selected. This is really annoying and I cannot find a solution. Any thoughts greatly appreciated. cheers Tanya

Hi My main form has the following command line DoCmd.Maximize Which is exactly what I want. BUT I have added a text box with a macro to open another form to enable adding data to a combo box and the problem is it keeps opening in maximize mode. I think this is related to the fact the main...

I have been scouring the Internet looking for a solution to my problem and have attached the closest I can get to the desire outcome. If anyone can help I would really appreciate it. -----My first query [qryMITotals] totals scores in a multiple intelligence test SELECT...