Strange influence of Form Timer event

[dima69]

I have bumped into a strange Access bug. When inactive form has Timer event set, any RunCommand action, like acCmdCopy, (at another form or table) will fail with an error.

Is anybody familiar with this behavior knows any workaround ?

[Killer42]

I have bumped into a strange Access bug. When inactive form has Timer event set, any RunCommand action, like acCmdCopy, (at another form or table) will fail with an error.

Is anybody familiar with this behavior knows any workaround ?

I'm not familiar with it, but I'm curious about one or two things. Such as, what version of Access? And what specific error is produced?

[missinglinq]

And exactly what do you mean by "inactive" form?

[nico5038]

I know the problem and that's why I never use the Timer event in my code.

As far as I've experienced it has to do with (re)setting the focus of form controls and thus causing a different event sequence. There are however sample programs with a hidden form to allow the closure of the opened databases from a distance.

You could check the TOC of the Access Cookbook, especially chapter 10
By following the link "Examples" you can download the sample databases.
http://www.oreilly.com/catalog/accesscook2/

Nic;o)

[dima69]

This happans with both Access 2000 and 2002. The error is something like "Command FilterBySelection is not available now".
Inactive form - open form which is not active, while another form is also open and active, i.e has the focus.
Nico - you are probably right that this has something to do with focus, but setting the focus to the current form and / or control does not help either. So I'm still looking for the workaround.
Not using Timer event could be a good idea if you can suggest something else with similar functionality :)

[nico5038]

A workaround is to skip the runcommand.
This statement effectively activates the options of the menubar and when they are greyed out, they won't work.
The best is to handle the manipulations from code.
E.g. for filtering I set the filter like:

me.filter = "[code]=" & me.cmbCode
me.filteron = true

Nic;o)