Report View

[Bradonnmorgan]

Hello Forum and good morning!,

I know this is going to end up being something tiny im just over looking but maybe one of you can help me.

WANT:I want to display a report but I dont want to display it using print preview in Access software.

ISSUE:This being said here is my situation. I have a database build and tables are split. When one of the end user uses it and they go to preview reports it will open it in access. This is something I dont want because the fact that I want this to be a stand alone application were all the user requires is Access runtime and It looks like it uses nothing else other than said database.

Thank you in advance and I do appriciate the help. If there is any more information I can provide please ask away.



Regards,

Bradon Morgan

[Rawb]

Reports can be opened from the Access Runtime. If you have ONLY the Runtime installed for users, then you should be fine.

Another way would be to export the Report as a PDF and then open the PDF using Adobe Reader. For that, take a look at the DoCmd.OutputTo Method.

[Bradonnmorgan]

Rawb. Thank you I will give that a try. I assumed there would be a way to make it all into a stand-alone program but at the moment I dont seem to be catching any ideas on how to do this. I have been seeing this problem everywere and no one seems to have a solid awnser for displaying an accde file that.

Thank you very much for your assistance and I will keep you posted on the results.

[Rawb]

Brandonmorgan, I'm sorry you're having so much trouble getting answers! Feel free to ask me any time, either here or in a PM, and I'll be happy to answer anything I can for you.

As for Access: There's really no such thing as a "stand-alone" program. If you want to design your program that runs without having to install either Access or the Access Runtime, you'll have to develop it from scratch using a full-fledged programming language like VB.Net, C++, etc.

That said, ANYTHING developed in Access can be run using the Access Runtime, which is completely free for both personal and business use. Therefore, the typical company setup is to purchase a single license for the full version of Access (which is given to the developer) and then just installing the free Access Runtime on everyone else's computers.

As for using an ACCDE file (instead of an ACCDB), that's entirely up to you. Both can be run using the Access Runtime without need for any modification or licensing.

The only difference (between an ACCDB and an ACCDE) is that an ACCDE is slightly more secure because it only includes the compiled code. If you distribute an ACCDE, nobody will be able to take the file home and "steal" your VBA coding, macros, etc.

[Bradonnmorgan]

Rawb,

Thank you for your quick reply and assitance.
Yeah ive been noticing that my only real option if i wanted a stand alone program that access will not cut it.
Main reason the program is in Access is because it cuts down some time on coding. I have found a few work around but they are not exactly what i wanted. such as shinking the size of the access window and hiding it on the side so that the forms just open up in the center and it looks like access never existed. This is a little scetchy to me doing it that way but its seeming to be the only way to get the outcome that im looking for.

Ive did some research on compiling ACCDE into EXE but ive not yet tested it so I think I may back up the ACCDE and give that a try later to day. I will let you know how that goes.

Thank you again I do greatly appricate the assistance and look forward to contibuting to the program community.