Search results

If I did this, then would it only solve the problem for the period of time that you had created dates for. At some point in the future a user who doesn't know how access works would come across the issue that the dates they will require aren't in the database. I think it would be better if you...

Thanks for the response, I have tried now to filter the form using an unbound combo box, which will filter the subform, no changes to the records. However, now I am finding that I cannot add new dates to the combo box, which is something else which will not be useful for data entry. I need the...

Hello, I have a form in access 2007 that filters two subforms within it by a date. The idea is that when you change the date on the main form you can start data entry into the subforms. When you initially open the form a specific date and it's filtered records (already in the database) are...

Thank you for all the replies! I want the top 4 per bird_id so that I can then use the MOD 4 to obtain the 4th chronological record from each bird_id. I want to obtain the TOP 4 per bird_id initially as for each bird_id there may be 4, 5 or 6 records and the MOD 4 function would select every...

Hello, I am new and don't know all the rules of forums, thus I thought I would clarify something within this forum before making another faux-pas! I have found a thread written a year ago with no replies, but from someone who looks to have had the same problem that I am currently dealing with...

The SQL statement I am using is - SELECT [2010 chicks rung].bird_id, [2010 chicks rung].nest_rear, [2010 chicks rung].date, [2010 chicks rung].time, [2010 chicks rung].weight_g FROM [2010 chicks rung] WHERE [2010 chicks rung].bird_id IN (SELECT TOP 4 bird_id FROM [2010 chicks rung]...

Thank you for the reply!

The record cannot be deleted or changed because table <name> includes related records. (Error 3200)Access Help says: The record cannot be deleted or changed because table <name> includes related records. (Error 3200) You tried to perform an operation that would have violated referential...

It also will not allow me to go back to design view, I have to close and not save the whole thing in order to stop the error message (basically revert back to no combo box).

Hello, I am trying to create a combo box in the main table that allows me to search and select, bringing up related records in my subform. When I have made a combobox using the wizard, it has all the values from the field and you are able to search through and select. However, the subform is...

Can I ask what your afterupdate event procedure is? I am trying to create a combo box for 'date' in the main form that brings up all records related to this date in the subform. I can create the box, however, I get an error message that says you cannot edit or delete records, without me trying...