Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Code for viewing report in "Report View"

Posted on 2008-06-26
6
Medium Priority
?
582 Views
Last Modified: 2013-11-28
Hello,

Currently I have the following code to view my report

DoCmd.OpenReport "rptResults", acViewPreview, , sFilter

That code brings up the report in "Print Preview" view. Could you please help me out with the pre-built code which will bring out the report in "Report View"?

Thanks and appreciate your help!
0
Comment
Question by:Dingo212
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1200 total points
ID: 21878468
Maybe

acReportView

The correct syntax should be available in the Intellisense drop down when you type the code in VBA

docmd.OpenReport "rptResults",    
right after the comma                 ^

you should get a drop down list of options ...
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 21878573
DoCmd.OpenReport "Report Name", acViewDesign

>which will bring out the report in "Report View"?
Just to play devil's advocate here, why do you want to progammatically open a report in Disign View?
0
 
LVL 75
ID: 21878590
jHo .... it's A2007 ... with the new "Report View' ... I think ....

mx
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 66

Expert Comment

by:Jim Horn
ID: 21878639
oic.  wth is 'Report View'?
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 800 total points
ID: 21878644
Dingo212,

MX's intellisense tip should have gotten you the answer, ...but just in case here it is:
Docmd.OpenReport "YourReport", acViewReport

JeffCoachman
0
 
LVL 2

Expert Comment

by:larowlan
ID: 24276861
Be wary of using acReportView with older versions of access, it prints the page immeadiately
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question