Search results

I am using the code below attached to a command button in my form header. Its purpose is to toggle the button's caption between SELECT and DESELECT to enable me to select all or specific records for a subsequent action. The toggling works fine if I want to select/deselect ALL records...

I have a field in my query whiich has 3 tests: 1 fldDiscNo = 0 2 fldRecordingID is null 3 fldIgnore (a Yes/No field) = True If tests 1 and 2 are met, the query text field (Wanted) should be "Yes" but if test 3 is met, the result should be "No". Here's one of the many variations I have...

I’m using Access 365. Until recently when I clicked the Access icon in the task bar, it would launch the last used database. Following a fresh installation of Access, I find that this no longer works - it just launches Access with the screen ready to open a new database, select a recently used...

Hi all, I’ve been using Access since Access 2 - for those a lot younger than me, that is a long time. But I’m an amateur who has come a long way and an even longer way to go. I use and develop databases for my personal use. I’m an avid collector by nature and Access is great for that. Already...