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 / Forms / May 2008

Tip: Looking for answers? Try searching our database.

DataGrid or GridView in Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Participant - 15 May 2008 01:29 GMT
Hi,
Is there a way we can represt data as DataGrid or GridView? Moreover, I want
to be able when I select one row to get the value of the ID (the first
column).

Any ideas?
Albert D. Kallal - 15 May 2008 03:26 GMT
> Hi,
> Is there a way we can represt data as DataGrid or GridView? Moreover, I
[quoted text clipped - 3 lines]
>
> Any ideas?

Take a look at the follwing screen shots for ideas:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

In the above on quite a few of the sample forms, you can see that I placed a
little button called "edit", or a buttion with the glasses icon.

when you click on that button, then you have full access to the record and
you can pop open another detail formed with the following line of code

docmd.Openform "frmCustomers",,,"id = " & me!id

You didn't really give much information as to what you want to do when you
select that one row to get the ID, but the above is the general approch used
in those sample screen shots...

Some people actually don't place a button on the form, but the double click
event on the text box control, and thus double clicking on the text box will
launch the detail form that a lousy to edit the information in a form.
Signature

Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

 
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.