Search results

Excellent Just the ticket. Thank you, RonPaii.

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 finally got there with a few detours along the way. Thank you all for your patience and for the helpful side tips. Its very true that in Access there is always more than one way to skin the cat but given this experience with multiple IIFs, the next time I might just go with ..... the function...

Well spotted. I’ve made the change but it’s looking for tblDiscsOtherLabels!fldRecordingID - the table name is needed because fldRecording appears in more than 1 table. I’m working on the changes needed to the sql in my report’s open event.

Once again thanks for all the replies. I've tried both approaches suggested. To my own surprise I managed to get the function to work. My thanks to DHookom for the mini tutorial - I think I've at least tipped my toe in the water. As for the Iif approach, no joy. Runnig plog's version, a...

Thanks for all the feedback. For clarification, this is an Access question. I’m sorry but I’m no Access expert and I don’t know how to write the function as has been outlined. Perhaps I could try to make the “business logic” clearer. I am trying to populate an unbound control on a report. The...

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 tried opening the database, adding a new record then exiting and closing the database. On restarting Access, it persisted in opening a different (but always it seems the same database). Strange. I think I'll just use the 'pin dtabase' tip you mentioned. Thanks for your help.

Excellent. That is the setting I needed. But strangely it is always opening the same database, even after I have opened others.

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