ApplyFilter in ACCDR

[Cedarguy]

Hello,



I have created a runtime setup package for a friend to let her use my Access 2010 application, without having to purchase Access 2010. However, the ApplyFilter macro in one of the forms doesn't work in the runtime environment. The message suggested I use a SelectObject before ApplyFilter but that gave me another error. Just wanted to know if this concept would work at all before I burn more time.

Any help would be immensely appreciated.

Thank you

[CJ_London]

with runtime, you need to build your own functionality for filtering and sorting. I don't use macro's so cannot comment on whether they will work in runtime - I know it works in VBA. If it is working in other forms but not this one it suggests there is something wrong with the form

[Cedarguy]

Thanks Ajax,
That's a tall order for my skill level; the problem is happening across the board; could you please recommend a source for macro solutions, if you know of one?
Regards

[CJ_London]

I found this link

https://support.office.com/en-us/art...rs=en-US&ad=US

but google 'access 2010 shortcut menus' or similar to find other links

Don't know how much you value your time, but it might be cheaper to buy your friend a copy of Access

[Cedarguy]

I see your point Ajax.
Thanks

[ItsMe]

Just as a side note, you can test how your application works in Runtime by changing the extension name from accdb to accdr. Then, after testing, you can change it back to accdb. If you know the user does not and will not have a full version of Access installed, you can give that user an accdb file. They will not notice any difference between an accdr and an accdb.

However, if a user with a full version of Access installed uses your application as accdb, they may access design time features by accident.