yak77
Aug 19th, 2003, 04:59 AM
hi,
I have some reports in Access 2000 that I need to run from VB 6.0.
I know the code to run it and it works fine.
But there are 2 problems i am facing
1) If in the Access database I uncheck the "Display Database Window" in the "Startup" options i get the following error:
" 2046 The command or action "OpenReport" isnt available now"
(I dont want the user to see the objects in access database)
2) When the Access database opens with the report(when called from VB) , it doesnot open Maximised. How do I make it to maximise when opened from VB.
I tried writing Docmd.Maximise in the Reports "Open" event but it doesnot maximise the Access window.
I also tried writing accApp.Docmd.Maximise in VB but that doesnt work either.
Any ideas????
Thanks a lot.
I have some reports in Access 2000 that I need to run from VB 6.0.
I know the code to run it and it works fine.
But there are 2 problems i am facing
1) If in the Access database I uncheck the "Display Database Window" in the "Startup" options i get the following error:
" 2046 The command or action "OpenReport" isnt available now"
(I dont want the user to see the objects in access database)
2) When the Access database opens with the report(when called from VB) , it doesnot open Maximised. How do I make it to maximise when opened from VB.
I tried writing Docmd.Maximise in the Reports "Open" event but it doesnot maximise the Access window.
I also tried writing accApp.Docmd.Maximise in VB but that doesnt work either.
Any ideas????
Thanks a lot.