Search:

Type: Posts; User: jmcilhinney

Page 1 of 13 1 2 3 4

Search: Search took 141.60 seconds; generated 23 minute(s) ago.

  1. 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)...
  2. Replies
    3
    Views
    108

    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...
  3. 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...
  4. Replies
    13
    Views
    430

    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...
  5. 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...
  6. 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.
  7. 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...
  8. 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...
  9. 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.
  10. 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...
  11. Replies
    2
    Views
    124

    Re: Containers Not Growing in AutoSize

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

    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.
  13. Replies
    2
    Views
    117

    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....
  14. 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...
  15. Replies
    6
    Views
    247

    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...
  16. Replies
    1
    Views
    84

    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...
  17. 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...
  18. Replies
    1
    Views
    99

    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...
  19. Replies
    6
    Views
    247

    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.
  20. 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...
  21. 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...
  22. Re: System Timer and DataBinding

    If you have code that is not UI-related itself but may affect an application's UI and you want to make it thread-safe then the SynchronizationContext is definitely the way to go. The Send method is...
  23. Re: BASS_ChannelGetTags and BASS_ChannelSetSync

    VS isn't throwing anything. It's your app that's throwing the exception. That suggests that your are using a Timers.Timer, which raises its Elapsed event on a background thread, rather than a...
  24. Re: Return the Index value of a datatable, by searching the Datatable

    If only the DataTable had a property dedicated to that and the documentation for that property included a code example. Oh look, it does!
  25. Re: Return the Index value of a datatable, by searching the Datatable

    So then read the documentation and search for examples on the web.
  26. Re: Return the Index value of a datatable, by searching the Datatable

    The Rows collection of a DataTable has a Find method that will find a DataRow by primary key. The index is irrelevant because you'd only be using that to get the row and that Find method returns the...
  27. Re: How to set the Explorer window of a specific file as a child window of TopMost fo

    Without having looked, I believe that you can find a window by the text in the title bar too.
  28. Re: How to set the Explorer window of a specific file as a child window of TopMost fo

    You're likely not going to be able to get the window handle via a process, or not in all cases anyway. Windows/File Explorer has an option "Launch folder windows in a separate process" but I don't...
  29. Re: How to set the Explorer window of a specific file as a child window of TopMost fo

    So where exactly in that code is the problem? Do you understand what it's doing? Where exactly does what it does differ from what you expect in your specific case? That's the sort of information that...
  30. Re: How to set the Explorer window of a specific file as a child window of TopMost fo

    A lot of people don't really seem to understand what the word "example" means. An example is something that demonstrates a principle that you can then implement for yourself in other scenarios. The...
  31. Re: Use non ClearType or Non TTF Fonts in VB

    Neither. It's a new class. You add a new class to your project and that will add a new code file. That's where you add the code. Once you build, that new control will be added to your Toolbox and you...
  32. Replies
    13
    Views
    430

    Re: Need a little help with vb2017...

    Also, please don't post unformatted code snippets. They are too hard to read.
    Public Class Form1
    Private stopwatch As New Diagnostics.Stopwatch
    Private Sub Form1_Load(sender As Object, e...
  33. Replies
    13
    Views
    430

    Re: Need a little help with vb2017...

    VB 2017 is VB.NET, as is everything from VB.NET 2002, VB.NET 2003, VB 2005 and onwards. They officially dropped the .NET suffix from VB and VS in 2005 because .NET was supposed to be considered the...
  34. Replies
    4
    Views
    211

    Re: Issue with password window

    And yet the code in post #4 is quite different to the code in post #1. If you want help with code then it's a good idea to post the code you want help with. Mind you, MessageBox.Show is specifically...
  35. Replies
    4
    Views
    211

    Re: Issue with password window

    Definitely not VB.NET, as Workbooks.Open has no parentheses. Almost certainly VBA, given that Workbooks is unqualified.
  36. Replies
    94
    Views
    2,074

    Re: Reparations for slavery

    I'll review to try to make sure I didn't misinterpret.
  37. Replies
    94
    Views
    2,074

    Re: Reparations for slavery

    Yeah, I'm going to have to call bullsh*t on that. It might be true of some individuals but I see no evidence that that attitude is more prevalent within minorities than it is the straight, white,...
  38. VS Code Re: Filter by Date not working on DatagridView_vb_vs2019

    Also, why are you using parameters for the dates but not the text? Use parameters for ALL values.
  39. VS Code Re: Filter by Date not working on DatagridView_vb_vs2019

    It's like you just ignored everything that everyone posted and just repeated what we already knew. If you're not prepared to provide details then we have to guess. Some may not be prepared to guess...
  40. Replies
    3
    Views
    165

    Re: [RESOLVED] I'm "Boggled"!

    Doing so may be slightly more difficult in VB6 than VB.NET but not particularly so, so I would suggest you do here as I have suggested there, i.e. put all the items into a list, select one at random...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width