Recent content by SnowPatrol

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

Thanks Ken- I was approaching it in the wrong (and frankly ludicrous way!) After a nights sleep (and wine) I see what you mean. Cheers!

Hi Ken, thanks for your reply. Sorry for being dumb but....! I did as you suggested. The initial query sorts the recods into their groups of allocation groups but I cannot work out how to order them in the way I want in a subquery. Do I need to use Count in an expression? This just seems to...

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, sadly I am using GROUP BY. It orders by year fine, it groups by apparatus within each year fine but NOT in order of most prevalent group, just in alphabetical order! Does thqt make sense?!

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

THANK YOU SO MUCH!!! I could not see the wood for the trees (I could barely see the trees either!1) You have made a tired girl very happy!

Hi RG- it looks rather unwieldy even to my eyes..... They are all listboxes lboname lboyear lboapparatus lboparish SELECT tblStJamesAgric.harvest_Year AS Expr1, tblStJamesAgric.Owner_Title AS Expr2, tblStJamesAgric.Forename AS Expr3, tblStJamesAgric.Plantation_Name AS Expr4...

Hi, I have none! I must be truly working with aircode!! Is this an oversight??? The query works fine with no "after update" coding involved. Its just the aesthetics that are the problem. Thanks for your continual help..do you never sleep!!?? A

Hi RG- thanks for the reply. However, dumb fool that I am, I CANNOT understand why the "All" works within the query when it is just in quote marks and therefore not at the top of the list, but when I put it in "[All]" it appears at the top of the list but then the query doesn't work! Is it...

Hi Drew- it does put it at the top of the list (or lists as I have 4 of them) but the query then doesn't work! Just returns nothing. If I leave the "All" languishing in mid list then it works fine. Tried parentheses and brackets and wildcards etc etc ad nauseum. As for no replies, I know there...

Default Hi, it was my message that referenced the Deafult at top of the list. I am glad that at least someone else has the problem (though sorry that you do obviously!!) As no-one replied (which I find SO disheartening) I assumed I was being incredibly dumb. The link IS the one I referred to...

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 RG- forgive me for being dumb- I am new here....is air code like air guitar! Kind of made up?! Not that I have any problem trying out made up code (nothing works anyway!) I just thought this must be a really common piece of code. Perhaps i am going about it the wrong way????? Stella