Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Updating data via a report in Access?

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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

580 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