Search results

Hi- this is probably simple but my brain has frozen. I want to use some kind of auto formatting on a form to separate groups of records based on when a date (in a YEAR box) has changed. Just to separate the records so the user isn't faced with one long form. I would be happy with a blank row, a...

Hi, as ever, am sure this is simple... I have a field in a table which is a code. This code is used to allocate records to certain groups. I want to run a query which then returns the records, grouped by code and displayed in ORDER of the biggest group. So if there are 20 records with Code A...

Hi, am sure this is simple....! Can't find a solution. I have records which have YEAR and APPARATUS as two of the fields. All I want to do is write a query which displays all the records chronologically by YEAR then within each YEAR to group them by the biggest subset according to APPARARTUS...

Hi, I have tried the code on Dev's Access site but it does not work for me. I have four listboxes populated by queries. For each one I have added a UNION Select "All" which works fine. I have also set "All" as the Default. All I need to do now is to ensure that the "All" choice is at the top...

Hi, am struggling with listboxes....how on earth do I work with five multiselect listboxes on one form? The user needs to be able to select from any combination of them? I therefore can't use one as the data source for the next etc etc. Or can I if ITEM.SELECTED is Null???? The database is...

Hi, my problems are numerous! I have a form with a number of multiselect listboxes. Their sources are individual tables such as YEARS, PARISHES, CLIENTS. The underlying data is stored in a separate table. I want users to be able to select none, one or some values from each listbox and run a...