472,983 Members | 2,737 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,983 software developers and data experts.

3rd party dual listbox control

Hi all,

After unsuccessfully trying to make my own dual listbox control out of
arraylists, I decided to look for a 3rd party control. I've looked for over
a week now and can't find anything but ASP.Net stuff when I need a Windows
Form control. I've seen dual listbox populators in countless Windows
applications, and have seen them run very fast, so I figured this would be
extremely popular.

Here's how it should work:
1. Data from an arraylist of objects is passed to the control.
2. The control populates a listbox on the right with this data (displaying
what column I want - say "StateNames" being displayed and "StateID" and
"StateAbbrev" and "Population" or any number of extra information from the
object that can be tracked with it).
3. The user makes 1 or more selections (multi-selection is optional, but
would be nice) and clicks on an "Add" or "<" button to send the selection(s)
to the left hand listbox.
The user may also "Remove" selections from the left hand listbox.
4. The items in the lefthand listbox are available as an arraylist for
further processing.

Sound simple?
It should be, but there are no examples anywhere of this being done with
arraylists, I've "googled", "webcrawled", etc for the last 10 days with no
luck (I have code doing this with datatables, yes, but I need it to be done
with arraylists - which has proved elusive).

Any ideas of where to start looking?

TIA
Dave
Nov 21 '05 #1
7 4482
This image should clarify.

www.miraclecat.com/listbox2listbox.gif

MCDave
Nov 21 '05 #2
What is so difficult in writing this control?

insert one lisbox
insert the buttons
insert other listbox

fill the first listbox

create an empty arraylist

when the user clicks the move here button
get the item using the listbox.selectedindex
remove from the collection, and the listbox.items
add it to the other collection and to the other listbox

I am missing something?

Alejandro Lapeyre
"MCDave" <daven(delete_this)@miraclecatDELETETHISTOO.com> escribió en el
mensaje news:Oa****************@TK2MSFTNGP12.phx.gbl...
This image should clarify.

www.miraclecat.com/listbox2listbox.gif

MCDave

Nov 21 '05 #3
The first listbox cannot be updated directly as it is bound by the
arraylist.
So I remove an item from the arraylist that is tied to the first listbox,
but because the listbox is bound, I can't simply remove an item directly
from the listbox (if I try to remove anything directly from the listbox, I
get an error that basically says it is already bound - catch 22).

In other words:
say the bound listbox is called "lstRegionNames" and it is bound to the
arraylist "alRegionNames"
Private alRegionNames As New ArrayList
Private alSelectedRegionNames As New ArrayList

Private Sub form4_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
loadDBRegionNames()

End Sub
Private Sub loadDBRegionNames()

alRegionNames = SalesRegionsDB.GetRegionNamesActiveAL

'the first listbox bound to the arraylist
lstRegionNames.DisplayMember = "reg_name"
lstRegionNames.ValueMember = "reg_idx"
lstRegionNames.DataSource = alRegionNames

' the second listbox -
lstSelectedRegionNames.DisplayMember = "reg_name"
lstSelectedRegionNames.ValueMember = "reg_idx"

End Sub
Private Sub Add() 'called when clicking the Add button

If lstRegionNames.SelectedIndex < 0 Then Return 'if nothing selected,
exit sub
Dim sr As New SalesRegionDD 'the object which contains "reg_idx" and
"reg_name"
sr = lstRegionNames.SelectedItem
Me.lstSelectedRegionNames.Items.Add(sr) 'add the object to the second
listbox - this works fine

Me.alRegionNames.RemoveAt(lstRegionNames.SelectedI ndex) 'remove that object
from the arraylist - this works fine- I verified this by looping through the
objects in "alRegionNames" - the object was indeed removed from the
arraylist

'an attempt at refreshing the first listbox by re-binding it to the
arraylist - this does not refresh "lstRegionNames"
Me.lstRegionNames.DataSource = Me.alRegionNames

End Sub
I had done this with a datatable and removing an item from the datatable
removes it from the bound listbox automatically.
Doing the exact same thing with an arraylist does not work, though.

I don't know how to proceed or what else needs to be done to be able to
remove the item from "lstRegionNames"

"alejandro lapeyre" <al**************@jotmail.com> wrote in message
news:eA****************@TK2MSFTNGP10.phx.gbl...
What is so difficult in writing this control?

insert one lisbox
insert the buttons
insert other listbox

fill the first listbox

create an empty arraylist

when the user clicks the move here button
get the item using the listbox.selectedindex
remove from the collection, and the listbox.items
add it to the other collection and to the other listbox

I am missing something?

Alejandro Lapeyre
"MCDave" <daven(delete_this)@miraclecatDELETETHISTOO.com> escribió en el
mensaje news:Oa****************@TK2MSFTNGP12.phx.gbl...
This image should clarify.

www.miraclecat.com/listbox2listbox.gif

MCDave


Nov 21 '05 #4
When I say a bound listbox cannot be updated, I mean that I get the
following error:

"An unhandled exception of type 'System.ArgumentException' occurred in
system.windows.forms.dll
Additional information: Cannot modify the Items collection when the
DataSource property is set."

It appears there is a bug that prevents updating of a listbox from an
arraylist (when the arraylist is bound to the listbox).
"MCDave" <daven(delete_this)@miraclecatDELETETHISTOO.com> wrote in message
news:%2******************@TK2MSFTNGP12.phx.gbl...
The first listbox cannot be updated directly as it is bound by the
arraylist.
So I remove an item from the arraylist that is tied to the first listbox,
but because the listbox is bound, I can't simply remove an item directly
from the listbox (if I try to remove anything directly from the listbox, I
get an error that basically says it is already bound - catch 22).

In other words:
say the bound listbox is called "lstRegionNames" and it is bound to the
arraylist "alRegionNames"
Private alRegionNames As New ArrayList
Private alSelectedRegionNames As New ArrayList

Private Sub form4_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
loadDBRegionNames()

End Sub
Private Sub loadDBRegionNames()

alRegionNames = SalesRegionsDB.GetRegionNamesActiveAL

'the first listbox bound to the arraylist
lstRegionNames.DisplayMember = "reg_name"
lstRegionNames.ValueMember = "reg_idx"
lstRegionNames.DataSource = alRegionNames

' the second listbox -
lstSelectedRegionNames.DisplayMember = "reg_name"
lstSelectedRegionNames.ValueMember = "reg_idx"

End Sub
Private Sub Add() 'called when clicking the Add button

If lstRegionNames.SelectedIndex < 0 Then Return 'if nothing selected,
exit sub
Dim sr As New SalesRegionDD 'the object which contains "reg_idx" and
"reg_name"
sr = lstRegionNames.SelectedItem
Me.lstSelectedRegionNames.Items.Add(sr) 'add the object to the second
listbox - this works fine

Me.alRegionNames.RemoveAt(lstRegionNames.SelectedI ndex) 'remove that object from the arraylist - this works fine- I verified this by looping through the objects in "alRegionNames" - the object was indeed removed from the
arraylist

'an attempt at refreshing the first listbox by re-binding it to the
arraylist - this does not refresh "lstRegionNames"
Me.lstRegionNames.DataSource = Me.alRegionNames

End Sub
I had done this with a datatable and removing an item from the datatable
removes it from the bound listbox automatically.
Doing the exact same thing with an arraylist does not work, though.

I don't know how to proceed or what else needs to be done to be able to
remove the item from "lstRegionNames"

"alejandro lapeyre" <al**************@jotmail.com> wrote in message
news:eA****************@TK2MSFTNGP10.phx.gbl...
What is so difficult in writing this control?

insert one lisbox
insert the buttons
insert other listbox

fill the first listbox

create an empty arraylist

when the user clicks the move here button
get the item using the listbox.selectedindex
remove from the collection, and the listbox.items
add it to the other collection and to the other listbox

I am missing something?

Alejandro Lapeyre
"MCDave" <daven(delete_this)@miraclecatDELETETHISTOO.com> escribió en el
mensaje news:Oa****************@TK2MSFTNGP12.phx.gbl...
This image should clarify.

www.miraclecat.com/listbox2listbox.gif

MCDave



Nov 21 '05 #5
Do not attach it to the DataSource property.

Simply fill the ListBox with the ArrayList contents.

Alejandro Lapeyre

"MCDave" <daven(delete_this)@miraclecatDELETETHISTOO.com> escribió en el
mensaje news:%2******************@TK2MSFTNGP11.phx.gbl...
When I say a bound listbox cannot be updated, I mean that I get the
following error:

"An unhandled exception of type 'System.ArgumentException' occurred in
system.windows.forms.dll
Additional information: Cannot modify the Items collection when the
DataSource property is set."

It appears there is a bug that prevents updating of a listbox from an
arraylist (when the arraylist is bound to the listbox).
"MCDave" <daven(delete_this)@miraclecatDELETETHISTOO.com> wrote in message
news:%2******************@TK2MSFTNGP12.phx.gbl...
The first listbox cannot be updated directly as it is bound by the
arraylist.
So I remove an item from the arraylist that is tied to the first listbox,
but because the listbox is bound, I can't simply remove an item directly
from the listbox (if I try to remove anything directly from the listbox,
I
get an error that basically says it is already bound - catch 22).

In other words:
say the bound listbox is called "lstRegionNames" and it is bound to the
arraylist "alRegionNames"
Private alRegionNames As New ArrayList
Private alSelectedRegionNames As New ArrayList

Private Sub form4_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
loadDBRegionNames()

End Sub
Private Sub loadDBRegionNames()

alRegionNames = SalesRegionsDB.GetRegionNamesActiveAL

'the first listbox bound to the arraylist
lstRegionNames.DisplayMember = "reg_name"
lstRegionNames.ValueMember = "reg_idx"
lstRegionNames.DataSource = alRegionNames

' the second listbox -
lstSelectedRegionNames.DisplayMember = "reg_name"
lstSelectedRegionNames.ValueMember = "reg_idx"

End Sub
Private Sub Add() 'called when clicking the Add button

If lstRegionNames.SelectedIndex < 0 Then Return 'if nothing selected,
exit sub
Dim sr As New SalesRegionDD 'the object which contains "reg_idx" and
"reg_name"
sr = lstRegionNames.SelectedItem
Me.lstSelectedRegionNames.Items.Add(sr) 'add the object to the second
listbox - this works fine

Me.alRegionNames.RemoveAt(lstRegionNames.SelectedI ndex) 'remove that

object
from the arraylist - this works fine- I verified this by looping through

the
objects in "alRegionNames" - the object was indeed removed from the
arraylist

'an attempt at refreshing the first listbox by re-binding it to the
arraylist - this does not refresh "lstRegionNames"
Me.lstRegionNames.DataSource = Me.alRegionNames

End Sub
I had done this with a datatable and removing an item from the datatable
removes it from the bound listbox automatically.
Doing the exact same thing with an arraylist does not work, though.

I don't know how to proceed or what else needs to be done to be able to
remove the item from "lstRegionNames"

"alejandro lapeyre" <al**************@jotmail.com> wrote in message
news:eA****************@TK2MSFTNGP10.phx.gbl...
> What is so difficult in writing this control?
>
> insert one lisbox
> insert the buttons
> insert other listbox
>
> fill the first listbox
>
> create an empty arraylist
>
> when the user clicks the move here button
> get the item using the listbox.selectedindex
> remove from the collection, and the listbox.items
> add it to the other collection and to the other listbox
>
> I am missing something?
>
> Alejandro Lapeyre
> "MCDave" <daven(delete_this)@miraclecatDELETETHISTOO.com> escribió en
> el
> mensaje news:Oa****************@TK2MSFTNGP12.phx.gbl...
> > This image should clarify.
> >
> > www.miraclecat.com/listbox2listbox.gif
> >
> > MCDave
> >
> >
>
>



Nov 21 '05 #6
I did figure out a workaround that basically sets the datasource to the
clone of the original list as in the following:

Private alRegionNames As New ArrayList
Private Sub form4_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
loadDBRegionNames()

End Sub

Private Sub loadDBRegionNames()
alRegionNames = SalesRegionsDB.GetRegionNamesActiveAL

'the right hand box
lstRegionNames.DisplayMember = "reg_name"
lstRegionNames.ValueMember = "reg_idx"
lstRegionNames.DataSource = alRegionNames

End Sub

'sub called by add button click event
Private Sub Add()

Dim sindex As Integer = Me.lstRegionNames.SelectedIndex
If sindex < 0 Then Return

Dim sr As New SalesRegionDD
sr = Me.lstRegionNames.SelectedItem

Dim itemcount As Integer = Me.lstRegionNames.Items.Count

Me.lstSelectedRegionNames.Items.Add(sr) 'this is another listbox
that is not bound

Me.lstRegionNames.SelectedIndex = -1
Me.alRegionNames.RemoveAt(sindex)

' I put this test in to see if there is only 1 item left in the
source listbox, if so,
' set the datasource to nothing or else there will be a very
noticeable delay for the ' last item to pass over to the left box
If itemcount = 1 Then
Me.lstRegionNames.DataSource = Nothing
Else
Me.lstRegionNames.DisplayMember = "reg_name"
Me.lstRegionNames.ValueMember = "reg_idx"
Me.lstRegionNames.DataSource = Me.alRegionNames.Clone
' if you use the clone, then you don't have to set the datasource to
nothing first

End If
End Sub
However, my solution is not very elegant (and probably slow) and the ListBox
bugs will probably be remedied in DotNet 2.0.

I'll probably just do your solution and keep track of both the listbox and
the arraylist contents without a DataSource, adding and removing items via
comparison as you suggest.

"alejandro lapeyre" <al**************@jotmail.com> wrote in message
news:eu****************@TK2MSFTNGP14.phx.gbl...
Do not attach it to the DataSource property.

Simply fill the ListBox with the ArrayList contents.

Alejandro Lapeyre

"MCDave" <daven(delete_this)@miraclecatDELETETHISTOO.com> escribió en el
mensaje news:%2******************@TK2MSFTNGP11.phx.gbl...
When I say a bound listbox cannot be updated, I mean that I get the
following error:

"An unhandled exception of type 'System.ArgumentException' occurred in
system.windows.forms.dll
Additional information: Cannot modify the Items collection when the
DataSource property is set."

It appears there is a bug that prevents updating of a listbox from an
arraylist (when the arraylist is bound to the listbox).
"MCDave" <daven(delete_this)@miraclecatDELETETHISTOO.com> wrote in message news:%2******************@TK2MSFTNGP12.phx.gbl...
The first listbox cannot be updated directly as it is bound by the
arraylist.
So I remove an item from the arraylist that is tied to the first listbox, but because the listbox is bound, I can't simply remove an item directly from the listbox (if I try to remove anything directly from the listbox, I
get an error that basically says it is already bound - catch 22).

In other words:
say the bound listbox is called "lstRegionNames" and it is bound to the
arraylist "alRegionNames"
Private alRegionNames As New ArrayList
Private alSelectedRegionNames As New ArrayList

Private Sub form4_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
loadDBRegionNames()

End Sub
Private Sub loadDBRegionNames()

alRegionNames = SalesRegionsDB.GetRegionNamesActiveAL

'the first listbox bound to the arraylist
lstRegionNames.DisplayMember = "reg_name"
lstRegionNames.ValueMember = "reg_idx"
lstRegionNames.DataSource = alRegionNames

' the second listbox -
lstSelectedRegionNames.DisplayMember = "reg_name"
lstSelectedRegionNames.ValueMember = "reg_idx"

End Sub
Private Sub Add() 'called when clicking the Add button

If lstRegionNames.SelectedIndex < 0 Then Return 'if nothing selected, exit sub
Dim sr As New SalesRegionDD 'the object which contains "reg_idx" and
"reg_name"
sr = lstRegionNames.SelectedItem
Me.lstSelectedRegionNames.Items.Add(sr) 'add the object to the second
listbox - this works fine

Me.alRegionNames.RemoveAt(lstRegionNames.SelectedI ndex) 'remove that

object
from the arraylist - this works fine- I verified this by looping through
the
objects in "alRegionNames" - the object was indeed removed from the
arraylist

'an attempt at refreshing the first listbox by re-binding it to the
arraylist - this does not refresh "lstRegionNames"
Me.lstRegionNames.DataSource = Me.alRegionNames

End Sub
I had done this with a datatable and removing an item from the

datatable removes it from the bound listbox automatically.
Doing the exact same thing with an arraylist does not work, though.

I don't know how to proceed or what else needs to be done to be able to
remove the item from "lstRegionNames"

"alejandro lapeyre" <al**************@jotmail.com> wrote in message
news:eA****************@TK2MSFTNGP10.phx.gbl...
> What is so difficult in writing this control?
>
> insert one lisbox
> insert the buttons
> insert other listbox
>
> fill the first listbox
>
> create an empty arraylist
>
> when the user clicks the move here button
> get the item using the listbox.selectedindex
> remove from the collection, and the listbox.items
> add it to the other collection and to the other listbox
>
> I am missing something?
>
> Alejandro Lapeyre
> "MCDave" <daven(delete_this)@miraclecatDELETETHISTOO.com> escribió en
> el
> mensaje news:Oa****************@TK2MSFTNGP12.phx.gbl...
> > This image should clarify.
> >
> > www.miraclecat.com/listbox2listbox.gif
> >
> > MCDave
> >
> >
>
>



Nov 21 '05 #7
I wrote some working code for what I needed - no 3rd party control
necessary.
For everyone's scrutiny:
Basically, there are 2 listboxes bound with arraylists, both needed to be
populated from the DB showing the regions that currently belong to the
salesrep on the left side and regions that do not belong to the salesrep on
the right side (wasn't thinking clearly earlier - damn, it's hard to
concentrate while on pain medication!).

///
Private alRegionNames As New ArrayList 'left hand listbox
Private alSelectedRegionNames As New ArrayList

Private Sub form4_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
loadDBRegionNames()
End Sub

Private Sub loadDBRegionNames()
alRegionNames = SalesRegionsDB.GetAvailRegNamesForSA(1) 'gets all
regions that are not already assigned to a salesman
Me.SetRightListboxDataSource(alRegionNames)

alSelectedRegionNames = SalesRegionsDB.GetRegionNamesForSA(1) 'gets
currently assigned regions
Me.SetLeftListboxDataSource(alSelectedRegionNames)
End Sub

Private Sub SetLeftListboxDataSource(ByRef dsL As ArrayList)
lstSelectedRegionNames.DisplayMember = "reg_name"
lstSelectedRegionNames.ValueMember = "reg_idx"
lstSelectedRegionNames.DataSource = dsL
End Sub

Private Sub SetRightListboxDataSource(ByRef dsR As ArrayList)
lstRegionNames.DisplayMember = "reg_name"
lstRegionNames.ValueMember = "reg_idx"
lstRegionNames.DataSource = dsR
End Sub

Private Sub Add()
Dim sindex As Integer = Me.lstRegionNames.SelectedIndex
If sindex < 0 Then Return

Dim sr As New SalesRegionDD
sr = Me.lstRegionNames.SelectedItem

Dim itemcount As Integer = Me.lstRegionNames.Items.Count

Me.alSelectedRegionNames.Add(sr)
Me.alRegionNames.RemoveAt(sindex)

Me.SetLeftListboxDataSource(Me.alSelectedRegionNam es.Clone)
'I put this test in to see if there is only 1 item left in the
listbox, if so,
' it sets the datasource to nothing (or else there will be a very
noticeable delay for the last item to pass over to the other box)
If itemcount = 1 Then
Me.lstRegionNames.DataSource = Nothing
Else
Me.SetRightListboxDataSource(Me.alRegionNames.Clon e) 'if you
use the clone, then you don't have to set the datasource to nothing first -
go figure!
End If

End Sub

Private Sub AddAll()
Me.alSelectedRegionNames.AddRange(Me.alRegionNames )
Me.alRegionNames.Clear()
Me.lstRegionNames.DataSource = Nothing
Me.SetLeftListboxDataSource(Me.alSelectedRegionNam es.Clone)
End Sub

Private Sub RemoveAll()
Me.alRegionNames.AddRange(Me.alSelectedRegionNames )
Me.alSelectedRegionNames.Clear()
Me.lstSelectedRegionNames.DataSource = Nothing
Me.SetRightListboxDataSource(Me.alRegionNames.Clon e)
End Sub

Private Sub Remove()
Dim sindex As Integer = Me.lstSelectedRegionNames.SelectedIndex
If sindex < 0 Then Return

Dim sr As New SalesRegionDD
sr = Me.lstSelectedRegionNames.SelectedItem

Dim itemcount As Integer = Me.lstSelectedRegionNames.Items.Count
Me.alRegionNames.Add(sr)
Me.alSelectedRegionNames.RemoveAt(sindex)

If Me.lstSelectedRegionNames.Items.Count > 0 Then
Me.lstSelectedRegionNames.SelectedIndex = 0
End If

Me.SetRightListboxDataSource(Me.alRegionNames.Clon e)

If itemcount = 1 Then
Me.lstSelectedRegionNames.DataSource = Nothing
Else
Me.SetLeftListboxDataSource(Me.alSelectedRegionNam es.Clone)
End If
End Sub

Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnAdd.Click
Me.Add()
End Sub

Private Sub btnRemove_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnRemove.Click
Me.Remove()
End Sub

Private Sub btnAddAll_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnAddAll.Click
AddAll()
End Sub

Private Sub btnRemoveAll_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnRemoveAll.Click
RemoveAll()
End Sub
\\\

Many thanks to all who helped in this endeavor,

MCDave
Nov 21 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Luca | last post by:
Hello, I'm using a windows form in which there is a standard ListBox control. I want to add/remove objects from the ArrayList associated to the ListBox, and I want the ListBox immediately shows...
2
by: John R. | last post by:
I want to have a listbox that shows a checkbox and a textbox. I created a user control that has a checkbox and a textbox in it and have been trying to add it to a listbox but I can't get it to...
8
by: Oddball | last post by:
Ok - I have a ListBox control and I'm ready to write my own DrawItem event handler. What I want to draw as the item is another control. I have created a user control that I would like to list in...
6
by: Chris Leuty | last post by:
I am populating a multiselect Listbox from a dataset, with the content of the listbox filled by one table, and the selections determined from another table. So far, I have been keeping the dataset...
4
by: Moe Sizlak | last post by:
Hi There, I am trying to return the value of a listbox control that is included as a user control, I can return the name of the control but I can't access the integer value of the selected item,...
18
by: Dave Sauny | last post by:
Ok, its a friday, I'm at work and I cant get this to work: I have 3 listboxes on one tab control page. when i select an item in listbox1 i want whatever is selected on the other 2 listboxes...
3
by: Hugh O | last post by:
Hi, There is a ROW property on the Web Listbox control within VB.Net. The description states it is "The number of visible rows to display". I have tried setting this property in many different...
8
by: nirdeshonline | last post by:
Hi, I have added a simple listbox in windows form under c# 2.0. It contains a collection of approx 10 strings as list items. Now when i resize the form whole listbox flickers. Please tell me...
2
by: Chip Pearson | last post by:
I'm sure that there is a simple answer but I can't find it. I need a third-part ActiveX control on a form in VB.NET 2005. I can't find anything on the built-in Forms Toolbox to add a new control...
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
4
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.