Search:
Type: Posts; User: Richard Friedman
Search:
Search took 0.01 seconds.
-
That is an excellent solution.
Thank you very much.
-
showing the whole "AddInletCurve" routine is not practical here, but here is some of the code. I have verified that these lines are executed for both the instance where the legend appears and the...
-
I have a chart on a form that has all its default properties unchanged from when I added it from the toolbox.
Call a routine named "AddInletCurve" during runtime and it behaves as desired. In...
-
I was not able to find a resource for Publishing that would install all the projects library files in the GAC during a software installation. I did find examples for creating a single dll and...
-
Here’s the Big Picture
Years ago, I developed a suite of VB6 engineering programs that I made available to all the engineers in my company. I placed the executables in a folder system according...
-
Excellent,
In the VB6 Windows 7 World the library files were installed in the windows /System /System32 / or /SysWOW64 folders and any program could get to them.
In that VB6 world I developed a...
-
Yes, it was already in place.
All I did was to move the executable, that was in that same folder as the library files, to a different place.
The program would open up and behave normally up to...
-
Thank you, I hope my response is directed to the Application Deployment site.
I The PowerPacks Library is automatically included in the distribution.
When I check a computer where the...
-
If I understand Publishing correctly, I have an option to make the application available offline or only online.
I wish to make the application available offline When the application is installed...
-
Thanks for your thoughts. I was stuck in a database conversion routine updating an Access database from a vb6 application to vb net. I figured out a work around.
-
This is my first deployment of a VB Net application.
I believed I published it correctly
It runs perfectly on the computer that created it. (Windows 10)
But when I Install it on a Windows 7...
-
I developed a routine to generate an Update command that constructed a SET statement that included every column in any DataTable and a Where statement pointing to the rows Primary Key.
This worked...
-
Thank you for that correction. It allowed my code to run without any errors.
Regrettably, the database did not change because the rowstate was not triggered.
Because I don't fully understand how...
-
I suspect that I an not creating the update command properly. Can you take a look?
Public Sub TestPortPlate()
Dim dt As New DataTable
Dim sCol As String
Dim sKey As String
Dim da...
-
I think my table is poorly constructed (that's the way I got it, and I can't change it)
The process that I outlined above works on simple tables, but this particular table has many similar columns...
-
This is the process
At the start of the program I load an array of tables and adapters from a database
For i = 0 To UBound(gsTableNames)
Sql = "Select * from " & gsTableNames(i)...
-
This works nicely
Thanks
How do I mark the topic as RESOLVED?
-
This almost works.
It fails however on tables that already have a primary key (not of the same name)
Any suggestions?
-
I have a DataTable that has 192 columns.
When one of the rows is selected through an interface. some of those column values get loaded into unbound text boxes.
When the user exits the form, all...
-
I am referring to deleting contents the DataTable and then using the DataAdapter to update the database.
Perhaps I could use the method you suggest and then reload the DataTable from the Database. ...
-
-
Is their a bulk method for deleting all the rows in a DataTable such that the RowState for all rows is set to Deleted.
I have a table with several thousand records that I constantly clean out and...
-
Thanks,
I am not sure you can do this on a Database Table that is already populated, but this would fit in my first routine above where I create an empty clone of the database and its tables, add...
-
Fortunately I run no query's
Regrettably I inherited the Database so I am stuck with the column names
Thanks I have applied your recommendations
Richard
-
I had previously created some conversion code to update a Database to have a primary key, but I had failed to implement the "AutoIncrement" property
I created a new conversion routine to run on...
-
I have inherited an existing Access Database that has a table with a field defined as a "short string"
This database gets loaded into my projects DataTable via OleDbDataAdapter and...
-
I have a Primary Key that is an integer
I have a DataTable that has many rows from which I have deleted some.
When adding a new row I query the DataTable for the Highest Number and Assign that...
-
Thank you.
I examined my RowStates for each row, as well as their contents and compared that to the contents of the database and found that I had "removed" a row, but there was no RowState...
-
I read in an access database and populate data tables and adapters
PBcon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Temp_PumpBuilder\Temp_PumpBuilder_Database.mdb"...
-
After removing all my calls to AcceptChanges(), I found that all my edits the the DataGridView were written properly back to the database (stored on my C drive) correctly.
However, there are many...
-
Thank you jmcilhinney for those suggestions, it cleared up some misunderstandings that I had and now everything is working fine.
I copied those routines from another more complex project that I...
-
On two separate computers I have loaded Microsoft ActiveX Data Objects 2.8 Library
On separate projects in each I use
Dim rs As New ADODB.Recordset
-
'I have an array of DataTables,Adapters, and CommandBuilders
Public gda(14) As OleDbDataAdapter
Public gdt(14) As DataTable
Public gcb(14) As OleDbCommandBuilder
-
I have created a number of pdf files that I wish to combine into one
I have the titles stored in a "sFileName() as string" array
I am looking for a routine that will read this array and add them to...
-
The following code sends a Document to a PDF Printer
The ProcessStart then opens it
Unfortunately it attempts to open it before the job is done printing
I put in the loop on Dir(sFileName) to...
-
Thank you for the code samples.
Unfortunately I have a form with many datagridviews' and other objects such as labels and charts that scroll down the length of the form.
I am trying to find a way...
-
I am creating a report by dynamically adding populated datagridview's of various lengths to a Form.
I would like to print the output and fit it to 8-1/2 X 11 pages
Among the challenges is...
-
Many thanks, a great idea, But it did not make a difference. If I go to the immediate window I see that the cells value matches the value in the datatable.
Is their a way, after the load event,...
-
I dynamically create columns in my datagridview
The columns that are ComboBox have items added to them when they are being created.
Most of these items are strings, but one column has numbers...
-
I have a DataGridView on my form. If the user enters a cell and types in a new value, but then instead of clicking on another cell or typing the "Enter" key they click on a different object on the...
|
Click Here to Expand Forum to Full Width
|