Search results

I presume you are viewing your data in datasheet view. Have you thought of using the forms toolbar to sort your records?

I think I understand what you are trying to achieve. You want a form basically which has a subform which can display both all the data related to a field, then a narrower select of records based on another criteria. Therefore I would suggest two sub forms, one which displays all records and the...

By extract, do you mean you want to append the result of the 'Find Unmatched Query' by using a commandbutton? If so you need to run an Append query based on your unmatched query, to check that this works I would view the data in datasheet mode as aposed to running it first to see if you get the...

Sorry I haven't responded sooner, it was late last night here in Sydney when I last responded. Your problem appears to be in this line of code: stLinkCriteria = "[Project No]=" & "'" & Me![Project No] & "'" Try this: stLinkCriteria = "[Project No]=" & Me![Main Project Data].Form![Project...

I aplogise for not making myself clearer. I guess I tend to get a little caught up and too focussed on the problem. I thought with the copy I provided which opened on the form and tab in question it would be clear what I was trying to achieve. As I mentioned moments before you posted, I have...

Ok, I have found the solution, for anyone that may be interested. I unbound the text boxes on the subform in question with the statistics. I think set up a studentclassIDLink textbox with which I could link the student and update the statistics by using the following line of code...

That is why I attached a copy of the db! To open on the form in question.

You could try this is the OnClick event code, easier if you use a command button with the wizard, it will guide you through the process. Dim stDocName As String Dim stLinkCriteria As String stDocName = "NameofFormtoOpen" stLinkCriteria = "[Project No]=" &...

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

Coffeeman, can you upload a copy of your db? it would be a lot easier to work out where the problem is.

Your code works well for adding a new student but it doesn't run the append query. That is ok, as I said, I finally managed to work it all out in the end. I really do appreciate your time on this. Thanks

Thanks for looking at this problem, but you haven't seen the whole picture. What I was hoping to do was add a new student AND then run the append query from one command. Your copy doesn't append the student, at least the append part didn't work. Thats ok though, as I mentioned earlier my latest...

This version is up to date. I have been working on another problem all morning. A while ago I was working on attendance totals and didn't realise I had messed up another part of the process, so back to square one. At the moment I am trying to get studentClassID in frmqryAttendancesub2 to...

OOps Looks like I uploaded the wrong copy. Sorry

Hi My apperoach changed, because of the problems I was having, I went back to simply selecting a new student from combobox on subfrmAttClassList, then an event on click for Enroll to open the form frmAddunitstostudent which has a commandbutton to run the append query. I will look at your version...

Success!! At last :) I created a new field on with yes/no tick box and attached an event to open form readonly to run command to append the studentclassID. Finally........ Thank you for all your time and effort, it is greatly appreciated. Kind Regards Tanya

This is the db up to the moment. Thank you for your time on this, I really appreciate it. Regards Tanya

Thanks John

? I can't see this in the version I uploaded or my current copy???

I wish it were that easy John, the problem has grown :| http://www.access-programmers.co.uk/forums/showthread.php?p=793733#post793733