dcsimg

Search:

Type: Posts; User: OptionBase1

Page 1 of 13 1 2 3 4

Search: Search took 0.68 seconds.

  1. Re: Find the closest Number compare to a list of Numbers VB6

    I disagree - I was simply trying to get an answer to what OP's definition of "close" was. Whether over or under by equal amounts were equally close, or if one was preferred to the other (Price is...
  2. Re: VBScript Importing .txt file to .xlsx file

    Your "For irow" statement inside the Do-Loop is the cause of the problem. It is creating a new row of data for every element in the array for each line read, which presumably is wrong. It should be...
  3. Replies
    28
    Views
    635

    Re: VB 2019 runs extremely slowly

    I have this link saved from the Wayback machine for the VS2010 Express ISO file.
    ...
  4. Re: Find the closest Number compare to a list of Numbers VB6

    Last chance.

    If I traveled into the future and you got your program running and I ran it with the following values:

    Textbox1: 1
    Textbox2: 1
    Textbox3: 1
    Textbox4: 5
    Textbox5: 7
    Textbox6: 6
  5. Re: Find the closest Number compare to a list of Numbers VB6

    One more time.

    If TextBox6 has the value of 7, and TextBox1 has a value of 6 and TextBox2 has a value of 8, then both TextBox1 and TextBox2 are off by one, so they are equally close.

    So, in...
  6. Re: [RESOLVED] Find the closest Number compare to a list of Numbers VB6

    Several things.

    Again, this thread is marked as resolved. To people viewing the forum, a thread marked as resolved indicates that the person posting the question has received an answer to that...
  7. Re: [RESOLVED] Find the closest Number compare to a list of Numbers VB6

    Your thread is marked resolved. That fact alone will probably limit the number of people who even read this thread, let alone attempt to assist.

    Good luck.
  8. Replies
    7
    Views
    240

    Re: listbox compare qustion

    None of this makes any sense. You say remove list2 un-matched items, which would imply that the remaining items in list2 are the items that matched with list1. But then you say that the unmatched...
  9. Replies
    124
    Views
    7,210

    Re: Hamilton 5x World Champion ?

    I was very impressed with Albon in the second half of the race. At the beginning he was mired back around 13th the whole time, and I was worried that he might make Red Bull second guess their driver...
  10. Re: Skipping FOR loop instance within an IF statment

    Probably a good candidate for the often overlooked Re-Enter Method (Rem) command. One For Loop can only have one standard Next statement, but if you use the Rem command it will allow you to use an...
  11. Re: Trying to create a completely unqieu 256 textbox array

    Disclaimer up front - I started reading your wish list of how you want this to work and stopped reading pretty quickly since it seemed unnecessarily complicated.

    If all you want to do is get each...
  12. Re: Using a Varable to reference various Controls

    Set objVariable = Nothing

    Then, to check if it is nothing:


    If objVariable Is Nothing Then
  13. Re: Using a Varable to reference various Controls

    Very rudimentary example just to demonstrate the concept.

    Create a new project with a button, label, textbox, and option button on the form with default names. Set the Form's KeyPreview property...
  14. Replies
    15
    Views
    432

    Re: Conversion varchar to numeric Error

    In your code you have a msgbox to display the SQL command right after your SQL statement is built. Did you notice that ALL values in your Insert statement are surrounded by single quotes? Well,...
  15. Replies
    15
    Views
    432

    Re: Conversion varchar to numeric Error

    No one can read the screenshots you posted to see what the data types are in your database. That being said, no one should have to for you.

    You have the data types in front of you. You have the...
  16. Replies
    14
    Views
    545

    VS 2017 Re: How can I let my app expire?

    Don't give anyone that is leaving your company source code that you've developed as part of your job. If this source code was written on your own personal (non-compensated) time, then it is up to...
  17. Re: VBA - Adding Dashes Automatically Into Text Box

    Mentally test driving your code, what happens if, after I enter 123 I realize that I should have entered 124?

    Stepping it out.

    I type 1
    I type 2
    I type 3
    The code inserts a dash after the...
  18. Re: List file types in all user directories

    The confusing thing is that the code you posted seems to indicate that you already know how to get all subfolders in a given folder, which is all you need to do.

    Wrap your existing code in a...
  19. Re: Works as a list but not in a loop

    I gave zero brain effort to trying to actually decipher what your non-working code is doing, but in the below snippet, u can't ever be > 90 since in the line immediately before the if statement it is...
  20. Re: Problem with Dropdown list on selection change

    Post the Page Load code.
  21. Replies
    124
    Views
    7,210

    Re: Hamilton 5x World Champion ?

    There is a huge difference between a competitive 6th place in points, and barely 6th place in points. There is a huge gap between Team Red Bull and the next best team in F1, the fact that he was...
  22. Re: Problem with Dropdown list on selection change

    Probably an issue where you aren't properly handling IsPostBack state, but impossible to say without seeing your code.
  23. VS 2019 Re: old man looking for help running a batch file

    If this is just for your own usage, if you copy that exe file to your Windows folder, it should resolve the problem since that should make it universally available via command prompt.

    Otherwise,...
  24. Re: Extract Attachment from Email Crashes

    Complete shot in the dark since I've never written any code to do what you are doing, but the Item() array might be 0 based, so it might be worth trying replacing Item(j) with Item(j-1) in the two...
  25. Re: Using UBound elements from existing array to create new array?

    Dim strlinecount_workaround As String
    Dim lcounter As Integer
    Dim arraymax As Long
    'assume strsourcefilearraycount has elements in it, for example in this case 92978 elements,
    'and has been...
  26. Re: Publishing a database project from Visual Studio 2017

    Maybe you are confusing mdf files with mdb files, I don't know.



    Behind the scenes, your data, stored in that table you reference, which is stored in that database you reference, is all stored...
  27. Re: Publishing a database project from Visual Studio 2017

    No one said anything about Access until this post of yours, and an mdf file is not an Access database file.
  28. Replies
    124
    Views
    7,210

    Re: Hamilton 5x World Champion ?

    I'm guessing they underestimated how much quicker Lewis would be than Max and were hoping he could hold Lewis off if only just. And once it was clear that he was going to catch Max, there weren't...
  29. Replies
    32
    Views
    958

    Re: Setup Installer Errors

    Prior to any code that attempts to access files from that path, add code to check to make sure that the ...\FDS\FDSPro\ folder exists.

    If that path doesn't exist, add code that will create the...
  30. Replies
    11
    Views
    586

    Re: Determining Row and Column

    A "certain number" means what, exactly? Like Elroy, I assumed you were talking about a number that is stored as a value somewhere in the 2D array. After your last post, it is clear that you weren't...
  31. Re: Problem when sending data from Listview to textbox

    Well, then maybe it would be best to either explain how you would like the result to look, or post an image of what you would like the end result to look like. As it stands, I'm not keen to make any...
  32. Re: Problem when sending data from Listview to textbox

    Making txt_Desig wider seems like the obvious suggestion.

    Another option is to set the ScrollBars property of txt_Desig to "1 - Horizontal" while in design mode, which should prevent the wrapping...
  33. Replies
    14
    Views
    677

    Re: Screen position for form on top

    Based on your location, I would imagine English isn't your primary language, and your English is much better than my Dutch, but people here don't usually react well to posters essentially demanding...
  34. Replies
    3
    Views
    336

    Re: Overflow error

    Note that your function is set to return a double, and i% is an Integer, but that isn't why the overflow is happening.

    21483520 * 100 = 2148352000, which exceeds the maximum value of a Long.
    ...
  35. Replies
    14
    Views
    705

    MsOf365 Re: Strange Run-time error '6' Overflow

    The first step is to rework your code to get rid of all of the GoTo statements.

    Without tracing through your code, it is clear that it is hitting the MaxNum = MaxNum + 1 statement more times than...
  36. Re: Publishing a database project from Visual Studio 2017

    Do you recognize the workstation name of DESKTOP-XXXXXXX? Is that the name of the PC that you write your VB.NET code on?
  37. Replies
    3
    Views
    328

    Re: Problem with Open file

    Seems highly unlikely that what you say above that I've bolded is true.

    After line 2, Directory will contain "C:\Users\ace\Documentsweb" - the backslash that you say is present between Documents...
  38. Replies
    124
    Views
    7,210

    Re: Hamilton 5x World Champion ?

    Wow! A race for the ages!
  39. Replies
    124
    Views
    7,210

    Re: Hamilton 5x World Champion ?

    Mattia Binotto likely to be out as Ferrari Team Principal during the F1 summer break.
  40. Replies
    124
    Views
    7,210

    Re: Hamilton 5x World Champion ?

    Gasly will be out of his seat during the summer break after next week's race in Hungary, that seems like a lock, even before his crash in practice today. McLaren stated a couple weeks ago that they...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width