Search results

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

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

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

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 have just opened a database I am working on and am encountering an error that did not exist previously and I cannot solve. I have the same issue on two forms and it relates to a recordset variable called rst_units. Basically, vba is stopping with a Run-time error '91': Object variable or...

I have a table called tbl_courses. This currently has 3 complete records in it (3 courses). I have a form with a textbox; the textbox is called txt_course_total. I want the textbox to show the total number of courses currently stored. I wrote the following: Dim rst_courses As...

I have a crosstab query which, when runs, works perfectly. The column heading is the first letter of a criteria type (P, M and D from PASS, MERIT and Distinction). The row headings are the variable criteria values (a value from 1 to x where x can be any value from 3 to 10). The value field is...

I am using the following to place data from a given field into the defined textbox, called txtBreakNo: txtPrimary.Value = txtPrimary.ItemData(0) txtBreakNo.Value = DLookup("intBreakNo", "tblActivityStaffDate", "WeeklyActivity_ID" = txtPrimary.Value) The field txtPrimary reports the...

I have the following code, which was given to me, that is meant to centre the form on the screen. I am aware that it is not working and in fact creates further errors in the code. Me.Move (Screen.Width - Me.Width) / 2, (Screen.Height - Me.Height) / 2 However, I am unsure why this does not work.

I am finishing the last steps to a system and have I have two issues with this: The splash screen has the rounded edge at the top that 2007 gives to forms when border style is set to None. Is there any way of either rounding the bottom of a form or squaring off the top? I have switched off...

I have a subform that is based upon a query. The output of the query is filtered by whatever is given within an unbound textbox on the main form. When I select the relevant fields on the main form then the subform shows the related fields from the query; which is exactly what I am looking for...

I have a number of objects on a form but two are important to each other. I have a combo box called txtDate. This needs to be a combo box because the user needs to have a list of previous dates recorded. I have a Calendar Control 12 item called clrDatePicker. I want this so that users can...

I have a piece of code that runs a series of update and append queries. However, there are only a few times that these queries need to run and this is based upon another, earlier set of queries (created to inform the user of what is happening). I would like to create an IF statement that simply...

I have 3 unbound fields on my form, entitled txtActivity, txtDate and txtLeader. The first and last are combo boxes and the middle one is a simple text box which allows for a date picker to be used. The record source of the form is set to tblActivityStaffDate; the table on which I need this and...

I have a database that I have converted into an ACCDE file to help reduce the size of the actual implementation. I am aware that if I want or need to add/edit any forms, queries, tables, etc then I would need to do this to the original source system. My concern is; what if my ACCDE system has...

I have two tables; one are existing student records and the other contains imported student details. The system already adds new students to the existing records, marks missing students as left but now I have a situation where I need to update records where students have simply had a change of...