Search results

I have created a query "on the fly". Where a user would select the criteria from some list boxes, press a button and the results are shown in a form. But if a user choose's criteria that returns 0 records I get a blank form. Is there a piece of code that returns the user to the previous screen...

Hi, I'm a complete novice at code and I get a run-time error 3075. The error reads - 'Syntax error (missing operator) in query expression 'Gazetteer.Status IN(,'Current') AND Gazetteer.Geographytype IN(,'Census,'Economic')' What I am trying to do - I want to put 3 multi-select list boxes on...

So far, I have my 2 multi select list boxes and I want to use these as my selection criteria in one query and run the query through one control button. This is as far as I have got Private Sub cmdOK_Click() Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As Variant Dim...

No Worries, I have found this http://www.fontstuff.com/access/acctut11.htm which may help me some of the way

That would only seem to work by selecting one criteria from each section. What would I use if I wanted to be able to multi select the criteria?

I'd like a front-end form which gives 3 choices/sections which have selectable choices: BY STATUS: Current Historical BY GEOGRAPHY TYPE: Administrative Electoral Health Statistical Building Block Census Economic Crime Education European Other BY COUNTRY: England Wales Scotland Northern...