Search:

Type: Posts; User: K3JAE

Page 1 of 3 1 2 3

Search: Search took 0.03 seconds.

  1. Replies
    0
    Views
    284

    VS Code In a loop and can't stop.

    Please review the following code below.

    My intent is to check if a menu form is open and minimized. If it is, then once the main form is closed bring the minimized menu form back to the screen...
  2. Re: Trying to open a form if minimized and close a child

    I open a MENU program. I chose a particular sub-program. All programs are packaged into one 'program.' The MENU simply calls a separate program contained within the package. Once chosen the sub...
  3. Re: Trying to open a form if minimized and close a child

    That tells me nothing in relation to what I am trying to accomplish. I understand what FormClosing does.
  4. Trying to open a form if minimized and close a child

    Hoping I explain this properly.

    I have a form that opens a menu. With this menu I can open any one of 4 other 'sub programs' within.

    The menu Program is called PETS CONSOLE

    If I click on the...
  5. Re: Opening a Program from a minimized state then closing active program

    Not a possibility due to the stand-alone programs are not distributed throughout... thus why they are in multiple pieces... the request is for those with all pieces of the 'puzzle' so to speak.
  6. Opening a Program from a minimized state then closing active program

    Using the following code below I am attempting to close the current program and re-open a minimized program. If the initial program was closed by accident or on purpose, it will reopen it upon...
  7. VS 2019 Re: Populate textboxes with a zero if not included in search criteria.

    Noted and that make complete and total sense to me. Conversion to label will be done this evening!
  8. VS 2019 Re: Populate textboxes with a zero if not included in search criteria.

    Perfect! I will read up on this and study it to see if I am capable of implementing this.

    I am totally unfamiliar with the creation of a CheckedListBox from CheckedItems. This is completely new...
  9. VS 2019 Re: Populate textboxes with a zero if not included in search criteria.

    I'll have to study this in depth as this is beyond my understanding a bit.

    I do like the idea and actually was flirting with the idea of putting little check boxes by each state and checking them...
  10. VS 2019 Re: Populate textboxes with a zero if not included in search criteria.

    There are 3 text boxes that have formulas used to calculate totals and display them. Those would be TOTAL MILES, TOTAL GALLONS and MPG calculations. I could change those to labels if need be.
    The...
  11. VS 2019 Populate textboxes with a zero if not included in search criteria.

    If it can be done: Is there a way to put a '0' in all the textboxes of States that were not included in a search criteria?

    For Clarification...
    Assume I search Tennessee (TN) (for Miles driven...
  12. Replies
    22
    Views
    1,217

    Re: Attemping to pull in lines from a DT

    Good idea.... Thanks for those who assisted and it is much appreciated. I have learned a LOT and will utilize that new knowledge in my many other forms where required.

    Hats off to ALL for the...
  13. Replies
    22
    Views
    1,217

    Re: Attemping to pull in lines from a DT

    Just as a tid-bit add-on of a clarification... MILES can never be '0' if there is ANY gallons purchased. To put it simply one cannot by fuel in a state if one has not entered into said state.
  14. Replies
    22
    Views
    1,217

    Re: Attemping to pull in lines from a DT

    Let me clarify my request:

    I am look to populate 2 pieces of data : Miles and Gallons into 2 separate textboxes for each state.

    First step:
    If the data returned is NULL convert to a '0'.
    ...
  15. Replies
    22
    Views
    1,217

    Re: Attemping to pull in lines from a DT

    Your code results in the same thing I initially submitted above that appears to work the same. Please understand, I am not being argumentative, just trying to understand what functionally is...
  16. Replies
    22
    Views
    1,217

    Re: Attemping to pull in lines from a DT

    The above handles the issue of a null return but NOT the issue of a "0" return. The intended goal is to color a returned "0" to gray. There is no reason to color a null return which is what your code...
  17. Replies
    22
    Views
    1,217

    Re: Attemping to pull in lines from a DT

    That is perfect. I forgot about doing it that way... DOH!

    I did make a modification somewhat so my form did not crash on a NULL return for a state... Wondering if this is a solid way to get around...
  18. Replies
    22
    Views
    1,217

    Re: Attemping to pull in lines from a DT - RESOLVED

    I do have another question:

    Is there a quick and dirtly way to do the following as opposed to coding in every state text field?



    Private Sub StateColor()
    tbALMiles.ForeColor =...
  19. Replies
    22
    Views
    1,217

    Re: Attemping to pull in lines from a DT - RESOLVED

    I have resolved my issue by utilizing jmcilhinney's 3rd option. Thank you sir. :D:thumb: I literally just deleted near 1000 lines of code by utilizing that method which works flawlessly. Much...
  20. Replies
    22
    Views
    1,217

    Re: Attemping to pull in lines from a DT

    OK, I had originally created a SQL for each state. This worked fine, but was lengthy code requiring multiple open/closing of SQL connections, as you can imagine. What I was hoping to do is get the...
  21. Replies
    22
    Views
    1,217

    Attemping to pull in lines from a DT

    I am trying to populate 2 fields on a VB form based on a return of the SQL. The SQL brings back exactly what I want.
    I cannot get passed the 1st state before I get a Index out of bounds. I normally...
  22. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    Actually, this is exactly what I want... I need to continually update the values of the INVOICE_TOTAL and the WARRANTY_TOTAL of that record as long as I am in that record and an edit is made or...
  23. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    The message just above refers to this post... Sorry, thought I had done a quote.
  24. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    OK, in relation to the above.. This confuses me then...

    When I run the SQL in MSSMS it returns the 2 proper values side by side. I tried coding initially this way and this did not work...
  25. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    This is a solid suggestion and thus I shall indeed swap this over to a label. No user should be able to change this so your point is well taken.



    I've never tried a NUD control, but definitely...
  26. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    Actually the way I have it is correct.... There are 2 separate SQL statements put together by a UNION Each statement returns a single 'column' or value... thus result '0'
    As an added Caveat - I did...
  27. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    NO, if the specific value in a record is NULL assign it '0' - this prevents a null read / calc error exactly as si_the_geek notes. SQL I know, VB . not so much... LoL
  28. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    OK, adding a button with the code adjusted works perfectly - adds the value to the correct columns and even works and adds the total to the Warranty column. With that being resolved ((thanks for the...
  29. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    Sorry, I did not mean to assume I would not post my code but that I used your original example and it did not worked so I reverted back to my original. I will continue to work on this a bit now that...
  30. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    It is posted - 3 or 4 messages up.

    I tried the code change as submitted just above this message and thus I ended up with the concurrency violation. Nothing else has been changed other than what I...
  31. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    Couple of issues... I noticed you have 2 'stray' closing brackets '}' that needed to go. Secondly, after making that edit, testing, during save I immediately end up with "CONCURRENCY Violation: the...
  32. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    Just as a quick follow-up and request for corrections as required. I condensed my code just a tad.

    While still sitting as a private sub LostFocus, I will attempt to put this in a button click...
  33. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    :eek: Now you gone and done it.. reminding me of the outflow of cash after the new year... Thanks.... Just crashed my Christmas spirit for the remainder of the year!! ;)
  34. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    OK, so in a nutshell, you are also leaning towards using a button as well on the form to commit and run the SQL after all information is entered on that page. Am I on track here? Entry would be a...
  35. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    Yes saw Post 3 and addressed it.

    Have not tried a button simply for lack of real estate on the form. I may try to re-work the page design for that but not sure I'm gonna be able to free up enough...
  36. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    I did sort of a 'mapping' as it were and is as follows:

    GOAL: After inputting a value in a text box that value writes to the DB
    Once value is written, the value needs to be added to...
  37. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    I did notice that, and so mentioned it in a previous post... My reason for posting here initially was to learn exactly how to work around this. I am not a pro in this VB arena... I am looking for the...
  38. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    Ok, excuse me for trying to learn something only to get nothing but snide comments. I will look else wheres for people willing to teach rather than smash someone's request to learn or advise them...
  39. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    I get no errors per se.

    1. The SQL updates the field, but never adds it to the field I need it added to.
    2. As techgnome, so rudely made note of, textchanged event is not working as I hoped it...
  40. Replies
    42
    Views
    2,907

    VS 2019 Re: Trouble populating then updating a text box

    Ok, excuse me for trying to learn something only to get nothing but snide comments. I will look else wheres for people willing to teach rather than smash someone's request to learn or advise them...
Results 1 to 40 of 82
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width