Recent content by gary.newport

Thanks for this. It's really annoying when the solution is so obvious (and I have used it before) but grateful since I have already spent too long forgetting it and working on stupid solutions. :)

I have a form with a subform; the latter being of focus here. The subform is a continuous form and one of the fields on this is connected to a YES/NO field in the relevant table, which means it is appearing as a checkbox on the form. I wanted to have a button that reacted to the number...

The database I have is a fictitious system for experimental reasons and is for a Driving School. It comprises of 4 entities; Instructor, Student, Vehicle and Booking. I want to generate a report that shows each instructor, the students they have taught in a particular month and the lessons they...

Ignore me, it is now working?!?!?!

I have looked on the web and found this raised a couple of times but the solutions are not working for me. I am using Access 2010 and have a form based upon a query (qry_student). In tihs query I have a field called Details that contains the student's address; a composite of the relevant fields...

I have an Access file that is simply the data tables and this is in a fixed location (s:\data, with the name data.accdb). I have an interface file that can be copied by any and all users anywhere they wish (called interface.accdb). I am making changes to the interface and will continue to do...

I have a field called criteria_id that can have a series of values but fall into one of three groups: Px, Mz and Dy where x, y and z are numbers from 1 to a given value. I would like to create a query that counts the number of "Px", "Mz" and "Dy" - regardless of value (so, if I have P1, P2, P3...

I have solved this! Me.Unit_Results.SourceObject = "" Me.Unit_Results.SourceObject = "frm_unit_results" Since this also allows me to move to the Course problem with a new subform I like this solution. If anyone can identify why this is a terrible idea please post!

I have a form that is based upon a crosstab query. Due to the fact that the column widths vary I cannot have the form based upon this query if I want to have it as a subform. I need it as a subform since the data being displayed is based upon four dropdowns on the main form (Course, Unit, Class...

One quick question; if I did go for an edit button that opened a new single record form that allowed me to edit that specific record, is it possible to have a NEXT button that would allow the form to load the data for the next student as shown on the subform?

yep, I got that thank you. :) So now I have hit a significant problem. I want the user to be able to click the tick boxes and so record changes for each of the students. The form I have works well but I cannot use it as either a subform or as an editable system. I could have an EDIT button to...

I realised that my last post was very textual and unclear but could not think of a way of clearly conveying the issue. I now realise that all my data is test so reveals nothing; therefore I have attached the database zipped up. The two forms I have an issue with are frm_gradebook and...

No issues. Most of this has now been solved (I think).

I have a cross tab query that I am basing a continuous form on. I have a number of issues arising from this: The first relates to the fact that in the crosstab is a field that is set to Yes/No. It appears as a textbox with a value (0 or 1) in it. I want to replace this with a tickbox but when...

I had considered this so tried the close in the IF and, as you said it would, it worked. Thank you