Recent content by RasterImage

Have now, and it did the job, thank you so much for the suggestion. Seems obvious now, but I didn't think of it. Yes, it is accdb. I'm loving having a database that now actually works properly! Thank you CJ_London.

Yes. Ta, but the same happens whether I open in normal mode or exclusive mode, and whether I try to save as a copy or to decrypt.

Hello, I'm a bit stuck, could use some help please. I've got an encrypted Access 2007 database that I made. If I try to save it as a copy, or compact it, or save a backup, or decrypt it, the following happens. It asks me for the password several times in a row, so I type it in each time. On...

Say your subform is based on a table: Make a query which is like the table, but with a criterion. Make a macro with 1 Action - ApplyFilter, with Filter Name the name of your query, and Control Name the name of your subform. Set the macro to run when the parent form loads.

No worries. Figured out how to make a macro filter the subform, and set it to run on load for the parent form. Please ignore me.

If I apply a filter to a subform, then close the parent form and reopen, the filter has dissapeared. This doesn't happen with regular forms. Please: how can I make the subform open with filter applied by default, but still be able to take filter off when desired? Thank you.