Tjyylli

Bright yellow or light yellow?

Is Bran literally the world's memory?

Why does the Cisco show run command not show the full version, while the show version command does?

Was Objective-C really a hindrance to Apple software development?

Suing a Police Officer Instead of the Police Department

Why do people think Winterfell crypts is the safest place for women, children and old people?

TV series episode where humans nuke aliens before decrypting their message that states they come in peace

Where did Arya get these scars?

What is a good proxy for government quality?

Is it accepted to use working hours to read general interest books?

When does Bran Stark remember Jamie pushing him?

What is ls Largest Number Formed by only moving two sticks in 508?

What is /etc/mtab in Linux?

Where to find documentation for `whois` command options?

When I export an AI 300x60 art board it saves with bigger dimensions

France's Public Holidays' Puzzle

What happened to Viserion in Season 7?

How do I deal with an erroneously large refund?

What's called a person who works as someone who puts products on shelves in stores?

What is the definining line between a helicopter and a drone a person can ride in?

Why I cannot instantiate a class whose constructor is private in a friend class?

What's the difference between using dependency injection with a container and using a service locator?

"Working on a knee"

What were wait-states, and why was it only an issue for PCs?

How to utilize a multiselect ListBox to add data to a table

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

1

I have a form above. the short of my question is: I want to select a project # from dropdown, then select multiple companies from ListBox. And have them added to the table, i.e. project#, company#. I have one table for projects and another for companies. I have set up a table for linked projects/companies to keep the records in. You can have multiple companies involved in 1 project.

Could someone please help with this?

My code is:

Private Sub UpdateSelected()

    Dim xPR As String      'variable for project id to use same # for each data row insert

    Dim xCR As String      'variable for company id to use selected # for each data row insert

    Dim xselected As Boolean



    xPR = PtblProjectIDComboBox.SelectedValue

    xPR = Convert.ToInt32(xPR)



    For i = 0 To ListBox1.Items.Count - 1     'count to stroll thru company db and check if selected

        If ListBox1.GetSelected(i) = True Then      'if selected then add record project # and selected company#

            xCR = Convert.ToInt32(ListBox1.ValueMember)

            xselected = True

            TableGroupProjectTableAdapter.Insert(xPR, xCR, xselected)     'add the record if it is valid



            'update db

            Validate()

            TableAdapterManager.UpdateAll(CMDB1copy2DataSet)

        End If

    Next i

End Sub

Screenshot of the input form:

microsoft-access visual-studio-2017

share|improve this question

edited 11 hours ago

zx485

1,4672914

asked 12 hours ago

James W. Brumbaugh Sr.James W. Brumbaugh Sr.

61

New contributor

James W. Brumbaugh Sr. is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

1

I have a form above. the short of my question is: I want to select a project # from dropdown, then select multiple companies from ListBox. And have them added to the table, i.e. project#, company#. I have one table for projects and another for companies. I have set up a table for linked projects/companies to keep the records in. You can have multiple companies involved in 1 project.

Could someone please help with this?

My code is:

Private Sub UpdateSelected()

    Dim xPR As String      'variable for project id to use same # for each data row insert

    Dim xCR As String      'variable for company id to use selected # for each data row insert

    Dim xselected As Boolean



    xPR = PtblProjectIDComboBox.SelectedValue

    xPR = Convert.ToInt32(xPR)



    For i = 0 To ListBox1.Items.Count - 1     'count to stroll thru company db and check if selected

        If ListBox1.GetSelected(i) = True Then      'if selected then add record project # and selected company#

            xCR = Convert.ToInt32(ListBox1.ValueMember)

            xselected = True

            TableGroupProjectTableAdapter.Insert(xPR, xCR, xselected)     'add the record if it is valid



            'update db

            Validate()

            TableAdapterManager.UpdateAll(CMDB1copy2DataSet)

        End If

    Next i

End Sub

Screenshot of the input form:

microsoft-access visual-studio-2017

share|improve this question

edited 11 hours ago

zx485

1,4672914

asked 12 hours ago

James W. Brumbaugh Sr.James W. Brumbaugh Sr.

61

New contributor

James W. Brumbaugh Sr. is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I have a form above. the short of my question is: I want to select a project # from dropdown, then select multiple companies from ListBox. And have them added to the table, i.e. project#, company#. I have one table for projects and another for companies. I have set up a table for linked projects/companies to keep the records in. You can have multiple companies involved in 1 project.

Could someone please help with this?

My code is:

Private Sub UpdateSelected()

    Dim xPR As String      'variable for project id to use same # for each data row insert

    Dim xCR As String      'variable for company id to use selected # for each data row insert

    Dim xselected As Boolean



    xPR = PtblProjectIDComboBox.SelectedValue

    xPR = Convert.ToInt32(xPR)



    For i = 0 To ListBox1.Items.Count - 1     'count to stroll thru company db and check if selected

        If ListBox1.GetSelected(i) = True Then      'if selected then add record project # and selected company#

            xCR = Convert.ToInt32(ListBox1.ValueMember)

            xselected = True

            TableGroupProjectTableAdapter.Insert(xPR, xCR, xselected)     'add the record if it is valid



            'update db

            Validate()

            TableAdapterManager.UpdateAll(CMDB1copy2DataSet)

        End If

    Next i

End Sub

Screenshot of the input form:

microsoft-access visual-studio-2017

share|improve this question

edited 11 hours ago

zx485

1,4672914

asked 12 hours ago

James W. Brumbaugh Sr.James W. Brumbaugh Sr.

61

New contributor

James W. Brumbaugh Sr. is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

Private Sub UpdateSelected()

    Dim xPR As String      'variable for project id to use same # for each data row insert

    Dim xCR As String      'variable for company id to use selected # for each data row insert

    Dim xselected As Boolean



    xPR = PtblProjectIDComboBox.SelectedValue

    xPR = Convert.ToInt32(xPR)



    For i = 0 To ListBox1.Items.Count - 1     'count to stroll thru company db and check if selected

        If ListBox1.GetSelected(i) = True Then      'if selected then add record project # and selected company#

            xCR = Convert.ToInt32(ListBox1.ValueMember)

            xselected = True

            TableGroupProjectTableAdapter.Insert(xPR, xCR, xselected)     'add the record if it is valid



            'update db

            Validate()

            TableAdapterManager.UpdateAll(CMDB1copy2DataSet)

        End If

    Next i

End Sub

share|improve this question

edited 11 hours ago

zx485

1,4672914

asked 12 hours ago

James W. Brumbaugh Sr.James W. Brumbaugh Sr.

61

New contributor

James W. Brumbaugh Sr. is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 11 hours ago

zx485

1,4672914

asked 12 hours ago

James W. Brumbaugh Sr.James W. Brumbaugh Sr.

61

New contributor

James W. Brumbaugh Sr. is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 11 hours ago

zx485

1,4672914

edited 11 hours ago

zx485

1,4672914

asked 12 hours ago

James W. Brumbaugh Sr.James W. Brumbaugh Sr.

61

New contributor

James W. Brumbaugh Sr. is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 12 hours ago

James W. Brumbaugh Sr.James W. Brumbaugh Sr.

61