Search results

Hi John Thank you for this post. I have looked at the links you gave me and played with the recordsource but with no joy. These are just a couple of the combinations I have tried... =DCount("[Work]","Me!SubfrmAttComments","[Work]='Good'") =DCount("[Work]","Me!RecordSource","[Work]='Good'")...

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 Chris You are wonderful. Thank you so much. Especially how you have explained all these workings to me. I hope you have a wonderful Christmas. Kind regards Tanya

Found the problem relating to subfrmAssignmentsResults. Because I had made some changes to the subform, I needed to delete it from the main form and re-insert it. Now it works well, as expected. However, I still haven't worked out why I am getting a duplication with frmstudents

Thank you for that definition.

Ahhh I didn't think of that, silly me. However, while we are on the subject, when would you use a combo in preference to a validation list?

However.... you may like to change the mouse pointer to a hand by creating a hyperlink to the host cell. i.e. A1 hyperlink to A1 resulting in no actual movement. :)

I have put together a test for your problem and it appears as simple as formatting the cell with the dropdown list to date format. I have attached a copy for you. cheers Tanya

Hi Chris I am still having problems with this db. 1. It appears I cannot add any more results i.e. only the first student will accept marks. 2. frmstudents, there is a problem with classes, the class appears twice? Any suggestions on where I am going wrong? Appreciate any feedback. kind...

Hi Chris Thank you for this detail explanation. It is appreciated. Regards Tanya

This project is for my own use and what you have seen is only a small portion of a much larger project which is my own work. This project is also my way of learning as I come across new challenges and observe how others have dealt with problems. I have attended two advanced classes on Access...

I would personally create a new column next to original list with a formula which converts the julian date to the format you want. Below is a website that shows you have to achieve this. http://www.cpearson.com/excel/jdates.htm With the new column, define your list for the combo box...

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

Check out this site: http://www.taznetworks.com/rss/2004/11/access-parameter-query-into-word-mail.html Apparently you need to use the ALT+TAB key combination at least once.

Thank you wazz I was following an example from a database template from the microsoft site and didn't understand I was trying to call a function. I have now found the function in a module called global code. Thanks heaps. Tanya

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

You have a valid point, it has occurred to me that I may at some stage want to view the competencies of the student after they leave the class. Mmmm Might add a boolean column for active. Thanks gemma.

Hi Mstef Thank you for this explanation. No, I don't have this menu option when I open my form. The reason being I don't want to make the window too busy, also restricting access to many of the other tools. Kind regards Tanya

Silly me... I just realised that I didn't select cascade delete related records in relationship... I have now rectified the situation and can now delete all records by selection and delete key. still interested in what you mean thought about delete record icon? Thanks Tanya

Hi Mstef I am not sure what you are referring to "Delete Record Icon", perhaps you refer to a menu option which I have disabled. I know how to change the properties so that you can edit and delete. I am also aware that in datasheet view you can select a record and delete it, not sure what you...