Search:

Type: Posts; User: ssabc

Page 1 of 13 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    6
    Views
    654

    VS 2017 Re: Select specific index item in a combobox

    The value changes, and I need it to change back to what is defined.
  2. Replies
    6
    Views
    654

    VS 2017 Select specific index item in a combobox

    Hello:

    I think this is fairly simple, but apparently not. Specifically, its item 39 in my example, which is the value of idx. So, I would like to then select the 39th item in my combobox. ...
  3. Replies
    6
    Views
    841

    VS 2017 How can I add two simgle quotes to a query

    Hello:

    I am not sure why this is happening.

    "(CASE WHEN glcParentGLChartID = " & chr(39) & chr(39) & " THEN glcGLChartID ELSE glcParentGLChartID END) AS glcParentGLChartID, " _

    The query...
  4. Replies
    6
    Views
    1,088

    Re: DataSet - enable constraints issue

    The fourth row is blank, it shows up because its an edit query instead of a select query in SQL. Teh table is just what the code is looking up through Typed Datasets...
  5. Replies
    6
    Views
    1,088

    Re: DataSet - enable constraints issue

    I will research "ON UPDATE CASCADE"

    PK is a primary key in all tables. EmpNo is also a primary key in the EmpData (main table). It is what drives the data in the other tables.

    All...
  6. Replies
    6
    Views
    1,088

    DataSet - enable constraints issue

    Hello:

    I have a dataset that errors like this: System.Data.ConstraintException: 'Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key...
  7. Replies
    3
    Views
    712

    VS 2017 Re: OpenFileDialog Question

    Thak you!
  8. Replies
    4
    Views
    1,175

    VS 2017 Re: PDF Preview on VB.NET Form

    Note:

    These files in fact do exist in the bin\debug folder. I am just running this in debug more and getting the original posted error.

    I also got these errors when trying to renasm32 the...
  9. Replies
    4
    Views
    1,175

    VS 2017 Re: PDF Preview on VB.NET Form

    Yes, Adobe Reader is installed...
  10. Replies
    3
    Views
    712

    VS 2017 OpenFileDialog Question

    Hello:

    I would like to do this:
    .InitialDirectory = "%USERPROFILE%\PVS Sackett-Waconia Inc\Test Team for Shop"

    The goal would be to look at an O365 folder regardless of who is logged in. Is...
  11. Replies
    4
    Views
    1,175

    VS 2017 PDF Preview on VB.NET Form

    Hello:

    When I add the Adobe PDF Reader to my form, I get the following error on the automated developme nt portion of the code on the run:

    185955

    The error reads:...
  12. Replies
    2
    Views
    642

    Re: Typed DataSet not recognized

    Wonderful, Thanks
  13. Replies
    2
    Views
    642

    Typed DataSet not recognized

    Hello:

    Visual Studio 2017

    All of a sudden, out of nowhere, I am getting an error stating:


    Type 'ITResuestDataSetTableAdapters,RequestTableAdapter' is not defined.

    This code:
  14. Replies
    1
    Views
    467

    Re: Freeform Edit on Unbound DataGridView

    Silly me, Read Only = False. Sorry for the dumb question!
  15. Replies
    1
    Views
    467

    Freeform Edit on Unbound DataGridView

    Hello:

    I am struggling to find the option where I can edit my dataGridView in VB.NET. All populatioj is unbound and manual.

    Much Thanks!
  16. Replies
    4
    Views
    691

    Re: IDENTITY_INSERT is set to OFF

    jcm:

    I did a re-Configure on the table, and I think it's working now... The values matched, so I'm not sure why it needed that...
  17. Replies
    4
    Views
    691

    Re: IDENTITY_INSERT is set to OFF

    jcm:

    There is one record, which I added manually (ID column auto generated with a value of 1). Dataset matches table.

    184973
    184974

    Thanks!
  18. Replies
    4
    Views
    691

    IDENTITY_INSERT is set to OFF

    Hwllo:

    This is the first time I've seen this error.
    System.Data.SqlClient.SqlException: 'Cannot insert explicit value for identity column in table 'Request' when IDENTITY_INSERT is set to OFF.'
    ...
  19. Replies
    8
    Views
    1,239

    VS 2017 Re: Sort a 2D Array on two columns

    I have an array, 2D, 15 rows by hundreds of columns. I want to sort it based on column 8 first, then those results on column 7. This wold fefine primary and secondary.

    This is how I did it in...
  20. Replies
    8
    Views
    1,239

    VS 2017 Sort a 2D Array on two columns

    Hello:

    I am looking for the best way to sort a 2D array based on two columns, picking the first as primary and the second as secondary.

    Combing the web for examples, little help seems to exist....
  21. Replies
    9
    Views
    1,406

    MsOf365 Re: Add second sheet to Workbook in Code

    Am I not adding the first workbook when _appendsheet = False, and then adding a sheet to that when _appendsheet = True?
    At this time, I am only looking to have these two sheets created in this...
  22. Replies
    9
    Views
    1,406

    MsOf365 Re: Add second sheet to Workbook in Code

    My code is following he example of adding a worksheet to the end of a workbook. It keeps telling me it cannot find the instance of the workbook, even though that is established when the workbook...
  23. Replies
    9
    Views
    1,406

    MsOf365 Re: Add second sheet to Workbook in Code

    Hello:

    Same kinds of errors...

    If _appendsheet = True Then
    ' xlWorkBook = xlApp.ActiveWorkbook
    ' xlWorkSheet = CType(xlWorkBook.Worksheets().Add.Name = _sheet,...
  24. Replies
    9
    Views
    1,406

    MsOf365 Re: Add second sheet to Workbook in Code

    Hello:

    System.NullReferenceException. 'Object reference not set to an instance of an object.' in this line below:

    xlWorkSheet = CType(xlWorkBook.Sheets(1),...
  25. Replies
    9
    Views
    1,406

    MsOf365 Add second sheet to Workbook in Code

    Hello:

    I am creating a Workbook off of some datagridviews.
    The initial workbook works great.
    I would simply like to add a second sheet.

    Code below...

    Private Sub ExcelExport(ByVal _dgv...
  26. Replies
    11
    Views
    1,496

    VS 2017 Re: Read DataGridView from another form

    Great catch, thanks.

    Unfortunately, DT is still not populating, as DT.Rows.Count = 0


    MessageBox.Show(DT.Rows.Count)
    For c As Integer = 0 To DT.Rows.Count - 1
    ...
  27. Replies
    11
    Views
    1,496

    VS 2017 Re: Read DataGridView from another form

    I created a global variable for the whole solution called DT, in a Module.

    DT is populated from the Request form (this is the form containing dgvParts).


    Public Class DTClass
    Public...
  28. Replies
    11
    Views
    1,496

    VS 2017 Re: Read DataGridView from another form

    jcm: Thanks!
  29. Replies
    11
    Views
    1,496

    VS 2017 Re: Read DataGridView from another form

    The source grid is open in the app, called frmRequest. It is instantiated as frmR when opened from a previous form. I do not know how else to reference the open form. frmR of course, does not...
  30. Replies
    11
    Views
    1,496

    VS 2017 Re: Read DataGridView from another form

    I entered this...



    _dgv.Columns.AddRange(frmRequest.dgvParts.Columns.Cast(Of DataGridViewColumn).ToArray())
    _dgv.Rows.AddRange(frmRequest.dgvParts.Rows.Cast(Of...
  31. Replies
    11
    Views
    1,496

    VS 2017 Read DataGridView from another form

    Hello:

    All I want to do is read specific columns from an open form datagridview into a new datagridview on a new form.

    Perhaps I need to dump the values into some kind of container.

    Code...
  32. Thread: ADODB for 64-bit

    by ssabc
    Replies
    15
    Views
    4,332

    MsOf365 Re: ADODB for 64-bit

    Pete:

    Mu dilemma is that my SolidWorks and PDM applications no longer work in 32-bit mode starting with the 2021 version. I have one app that uses ADODB and the SolidWorks API’s. I can no...
  33. Thread: ADODB for 64-bit

    by ssabc
    Replies
    15
    Views
    4,332

    MsOf365 Re: ADODB for 64-bit

    Hello:

    If there is any hope for an answer to this question, I would greatly appreciate it. Perhaps something else than ADODB to get information from Excel spreadsheets and be able to reference...
  34. Thread: ADODB for 64-bit

    by ssabc
    Replies
    15
    Views
    4,332

    MsOf365 Re: ADODB for 64-bit

    Hello:

    I am registering at an elevated (run as administrator) command prompt.
    I also did a repair on the ACE provider.

    I also looked through the local system registry and did see several...
  35. Thread: ADODB for 64-bit

    by ssabc
    Replies
    15
    Views
    4,332

    MsOf365 Re: ADODB for 64-bit

    This is the same error I've been getting all along:
    'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.'

    183634
  36. Thread: ADODB for 64-bit

    by ssabc
    Replies
    15
    Views
    4,332

    MsOf365 Re: ADODB for 64-bit

    I had also done that!

    The link provided downloaded 'AccessDatabaseEngine_X64.exe'.

    I just did a repair on the install, and the issue persists. Is there some other program? Was the link wrong?...
  37. Thread: ADODB for 64-bit

    by ssabc
    Replies
    15
    Views
    4,332

    MsOf365 Re: ADODB for 64-bit

    Dim cn As String = "Provider = Microsoft.ACE.OLEDB.12.0; Data Source = " & "\\w2012\users\QUOTES\Templates\pricing report-2.xls" & "; Extended Properties = " & Chr(34) & "Excel 8.0; HDR = Yes" &...
  38. Thread: ADODB for 64-bit

    by ssabc
    Replies
    15
    Views
    4,332

    MsOf365 Re: ADODB for 64-bit

    Hello:

    I think I had most of this covered. Even the installation of ACE.

    Slight change to the connection string for xls file as follows:

    Dim cn As String = "Provider =...
  39. Thread: ADODB for 64-bit

    by ssabc
    Replies
    15
    Views
    4,332

    MsOf365 ADODB for 64-bit

    Hello:

    We just upgraded to SolidWorks and PDM 2021. I have some programs that utilizes accessing some spreadsheets to obtain data. Those programs use the Microsoft ActiveX Data Objects 6.1...
  40. Replies
    4
    Views
    1,301

    MsOf365 Re: Delete blank columns with VB.NET

    Beautiful, Thanks!
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width