Solved

How to access the record selector function with Microsoft access forms

Posted on 2007-11-27
10
4,438 Views
Last Modified: 2013-11-28
Hello

When I display a form and the fields are displayed as a datasheet if I click in the left most column it selects the entire row, I beleive this is called the record selector. I want to call the record selector function if the user clicks in any of my fields in the data sheet view i.e. the entire row is selected. Does anyone know how to do this?

Thanks

Jake
0
Comment
Question by:elschott
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 1

Expert Comment

by:arunyeshi2000
ID: 20362186
Use the onclick event on TR of the html table. Hope this solves.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 20363921
elschott,

<I want to call the record selector function >
What Record Selector Function?

<if the user clicks in any of my fields in the data sheet view i.e. the entire row is selected>
Well, if they click a Column Heading (Field), that FIELD (Column) is selected, not the record (Row).

So can you explain Exactly what you want to happen and when?

If you want "someting" to happen everytime a user selects anything in a record, or selects the entire record, you will need to use a Form, with it's Default View Property set to "DataSheet".

You would put your "Record Selector Function" code on the "Current" Event of the Form.
This event triggers everytime an entire record is selected, or cell in a record, is selected.

If you need any help with this let me know
:)

JeffCoachman

0
 
LVL 77

Expert Comment

by:peter57r
ID: 20364689
As has been implied in the earlier responses, this is not a common thing to want to do.
You should explain what you real purpose is, and then someone will advise you accordingly.
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 20366303
Peter57,

Oh, is there some "history" behind this Q?
;)

JeffC
0
 
LVL 77

Expert Comment

by:peter57r
ID: 20366472
? not with me there ain't
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 20366520
;)
0
 

Author Comment

by:elschott
ID: 20368270
Hello Everyone

Sorry for the delay in my reply. I have created a form with my own custom search facility that loads a new form based on a query designed to return the search results in a datasheet. I want to be able to select a row of data and if the user double clicks that row the form closes and the original form from which the search facility was actioned the dataset or record is moved to the one selected from the query result form. this is very easy to implement in with programming languages such as Delphi etc.

Therefore I have noticed on my query form in datasheet view if I click in a cell within the dataview it selects that cells contents for me, and selects individual cells, I would like to be able to select the entire row when someone clicks on a cell within a row.

In reference "what do I mean by record selector?" if I type in record selector in the Microsoft Access Help menu the following information is replied <i>The record selector (record selector: A small box or bar to the left of a record that you can click to select the entire record in Datasheet view and Form view.).</i>  I figure if I can access or call this each time a user clicks on a cell I should be able to select the entire row.

Essentially the whole process is driven by a need that if the search result returns more than one record, I want the user to specify what record they want to use, as mentioned previously I have been able to do this in the past with other applications by double clicking the desired record.

Hope this helps, I do not have access to my database at the moment but when I get back to work I will endeavour to post some code in the hope that this might help.

Thanks

Jake
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 20369290
elschott,
<"what do I mean by record selector?" >

Just to clarify...
You posted:
< I want to call the record selector function>
... then I posted:
<What Record Selector Function?>

I know what a record selector is, I just did not know what this "Record Selector FUNCTION" was.
;)


This is what I have so far:
You have a Search Form.
You enter your criteria.
It the search form opens a form in datasheet view that shows the results of your search.
You Select a record on this Datasheet form, and it closes.
...after that I am lost?
:(
(What's on the main Form?)

JeffCoachman

0
 

Author Comment

by:elschott
ID: 20379912
Thanks to everyone who contributed I was able to work a solution.

Jake
0
 

Author Closing Comment

by:elschott
ID: 31411316
even though I worked a solution myself you may as well have the points at least you tried to assist
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Flowing down data to other tables 13 36
File.Search issue 8 35
Record with #Error 8 34
Problem with vba code 4 45
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

820 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