Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Updating data via a report in Access?

Posted on 2012-04-03
3
Medium Priority
?
266 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
  • 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
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…

885 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