Datasheet view record selection event?

drhoo

Hi,

I think the answer is "No", but I thought I'd better ask before I rule
it out.

With a form in datasheet view, is there any way to capture
programatically the selected (i.e. with shift-click or click and drag)
records? Are they captured by any events?

Ideally I'l like to open a recordset for the selected records

Nov 13 '05 #1

Subscribe Post Reply

4351

Allen Browne

Use SelHeight and SelTop to determine the selected records.

The form's RecordsetClone already has these records, so you may not need to
open another recordset.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"drhoo" <ar*@bc.com> wrote in message
news:67********************************@4ax.com...

I think the answer is "No", but I thought I'd better ask before I rule
it out.

With a form in datasheet view, is there any way to capture
programatically the selected (i.e. with shift-click or click and drag)
records? Are they captured by any events?

Ideally I'l like to open a recordset for the selected records

Nov 13 '05 #2

by: edself | last post by:

I have a form which displays a subform datasheet of information. I'd like to be able to quickly click on a particular record and open up another form showing more detailed information about that...

Microsoft Access / VBA

Table <> form in datasheet view

by: Georges Heinesch | last post by:

Hi: I have a tables in relationship to each other. When I open the main table (table 1), I see a "+" at the very left of every record. Clicking on the "+" expands the data of the linked table...

Microsoft Access / VBA

Bug: print preview in form datasheet with server filter on crashes access (ADP A2002 SP3)

by: Malcolm Cook | last post by:

I've discovered: Using "File > Print Preview" in a form's datasheet view with a server Filter crashes access after previewing... ....that is, unless ServerFilterByForm has been turned off...

Microsoft Access / VBA

List Box Selection opens in datasheet view

by: Yuki | last post by:

I am trying to find out if I can have a specific record that has been selected in a list box be opened in datasheet view. I can't seem to find where this can happen or what I need to use to make...

Microsoft Access / VBA

Att: PC Datasheet - Please readf inside

by: George Kandaz | last post by:

Steve, I posted a question to your last post almost a week ago, but never heard from you again. Please read my last message, as follows. Thanks. ...

Microsoft Access / VBA

Set Datasheet Form cursor on Load

by: Thelma Lubkin | last post by:

I have a form that allows a user to choose a specific field value. The form calls a second, datasheet, form using a different field in the selected record as a filter . This second form has a...

Microsoft Access / VBA

Opening form in datasheet view

by: davegb | last post by:

I learned recently that I should never allow end users access to my tables, that if I want them to see that data in that format I should show them a datasheet form. I created a form for this...

Microsoft Access / VBA

Change Record Source on switching View to Datasheet

by: steph | last post by:

Hi, A question regarding Access 2002: I've got a form which should be displayed in Form View and in Datasheet View. But I want to use a different record source for each view. That means, when...

Microsoft Access / VBA

Manipulate current datasheet record in function invoked from macro

by: Bill | last post by:

This database has no forms. I am viewing an Access table in datasheet view. I'd like to execute a macro to execute a function (using "runcode"). In the function, I'll reading data from the record...

Microsoft Access / VBA

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Datasheet view record selection event?

Similar topics