Search:

Type: Posts; User: Chrissy

Page 1 of 7 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    2
    Views
    931

    Re: Help with Design please

    Thanks for the response... I will move ahead using the DataGridView.
    Chrissy :)
  2. Replies
    2
    Views
    931

    [RESOLVED] Help with Design please

    I am rewriting a program originally created in VB6. I have data that was originally displayed in an MSFlexGrid (see attachment). The highlighted rows are user input and the others are calculated...
  3. Re: [.NET 2.0+] Adding a ComboBox Column to a DataGridView

    I knew it was something easy! Thank you so much for your help.
  4. Re: [.NET 2.0+] Adding a ComboBox Column to a DataGridView

    Thank you for the wonderful explanation! Everything worked like charm except I don't know how to update my database from the selection in the drop down.

    I am loading information into the...
  5. Re: Help with best practice for loading data

    Yes, I was able to tweak your code and it worked great.

    I regards to the UI... I like to keep an open mind and try to see where others are coming from in design. Just trying to understand... you...
  6. Re: Help with best practice for loading data

    There is no ambiguity... the instructions literally say... leave blank to run for all partners. :) This is how all of our reports are. There could be 10 filters on a form... mandatory fields are...
  7. Re: Help with best practice for loading data

    Thank you for the reply, this helps a lot! The design is mimicked after our main accounting system. There are many fields for the user to filter the data on. Checking a box rather than leaving...
  8. Re: Help with best practice for loading data

    Yes... this is what I want. :)

    This is what I am going for... basically I am creating a statement for the owner. The same code would be applied either to only one owner. Or, if left blank, it...
  9. Re: Help with best practice for loading data

    I added the code as stated above and it works great for loading my combo boxes. However, I am now having an issue with my old code for looping through the combo box. For example, I have a Statement...
  10. Re: Help with best practice for loading data

    :lol:
  11. Re: Help with best practice for loading data

    I have a splash screen and plan to load the data into the lists when the program starts. This way the data will be ready when needed.

    Thanks for your input!
  12. Re: Help with best practice for loading data

    That makes sense...Thank you so much!

    FYI-My company is not the owner of the database... we only have read access to it, so I cannot change the field names.
  13. [RESOLVED] Help with best practice for loading data

    Hello!

    I am new to VB.NET... trying to convert all my VB6 programs and am trying to update them in the process.

    I have a program that is mostly used as an interface to our main accounting...
  14. Re: [RESOLVED] Object reference not set to an instance of an object

    Agreed... thanks for your help.
  15. Re: Object reference not set to an instance of an object

    Thank you! Problem solved. :)
    :wave:
  16. Re: Object reference not set to an instance of an object

    I figured out why I am getting the error message.

    I have code in the SelectedIndexChanged event for the combobox and am guessing it is being fired when trying to set the datasource of the...
  17. Re: Object reference not set to an instance of an object

    When I hover over each part is shows the folloing:

    cmbX = {System.Windows.Forms.ComboBox, Items.Count: 0}

    cmbX.DataSource = Nothing

    desc shows all the values it should.

    Once I execute the...
  18. Re: Object reference not set to an instance of an object

    cmbX is a combobox that I am trying to load with an array of the clsComboTag class. All the code is in my original post.
  19. Re: Object reference not set to an instance of an object

    Positive that is where the error is. Could it be with the code surrounding "desc"?
  20. Re: Object reference not set to an instance of an object

    The code is not on the form. It is in a separate class.
  21. Re: Object reference not set to an instance of an object

    I still get the same error when moving it to the Shown event.

    I have "Option Explicit On".. could it be something that is not properly cast?
  22. Re: Object reference not set to an instance of an object

    Maybe I am not coding something right... I am new to VB.NET, most of my experience is in VBA and VB6.

    cmbX is a combobox passed from my load event of the form. The cmbTax is already drawn on the...
  23. [RESOLVED] Object reference not set to an instance of an object

    Hello,

    I am getting an error when trying to update a combox. The error I get is "Object reference not set to an instance of an object". I have to click "OK" a couple of times, then the form...
  24. Re: Change Connection String in multiple workbooks (vba)

    There are multiple users.

    Thank you for your reply. I wasn't sure if there was a better way. I tried searching and someone mentioned an add-in, but I don't think that is what I need.
  25. Change Connection String in multiple workbooks (vba)

    Hello,

    I have many Excel workbooks that have a connection to a cloud based SQL server database. The IP address has since changed and I need to go into all of the workbooks and change the...
  26. VS 2010 Re: Need to change where links in Excel workbooks point

    Looks like you got the hang of it.... I only know the VBA code for looping through files.

    I would think it should be fairly easy to fine the code to loop through a directory if you google it. :)
  27. Re: Retrieving index of combobox in datagridview for update to DB

    I am still confused how to do this with the data I need to show and update.

    Here is the query for all the information I need to show in the grid.


    select p.name, t.ocode, t.Percent_Type,...
  28. Re: Retrieving index of combobox in datagridview for update to DB

    Thank you Jmcilhinney... The concept just seems so foreign to me! I know I need to change the way I think about coding with .Net versus vb6, but it is difficult for me.

    I will take a look at...
  29. VS 2010 Re: Need to change where links in Excel workbooks point

    If you are dumping results into file, you need to create and write the results to the file... currently you are doing nothing with the link


    Private Sub Form1_Load(sender As Object, e As...
  30. VS 2010 Re: Need to change where links in Excel workbooks point

    Can you copy and paste what the link looks like so I can see it?
  31. VS 2010 Re: Need to change where links in Excel workbooks point

    If you know the directory of the files you want move, you should just be able to search for that and replace it with the new directory.

    Unless I am missing what you are saying, the REPLACE()...
  32. VS 2010 Re: Need to change where links in Excel workbooks point

    I am not sure if the syntax in VB.NET is different than that of VBA... that said, when you loop through the cells of each workbooks, you could just use the REPLACE function. It exists in VBA, I...
  33. Retrieving index of combobox in datagridview for update to DB

    Hello,

    Most of my experience in in VB6... I am trying to convert to VB.NET. I have visual studio 2013.

    I have a datagridview with multiple comboboxes. The idea if for the user to select...
  34. VS 2010 Re: Can't connect VB10 located on VLAN A to MySQL Server located on VLAN B

    Can you post the connection string you are using?
  35. Re: Populate datagridview combobox based on index

    I figured it out... here is my code for future reference.


    Dim db As New DataAccess.sqlDataBase("hp_accting")

    Try
    dtgAllocation.Columns.Add("Description",...
  36. Re: Populate datagridview combobox based on index

    I am having trouble displaying the information in the CB. I can retrieve the data fine, just can't populate the combobox using the index.

    Is there a way around not having a selectedindex? ...
  37. Re: Populate datagridview combobox based on index

    Yes



    Yes. I was able to populate the drop downs with the choices successfully, I just can't get them "selected".

    Every combo box on the entire grid has all the same choices, but each one...
  38. Re: Populate datagridview combobox based on index

    Yes



    All combo boxes have the same list values. All have a choice of "Direct", "Indemnification" or "Other". The database stores the corresponding index value (0-Direct, 1-Indemnification,...
  39. Re: [EXCEL] Help to edit script which gets stats from a web site.

    I could probably help you out if you attached the excel file... would take to long to look at the code as posted to figure it out. Sample data also helps.
  40. [RESOLVED] Populate datagridview combobox based on index

    Hello,

    Most of my experience is with VB6 and VBA. I am new to .NET.

    I have a datagridview that I am creating dynamically because the number of columns is based on the data returned from the...
Results 1 to 40 of 280
Page 1 of 7 1 2 3 4



Click Here to Expand Forum to Full Width