I have a macro that works that calls the RunCommand Import menu and it works fine when the database is displayed but fails when the database is hidden. The error message is
Run-time error '2046':
The command or action 'Import' isn't available now.
I tried converting the macro to a module and called the function from vba but still the line that says DoCmd.RunCommand acCmdImport fails with the same error message.
Anybody has a solution?
Run-time error '2046':
The command or action 'Import' isn't available now.
I tried converting the macro to a module and called the function from vba but still the line that says DoCmd.RunCommand acCmdImport fails with the same error message.
Anybody has a solution?