I have a database with all macros running 开发者_StackOverflow中文版fine when the file is an accdb format , when i make the accde a message appears saying command or action "refresh" is not available now , and then when i press ok it gives an error 2950 . Please notice that i run the database from a trusted location.
Thanks, Bishoy
I suspect that this is because the form does not have focus. You could try setting the focus to the relevant form after the open macro and before refresh.
Forms("Form1").SetFocus
精彩评论