Help with Clearing a Search Filter
Help with Clearing a Search Filter
Hello all, I need help with clearing a search filter so that nothing shows in the form fields AND in the table. I've attached a copy of the db. I have to launch this thing so PLEASE any and all help appreciated.
- Attachments
-
- Inventory_DB.odb
- (38.11 KiB) Downloaded 168 times
OpenOffice 4.0 on windows 7
Re: Help with Clearing a Search Filter
Adjust your 'qJOBS' parameter query...
Either eliminate the last OR clause altogether, or use 'IS NOT EMPTY' instead:
Either eliminate the last OR clause altogether, or use 'IS NOT EMPTY' instead:
- Attachments
-
AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
Re: Help with Clearing a Search Filter
Thank you so much DACM. Much appreciate the help.
OpenOffice 4.0 on windows 7