Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Updating data via a report in Access?

Posted on 2012-04-03
3
Medium Priority
?
263 Views
Last Modified: 2012-04-03
Dear experts -
I have recently discovered the wonders of reports in Access 2010 - e.g., double-clicking to open up a form.
Our controller opens a finance report that displays, for example, a field for "purchase order". Is there any way for her to update this field via the report?
Thanks.
0
Comment
Question by:terpsichore
[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
  • 2
3 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 37804400
<I have recently discovered the wonders of reports in Access 2010 - e.g., double-clicking to open up a form.>
Not so wondrous...

This only works in Report View, NOT in Print preview.
Print Preview is the view that is needed to *completely* render Graphics and charts, display page breaks, show accurate page numbers, and run most report code...etc.
Report view simply cannot do this...

<Our controller opens a finance report that displays, for example, a field for "purchase order". Is there any way for her to update this field via the report?>
No
Create a form to display the same data, then edit the values there...
Since you already know how to: "double-clicking to open up a form.", ...this should be easy.

;-)

JeffCoachman
0
 

Author Closing Comment

by:terpsichore
ID: 37804409
Very well said.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37804476
To be fair "Report View" does have other advantages:
-You can "view" the entire report faster because of the less overhead associated with fully rendering everything.
-Click-able Hyperlinks
-Dynamic Filtering
-Find (dialog box)
-Refresh report data
-Copy (but no paste)

In the future, I am sure the distinction between forms and reports will be blurred even more....

;-)

JeffCoachman
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

722 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