Search:

Type: Posts; User: jmcilhinney

Page 1 of 13 1 2 3 4

Search: Search took 2.55 seconds.

  1. Re: Creating external subroutines for multiple VB programs

    That is generally a bad idea except in very specific circumstances. If it is exactly the same functionality in each case then that functionality should exist in one place only. Otherwise, if you find...
  2. Re: combobox value instead of text.

    I don't really know what you're trying to say there but it's not really relevant anyway. Look at the title of the thread. The topic, as described by that title, was addressed in full by post #2....
  3. Re: colour for buttons on datagrid to change if sql record exists

    Having said all that, you should not be using the grid at all in this and you should also not be querying the database repeatedly. If you were going to do it this way, you should first gather all the...
  4. Re: colour for buttons on datagrid to change if sql record exists

    Lots to change there. Firstly, you should learn to use the loop most appropriate for the situation. A Do loop is definitely the wrong option here. The only way it could be more wrong is if you used...
  5. Re: Creating external subroutines for multiple VB programs

    That's exactly what libraries, i.e. DLLs, are for. All the .NET Framework types are declared in libraries and you reference those libraries in your project to gain access to those types. That's...
  6. Re: combobox value instead of text.

    This has got nothing to do with the topic of this thread. If the issue you ask about is resolved then you should mark the thread Resolved. If you have a different issue then you should create a new...
  7. Re: How to add a form control on top of a main form control

    What are you actually trying to achieve here? You've described how you're trying to achieve it but not what you're actually trying to achieve. If you want a RichTextBox and a ListBox to occupy the...
  8. Replies
    3
    Views
    138

    Re: Automatically send space bar key

    It appears that that application has been specifically designed to prevent people automating it. It's not really for us to help you specifically circumvent the wishes of that application's developer.
  9. Replies
    3
    Views
    138

    Re: Automatically send space bar key

    If you call SendKeys.Send then that should, theoretically, be treated by the system and applications as normal keyboard input. As a result, you'll need to make sure that the desired application has...
  10. Re: combobox value instead of text.

    You need to bind the data and set the ValueMember, e.g.

    Dim items As New List(Of Object)

    items.Add(New With {.Text = "Freezer Controller M1", .Value = "WFM1"})
    items.Add(New With {.Text =...
  11. Replies
    1
    Views
    93

    VS 2008 Re: Split Database data into label size

    Why would you have five Labels? Just use one Label and it will wrap automatically exactly how you want. Just add a single Label to your form, set AutoSize to False and then set the Size...
  12. Replies
    4
    Views
    355

    Re: How to add 2 columns in the textarea?

    I very much doubt that that is what the OP wants. That rows attribute is the number of lines of text is visible and that columns attribute is the number of characters visible in a line. I suspect...
  13. Replies
    2
    Views
    144

    VS 2013 Re: Save Label as image file

    Like all controls, your Label has a DrawToBitmap method. Create a Bitmap of the appropriate size and pass it to that method. You can then save that Bitmap to a file.
  14. Replies
    2
    Views
    158

    Re: datagridview datatable date sort

    Firstly, you should specify the data type of each of your columns, e.g.

    dt.Columns.Add("Id", GetType(Integer))
    dt.Columns.Add("DateRecieved", GetType(Date))
    dt.Columns.Add("PartNumber",...
  15. VS 2019 Re: stuck trying to delete files - is being used by another process

    Yeah, I knew that it had to be because you couldn't have a function with no return type otherwise. There are reasons that it is Off by default but most experienced VB.NET programmers wish it was On...
  16. VS 2019 Re: stuck trying to delete files - is being used by another process

    One thing I would suggest that you do immediately is turn Option Strict On, both in the project properties and also in the IDE options, so that it is On by default in future projects. That will...
  17. VS 2019 Re: stuck trying to delete files - is being used by another process

    So much wrong with that code. The issue is that you're opening the file but not closing it, but there's plenty more that should be fixed. Firstly, your method has no return type. Secondly, you're...
  18. Re: Is it possible to connect SQLServer via internet without opening port like teamvi

    Other software is irrelevant. SQL Server works the way it works. Telling us how you think other software works isn't going to change that. If you're not going to listen to people when they try to...
  19. VS 2008 Re: Accessing path w/o knowing full path name

    Does Firefox store the root path in the Registry? If so, you should get the root path from the Registry first and then extend that using Path.Combine for each specific path.
  20. VS 2017 Re: Change a sql query to a datagridview filter to search between dates

    There is no such thing as a "datagridview filter" or "datagrid filter". Whether you're using a database (if you're having issues then you should try fixing them, not changing to an inferior solution)...
  21. Replies
    3
    Views
    129

    VS 2019 Re: count only newer files in directory

    You can get all the files in a folder and then filter by creation date/time. You have to have a value to filter by though. There's no magical way to get a "newer" file without knowing what it has to...
  22. Re: i have an excel file with table of values. I need to find all cells with name and

    You've posted this question in the VB.NET forum and then asked whether you can do it in VBA. You need to make up your mind first. If you want to do it in VBA then this thread should be in the forum...
  23. Replies
    13
    Views
    495

    Re: Need a little help with vb2017...

    Did you ever consider reading the documentation for the String.Format method that you're using to actually learn how it works? The manual exists for a reason. RTFM is not the only way to learn and...
  24. Re: conditional formatting of textbox font on a form

    Firstly, if you're not already, you should be binding your data to both the grid and the TextBoxes, e.g.

    myDataAdapter.Fill(myDataTable)

    BindingSource1.DataSource = myDataTable...
  25. Re: Issues with connecting to SQL Server from VB.Net using SQLOLEDB connection string

    Trusted_Connection is a synonym for Integrated Security. In theory, they should do the same thing.
  26. VS 2019 Re: Concurrency violation: the DeleteCommand affected 0 of the expected 1

    If your primary key is an AutoNumber then that means that it is generated by the database when you insert the record. When you save new records, do you retrieve that auto-generated value from the...
  27. VS 2008 Re: Accessing path w/o knowing full path name

    Then you did it wrong. If you don't show us what you did and tell us what actually happened then we'd need to be psychic to know what the problem is, or a very lucky guesser. The alternative is that...
  28. Re: Var access in anonymous functions

    You should do some reading on closures in .NET and come back with any specific questions you have after that.
  29. Re: Is it possible to connect SQLServer via internet without opening port like teamvi

    The port generally needs to be opened at the server end, not the client end. If the server port is not open then any request from the client will be rejected.

    That said, you really shouldn't be...
  30. Replies
    2
    Views
    143

    Re: Containers Not Growing in AutoSize

    Can you provide a screenshot of the Document Outline window to show the complete control hierarchy?
  31. Replies
    2
    Views
    149

    VS 2017 Re: Combo Box Number from Query

    On a separate note, is there a good reason that you're using OleDb to connection SQL Server instead of the dedicated SqlClient? If not, switch to using SqlClient instead.
  32. Replies
    2
    Views
    149

    VS 2017 Re: Combo Box Number from Query

    It sounds like you mean two columns rather than two rows. Also, according to your SQL, they are Codeid and descr, not code and name.

    As for the question, that's not really how ComboBoxes work....
  33. Re: How to get YouTube PlayList video links.

    That's never an adequate explanation. A proper explanation includes what you expect to happen and what actually happens. If there are compilation errors, what they are and where they occur is...
  34. Replies
    8
    Views
    318

    Re: Copying Data

    This is basically what I was going to suggest after reading your previous post. The user in the database couldn't possibly be mapped to the login in the instance because the instance was new so the...
  35. Replies
    1
    Views
    95

    VS 2010 Re: Do something if date is expired

    Why would you be using Strings if you want to compare dates? Do you use Strings to compare numbers? No, you use a numerical data type. If you want to compare dates then use the data type that is...
  36. Re: How to get YouTube PlayList video links.

    Are you aware that that data is in JSON format? That is probably THE most common format for exchanging data with web APIs these days. I suggest that you do a bit of research on JSON and working with...
  37. Replies
    1
    Views
    113

    VS 2017 Re: Change sql query to XML

    The DataSet and DataTable classes both have ReadXml and WriteXml methods so you can read and write directly to and from XML files. Once you have all the data in a DataTable, you can filter by...
  38. Replies
    8
    Views
    318

    Re: Copying Data

    Does the database version have to match the instance version? You could just backup the database on the old instance and then restore it on the new instance.
  39. Re: Issues with connecting to SQL Server from VB.Net using SQLOLEDB connection string

    I see that you have been using VB.NET for several years so I also have to question why you aren't using it "properly". If you're upgrading a VB6 application that already uses ADO then that's one...
  40. Re: How to keep focus on textbox when opening a browser or another app from an action

    It may or may not be what you want but it is possible to create a custom Button control that doesn't take focus when you click it. That would solve that part of the problem at least. If you're...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width