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 / Reports / Printing / October 2004

Tip: Looking for answers? Try searching our database.

Excel-like interactive report

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MG - 11 Oct 2004 14:30 GMT
I'm an Access beginner with a question about interactive reports.  I've
been asked to create something that resembles an Excel spreadsheet.  For
the most part it consists of columns of values pulled from the DB (name,
empID, hourly rate, etc.) with one of the columns user-editable (hours
worked).  When the user alters this column's cells, their values are used
to update/recalculate totals in other cells (e.g. total hours, total
earned).

Is this a common undertaking in Access?  Can I do it with a report, or
would I need to manually create an interactive GUI or Excel object?  (My
background is in Java, so VBA coding isn't a problem.)  Any push in the
right direction is appreciated, thanks!

MG
SA - 11 Oct 2004 16:18 GMT
MG:

Access reports are static documents.  They can not be edited.  The offer a
snapshot of the data from the database based on the underlying query.

If the user has Access on their machine (or the run time version), you'd
want to use a form, where the user can input data and update the database.
Alternately, if the user's don't generally have Access you can use Excel and
have them enter data in a spreadsheet and import that into your database,
provided however that the rows and columns with data are contiguous like a
flat file.
Signature

Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

> I'm an Access beginner with a question about interactive reports.  I've
> been asked to create something that resembles an Excel spreadsheet.  For
[quoted text clipped - 10 lines]
>
> MG
 
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.