Tjyylli

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

"Working on a knee"

Retract an already submitted Recommendation Letter (written for an undergrad student)

Protagonist's race is hidden - should I reveal it?

Writing a T-SQL stored procedure to receive 4 numbers and insert them into a table

What to do with someone that cheated their way though university and a PhD program?

false 'Security alert' from Google - every login generates mails from 'no-reply@accounts.google.com'

How would it unbalance gameplay to rule that Weapon Master allows for picking a fighting style?

Coin Game with infinite paradox

What is the evidence that custom checks in Northern Ireland are going to result in violence?

Suing a Police Officer Instead of the Police Department

My admission is revoked after accepting the admission offer

Mechanism of the formation of peracetic acid

Is it appropriate to mention a relatable company blog post when you're asked about the company?

What is the ongoing value of the Kanban board to the developers as opposed to management

Is it OK if I do not take the receipt in Germany?

What helicopter has the most rotor blades?

Why did Europeans not widely domesticate foxes?

A journey... into the MIND

Is Bran literally the world's memory?

Does a Draconic Bloodline sorcerer's doubled proficiency bonus for Charisma checks against dragons apply to all dragon types or only the chosen one?

Determinant of a matrix with 2 equal rows

Where/What are Arya's scars from?

Is a self contained air-bullet cartridge feasible?

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 10 hours ago

zx485

1,4672914

asked 11 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 10 hours ago

zx485

1,4672914

asked 11 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 10 hours ago

zx485

1,4672914

asked 11 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 10 hours ago

zx485

1,4672914

asked 11 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 10 hours ago

zx485

1,4672914

asked 11 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 10 hours ago

zx485

1,4672914

edited 10 hours ago

zx485

1,4672914

asked 11 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 11 hours ago

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

61