Search:
Type: Posts; User: ssabc
Search:
Search took 0.03 seconds.
-
The value changes, and I need it to change back to what is defined.
-
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. ...
-
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...
-
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...
-
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...
-
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...
-
-
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...
-
Yes, Adobe Reader is installed...
-
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...
-
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:...
-
-
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:
-
Silly me, Read Only = False. Sorry for the dumb question!
-
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!
-
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...
-
jcm:
There is one record, which I added manually (ID column auto generated with a value of 1). Dataset matches table.
184973
184974
Thanks!
-
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.'
...
-
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...
-
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....
-
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...
-
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...
-
Hello:
Same kinds of errors...
If _appendsheet = True Then
' xlWorkBook = xlApp.ActiveWorkbook
' xlWorkSheet = CType(xlWorkBook.Worksheets().Add.Name = _sheet,...
-
Hello:
System.NullReferenceException. 'Object reference not set to an instance of an object.' in this line below:
xlWorkSheet = CType(xlWorkBook.Sheets(1),...
-
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...
-
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
...
-
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...
-
-
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...
-
I entered this...
_dgv.Columns.AddRange(frmRequest.dgvParts.Columns.Cast(Of DataGridViewColumn).ToArray())
_dgv.Rows.AddRange(frmRequest.dgvParts.Rows.Cast(Of...
-
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...
-
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...
-
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...
-
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...
-
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
-
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?...
-
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" &...
-
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 =...
-
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...
-
|
Click Here to Expand Forum to Full Width
|