Search:

Type: Posts; User: Richard Friedman

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. VS 2019 Re: Adding a Chart dynamically fails to show legend

    That is an excellent solution.
    Thank you very much.
  2. VS 2019 Re: Adding a Chart dynamically fails to show legend

    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...
  3. VS 2019 [RESOLVED] Adding a Chart dynamically fails to show legend

    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...
  4. Re: Publishing a Visual Basic Net application

    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...
  5. Re: Publishing a Visual Basic Net application

    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...
  6. Re: Publishing a Visual Basic Net application

    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...
  7. Re: Publishing a Visual Basic Net application

    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...
  8. Re: Publishing a Visual Basic Net application

    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...
  9. Publishing a Visual Basic Net application

    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...
  10. VS 2019 Re: Visual Basic Error instance valuetype ADODB.DataTypeEnum

    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.
  11. VS 2019 [RESOLVED] Visual Basic Error instance valuetype ADODB.DataTypeEnum

    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...
  12. VS 2019 Re: DataAdapter "Query is too Complex"

    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...
  13. VS 2019 Re: DataAdapter "Query is too Complex"

    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...
  14. VS 2019 Re: DataAdapter "Query is too Complex"

    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...
  15. VS 2019 Re: DataAdapter "Query is too Complex"

    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...
  16. VS 2019 Re: DataAdapter "Query is too Complex"

    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)...
  17. VS 2019 Re: Deleting Many Rows From A DataTable

    This works nicely
    Thanks
    How do I mark the topic as RESOLVED?
  18. VS 2019 Re: DataTable Adding Pirmary Key Values when adding a new row

    This almost works.

    It fails however on tables that already have a primary key (not of the same name)

    Any suggestions?
  19. VS 2019 [RESOLVED] DataAdapter "Query is too Complex"

    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...
  20. VS 2019 Re: Deleting Many Rows From A DataTable

    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. ...
  21. VS 2019 Re: DataTable Adding Pirmary Key Values when adding a new row

    OK, I like it
  22. VS 2019 [RESOLVED] Deleting Many Rows From A DataTable

    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...
  23. VS 2019 Re: DataTable Adding Pirmary Key Values when adding a new row

    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...
  24. VS 2019 Re: Failure to Update DataTables to Access Database with Primary Key

    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
  25. VS 2019 Re: DataTable Adding Pirmary Key Values when adding a new row

    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...
  26. VS 2019 Storing Comma Delimited Strings to DataTable/dataadapter/AccessDatabase

    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...
  27. VS 2019 DataTable Adding Pirmary Key Values when adding a new row

    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...
  28. VS 2019 Re: Failure to Update DataTables to Access Database with Primary Key

    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...
  29. VS 2019 Failure to Update DataTables to Access Database with Primary Key

    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"...
  30. VS 2019 Re: Saving DataTables bound to DataGridView back to Access DB

    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...
  31. VS 2019 Re: Saving DataTables bound to DataGridView back to Access DB

    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...
  32. Replies
    1
    Views
    260

    VS 2019 Two Versions of ADODB

    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
  33. VS 2019 Saving DataTables bound to DataGridView back to Access DB

    'I have an array of DataTables,Adapters, and CommandBuilders



    Public gda(14) As OleDbDataAdapter
    Public gdt(14) As DataTable
    Public gcb(14) As OleDbCommandBuilder
  34. Replies
    1
    Views
    265

    VS 2019 Combine PDF Files in VB Net

    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...
  35. VS 2019 Creating a PDF File and Opening it

    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...
  36. Replies
    4
    Views
    478

    VS 2019 Re: Visual Basic Net, Printing Form

    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...
  37. Replies
    4
    Views
    478

    VS 2019 Visual Basic Net, Printing Form

    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...
  38. VS 2019 Re: DataGridView DataGridViewComboBoxColumn not displaying datatable number values

    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,...
  39. VS 2019 DataGridView DataGridViewComboBoxColumn not displaying datatable number values

    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...
  40. VS 2019 DataGridView invoke CurrentCellChanged event when user does not hit enter

    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...
Results 1 to 40 of 92
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width