Do datasheets support multiple selections?

[deko]

How do I get the items selected from a datasheet? Does a datasheet support
multiple selections?

I know a ListBox has a "Selected" property that can be used when the
MultiSelect property is set - but is there a way to get the same
functionality with a datasheet?

If not, I'm throwing all my datasheets in the junk..... why bother with
datasheets? get all the same functionality with a listbox?

For example, with a ListBox, it might look something like this;

Dim varItem As Variant

Dim ctl As Control

Set ctl = frmMain!lstName s

For Each varItm In ctl.ItemsSelect ed

Debug.Print ctl.ItemData(va rItm)

Next varItm

With a datasheet:

Dim ctl As Control
Set ctl = Forms!frmMain!f rmInventory
For Each varItem In ctl.ItemData(va rItem)
Debug.Print varItem
Next

does not work
Dim frm As Form
Set frm = Forms!frmMain!f rmInventory.For m
For Each varItem in frm.?????
Debug.Print varItem
Next

[Allen Browne]

You can select contiguous rows in a datasheet.

Use the SelTop and SelHeight properties to get information about the
selected rows programmaticall y.

--
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.

"deko" <dj****@hotmail .com> wrote in message
news:G_******** *********@newss vr25.news.prodi gy.com...

How do I get the items selected from a datasheet? Does a datasheet support multiple selections?

I know a ListBox has a "Selected" property that can be used when the
MultiSelect property is set - but is there a way to get the same
functionality with a datasheet?

If not, I'm throwing all my datasheets in the junk..... why bother with
datasheets? get all the same functionality with a listbox?

For example, with a ListBox, it might look something like this;

Dim varItem As Variant

Dim ctl As Control

Set ctl = frmMain!lstName s

For Each varItm In ctl.ItemsSelect ed

Debug.Print ctl.ItemData(va rItm)

Next varItm

With a datasheet:

Dim ctl As Control
Set ctl = Forms!frmMain!f rmInventory
For Each varItem In ctl.ItemData(va rItem)
Debug.Print varItem
Next

does not work
Dim frm As Form
Set frm = Forms!frmMain!f rmInventory.For m
For Each varItem in frm.?????
Debug.Print varItem
Next

[Mike Storr]

You can access the rowindex by checking the SelTop and SelHeight properties
of the form to determine the starting row number, and the number of rows
selected.

Mike Storr
www.veraccess.com
"deko" <dj****@hotmail .com> wrote in message
news:G_******** *********@newss vr25.news.prodi gy.com...

How do I get the items selected from a datasheet? Does a datasheet support multiple selections?

I know a ListBox has a "Selected" property that can be used when the
MultiSelect property is set - but is there a way to get the same
functionality with a datasheet?

If not, I'm throwing all my datasheets in the junk..... why bother with
datasheets? get all the same functionality with a listbox?

For example, with a ListBox, it might look something like this;

Dim varItem As Variant

Dim ctl As Control

Set ctl = frmMain!lstName s

For Each varItm In ctl.ItemsSelect ed

Debug.Print ctl.ItemData(va rItm)

Next varItm

With a datasheet:

Dim ctl As Control
Set ctl = Forms!frmMain!f rmInventory
For Each varItem In ctl.ItemData(va rItem)
Debug.Print varItem
Next

does not work
Dim frm As Form
Set frm = Forms!frmMain!f rmInventory.For m
For Each varItem in frm.?????
Debug.Print varItem
Next

[deko]

> You can select contiguous rows in a datasheet.

Thanks... but I'll have to admit - I'm beginning to like list boxes more...

[Allen Browne]

By all means use a list box if you only need to display a few rows (not 10s
of thousands), and you do not need to edit the columns.

They use fewer resources than subforms do.

--
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.

"deko" <dj****@hotmail .com> wrote in message
news:jR******** *******@newssvr 29.news.prodigy .com...

You can select contiguous rows in a datasheet.

Thanks... but I'll have to admit - I'm beginning to like list boxes

more...

[deko]

> By all means use a list box if you only need to display a few rows (not
10s

of thousands), and you do not need to edit the columns

Yes, I suppose that is one big advantage of a datasheet - in-cell editing;
also, filtering. Is there a best-practices limit of how may records should
be retreived with a listbox? several hundred? one thousand? By the way, I
think the standard DataGrid in VB does support multiple selection, unlike
the Access datasheet.

[deko]

While I have the opportunity to rant about the limitations of datasheets,
let's not forget how difficult it is to work with column widths - for
example, let's say I have a subform datasheet that I want to keep a certian
size (height and width) on the main form - a vertical scrollbar appears as
the number of records exceeds the available height. The problem is that
this results in the unwelcome appearance of a horizontal scrollbar (even if
the scrollbars property is set to vertical only) if the vertical scrollbar
overlaps any text (in any of the existing rows) when it appears. Column
widths are also a pain to set programatically .

I feel better now....

[Lyle Fairfield]

"deko" <dj****@hotmail .com> wrote in
news:oZ******** **********@news svr27.news.prod igy.com:

Yes, I suppose that is one big advantage of a datasheet - in-cell
editing; also, filtering.

I never knew that! Wow!

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Allen Browne]

Deko, have you tried Continuous Form view instead of Datasheet?

Users cannot get stuck hiding columns etc.
Form header and footer sections are displayed, and can have command buttons.

Glad you feel better after the rant. :-)

--
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.

"deko" <dj****@hotmail .com> wrote in message
news:T9******** **********@news svr27.news.prod igy.com...

While I have the opportunity to rant about the limitations of datasheets,
let's not forget how difficult it is to work with column widths - for
example, let's say I have a subform datasheet that I want to keep a certian size (height and width) on the main form - a vertical scrollbar appears as
the number of records exceeds the available height. The problem is that
this results in the unwelcome appearance of a horizontal scrollbar (even if the scrollbars property is set to vertical only) if the vertical scrollbar
overlaps any text (in any of the existing rows) when it appears. Column
widths are also a pain to set programatically .

I feel better now....