Opening an Access Report using VB 1

[bdavis96]

I have a command button in VB 6 that I would like to use to open an Access Report. Please clue me into what code I can use. Thank you very much

 

[CCLINT]

Was it your question which I posted an answer to yesterday and then the thread disappeared?

thread709-351760 [/b][/i][/u]*******************************************************[sub]
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!

 

[bdavis96]

I don't believe it was me. I think this is the first time I have posted this question. But I am not looking for the command button to print it, I am just looking for the command button to open it for viewing. Any help would be great. Thank you.

 

[CCLINT]

under the above thread you will find code to print or preview a report. [/b][/i][/u]*******************************************************[sub]
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!

 

[bdavis96]

Thank you CCLINT , I was able to figure out from that code what I needed. One last question on this subject, how do I get the report and access to open maximized?

 

[Gazzza]

I can't answer how to open the app window to max but to open the report to max after
.DoCmd.OpenReport ReportName, lAction
put this on the next line
.DoCmd.Maximized

The only way I can think of that you can get access to the app window state is using the shell command.

Does anyone know of a way to open the app window to max using the above thread's code sample.

Thanks

Garry