Link to home
Start Free TrialLog in
Avatar of João serras-pereira
João serras-pereiraFlag for Portugal

asked on

open a reposrt preview within a Form in ms/access 2010

I have a ms/access application with VBA coding. And it's ok. Nevertheless, I want to improve the lookings on the report preview (as a print).
When it opens the report, the report opens in the background (with all tables showing - a cumbersome view for an user), so what I need is, for instance, to open the report (print preview) and show it within a separate pop up form

is it possible? if so, how can I do it?
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

Your description isn't quite clear.  Can you show us at least a screenshot.  Or better yet, a stripped down database (all private info removed).
Avatar of João serras-pereira

ASKER

Oh. I am sorry for not being clear enough.

Pleas find below some screenshots. I am also uploading the database (just in case) so you may see what I mean.

Screeshot 1: It shows the application forms. The idea is: Upon clicking the Or button, a dorm opens and shows the report as a print preview. curretly, it opens in the ms/access background environment (which I did not want to show anyway) and the user need to minimize all windows trying to locate the report.

User generated image
Screenshot 2: the is the bacground screen after minimizing all forms. What I wanted is to show this printout in a mor convenient manner, e.g. INSIDE a form

User generated image
Screenshot 3: combines everything so you may see (hopefuly) what I mean and wanted to avoid).

User generated image


If you need, to use the application is just to click the "Logon" button upon start. Identify as "jlpereira" "1234"

click the "Ordens de Pagamento" buttong and then the "Or" button. It asks for a number. You may use "5163"
CDI.11.04.zip
ASKER CERTIFIED SOLUTION
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks (although I feel a bit stupid myself).
It happens to all of us
:-)