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 / Macros / December 2006

Tip: Looking for answers? Try searching our database.

Editing from Query Data View

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JohnCreighton_@hotmail.com - 24 Dec 2006 06:00 GMT
Is it possible to write a macro so when I click on a cell in the data
view of the query it will become editable so I can make changes. Once I
make changes I want to be able to click away and have it update the
necessary tables. Does anyone know where I might find some helpful
example code?
tina - 24 Dec 2006 07:53 GMT
Access tables, queries, and form datasheets don't have "cells" (that's an MS
Excel term), they have records and fields. this is not just a question of
terminology - cells in an Excel spreadsheet are very different from fields
in an Access record, and you can't expect to manipulate them in similar
fashion.

the records in a query are either updateable, or not. you cannot control a
single field in a query, or even a single record. that's why queries are
poor vehicles for user interaction with data. if the query IS updateable,
you can bind it to a form, and *then* you have numerous options for
controlling when and how the user can edit a specific control in the form -
in all records, or only certain records, in the form's recordset.

note that queries have no records in and of themselves, rather they *return*
records, from one or more tables, that meet whatever criteria is specified
in the query. so if a form is bound to an updateable query, and you update a
record in the form, the data will be written to the underlying table(s)
unless you specifically prevent it.

hth

> Is it possible to write a macro so when I click on a cell in the data
> view of the query it will become editable so I can make changes. Once I
> make changes I want to be able to click away and have it update the
> necessary tables. Does anyone know where I might find some helpful
> example code?
 
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.