Search results

Found it thanks. Running Sum....

I have a Report that list the number of students in score orders (the first student being the one with the most points). However i'm trying to create a Position Field which simple lists the numbers 1 to 20 (or what ever the class size is). I've tried count(studentid) but that just gives me the...

IN one of my forms (Students), i have a text box (Text313) that i'm trying to bring into a report, where the address ID's match In the rpt, I have used =Forms!students([AddressID]=[AddressID])![Text313] as well as a few others... But i either get the #Name or #Error Can someone please help me...

I have a spreadsheet that has some queries imported from Access (Via DATA | Import External Data) Anyways i would like to protect this spreadsheet but using the TOOLS | Protection method gets me the following message when i try to refresh my query Any idea's anyone?

thanks for the advise but i'm bobbins at writing codes

I would like to filter one of my columns but would like to select the filtering from another cell. Have a look at this: Instead of having to click on the arrow below CLASS - i want to be able to have something similar (or a combo box type thing) where it says CLASS at the top row. How can...

This didn't work either but i found the issue. list56 was bound. I made this unbound and now it saves. Thanks again for you help

Yup - definitely bound. It does save it to the table, but if i click on the list(s) again - it then deletes it from the table and enters the new selection instead

Saved the current and went to the next record. Upon going back and selecting the list - it does exactly the same. So i can go to any record but clicking on the list just empty's the record

I have a list box with some items in it. I have a command button that allows the user to save the items (once selected - can also multi select) like this: And this also saves to the table However if i click on the list again - everything disappears and the record from the table is also...

A slight problem. The form as it is works fine. If i attach it to my main form as a subform (using the AddressID), i get the #Error in all the new fields you created. Any idea why? Something in the control that needs changing? Cheers EDIT: Found it. I had to change the Form! name Thanks...

Thanks I did play with Dcount but was getting the #Error. But i've check your control and now know why. Thanks to both of you

Umm thanks. These Crosstabs - are they difficult to do? Never done one before Thanks again

Part of my DB monitors attendance. I would like to be able to COUNT the number of days a student has off, on holiday etc. Sounds simple but I've been spending 2 days on it and just can't get it to work. My form looks like this (sits within a form as a subform) I just want some boxes at the...

Thanks for you help. I'll think of something to keep the box in the background maybe minimize

AH ok - it wasn't I opened it and voila it worked. So the form needs to be opened?

No joy i'm afraid

Trying to run a query that takes the dates from 2 text boxes from another form. This is the qry SELECT Attend.AttStudent, Attend.AttType, Attend.AttDate FROM Attend WHERE (((Attend.AttDate) Between [form]![termdate]![fromdate] And [form]![termdate]![todate]));Where the 2 text boxes are...

Thanks Ken that worked a treat. But i'm still finding it difficult to understand why the same DB would work differently on 2 PC's

When i'm working from my home PC - i dont get this But when i'm working from my laptop i get the attached message everytime i click on my calendar I think the code that sits behind it is If IsNull(RecDetect) Then StrSQL = "INSERT INTO Attend ( AttStudent, AttDate, AttType ) " _ &...