Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / December 2006

Tip: Looking for answers? Try searching our database.

embedded teports in Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Anja - 05 Dec 2006 15:51 GMT
Hi everyone,

I have a question about forms and reports in Access and whether they
could be made to share the same window.

So what I am trying to do is the following:

I have a report that is fed by a query and the user can set the filters
for the query through a form window. What I wanted to do was display
the report in the same window. So, the user sets the filter criteria
and it updates the report. It all works if I launch the report in
another window but it would be nicer to just have one window for this
and have the record get embedded in the window.

Is there an easy way to achieve this?

Thanks,

Anja
Alex Dybenko - 05 Dec 2006 17:28 GMT
Hi,
not sure I understand you, but perhaps you can just print preview the form?
form can also act as a report

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Hi everyone,
>
[quoted text clipped - 15 lines]
>
> Anja
Marshall Barton - 05 Dec 2006 18:15 GMT
>Hi everyone,
>
[quoted text clipped - 11 lines]
>
>Is there an easy way to achieve this?

Not that I ever heard about.  You might be able to achieve
an near equivalent effect by positioninig the form and
report windows appropriately within the Access window.  See
the MoveSize method in VBA Help.

Signature

Marsh
MVP [MS Access]

mcescher - 05 Dec 2006 20:38 GMT
I had to do something like this.

I had several different selections (Months, weekdays, locations) that
the user could select and change the output.  I had user make
selections and then click an Update button.  This would create the SQL
statement on the fly from the users selections.  Fed the SQL statement
to a Subform so the user could see what information would be returned.
Then When the user was ready he/she pushed the report button, and this
pushed the SQL statement into the report as the record source.

In Access 2002, you cannot drag a report onto a form as a sub form (I
just tried)

HTH,
Chris M.

> Hi everyone,
>
[quoted text clipped - 15 lines]
>
> Anja
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.