Search results

It would be shared by multiple users and that will likely cause issues. Currently (without the save facility) >1 user can open the .mde version and perform searches. The database is currently not split front/backend and so each user loads a copy of everything in the .mde. The search is a...

Thanks again, that sounds so much easier! I've not too much experience with db use in general (background in different languages) and so if there's a crazy long (sometimes working) way to do something, that's me.

Thanks for your reply. I think I'm making progress. I set the userform's Record Source to the save table, set a few test control's Sources to the applicable field in the savetable, and I am able to navigate back and forwards. The userform includes 3 subforms that contain one field each...

(Access 2003) I have a single user form that has been designed with no associated table. It's sole purpose is to collect user entered criteria then perform a database search. I have recently added a save facility so that separate search criterias can be held in an accompanying save table...

Many thanks for this, Mark. Greatly appreciated. I've extended your solution into the original minimal code. This now allows me to sort according to AStrTotal (AxStr + AyStr). One, initial, interesting characteristic was that sorting using AStrTotal seemed to be text based rather than numeric -...

As part of a query I have the following (needs to be Access 2003 sql compatible, I'm sill wearing the learner badge!) ... Minimal Code: SELECT Main.Ax,Main.Ay, (select Astr from Afull where Avalid = Main.Ax) as AxStr, (select Astr from Afull where Avalid = Main.Ay) as AyStr...

Thanks Pat, this is much appreciated! Your solution works perfectly across all 4 fields....just what I want. Cheers!

Hi folks, I have a table of around 6000 records comprising 4 fields (A,B,C,D). - Each field can contain numbers or Nulls. - Each record can comprise all numbers, a mixture of numbers or Nulls, or all Nulls. I'd like to build a query that excludes all records that contain any number from a...