Search:

I did see this article prior to posting my original message but was unsure if that would even work. Especially when MS decides to force update Office 365 (and windows for that matter) and reset...

I have struggled to understand how to set my program to send email from a specified account in Outlook. I have multiple accounts and need to send email from a specific account so replies (if any are...

I'll be more specific.

I am setting this up to do a search of the correct table to pull a requested record. I cannot pre-load every record into a DV as that would take a considerable amount of...

@jmcilhinney Fine, I am doing it wrong. This I already know thus why the original post. How do I correctly do what I asked in my original posting? Your assuming and making flippant, opinion based...

I need a fluid TableAdapter, BindingSource and Dataset that will change based on the then current year so I or someone else is not forced to have to re-code the program each year.

I was hoping to...

It adds it to a DT.


This is exactly what I am attempting to do yet all my attempted 'solutions' have failed. I am not exactly sure where to turn the LoadForm (renamed to isLoading) to TRUE when...

This is the exception:

Event Type Moniker Event Time Duration Thread
Activated Historical Code Context Exception thrown: 'System.IndexOutOfRangeException' in System.Data.dll ("There is no row at...

I have a pretty extensive code and need a little guidance on one item:

All works well until I want to add a record by using the 'add record' button.
As soon as I do this I get a message 'there is...

Totally understand what your saying... !! :rolleyes: :D

Shaggy

Thank you for the additional information and will look to incorporate those ideas....

In relation to your negative tax in a state - this is for Truckers who have to pay fuel tax even if...

That resolved the issue. Many thanks Paul. Well done.

Sorry I am not very good at manipulating arrays... I'm still trying to figure all the nuances out!

Taking away allowcurrencysymbol brings back a 0.00 as the result. Again, it appears it is totally ignoring the negative values or assigning a 0 instead of the true negative value. Using the numbers...

The above, as sent, produced a '$0.00'

Added back into the new offer 'Globalization.NumberStyles.AllowCurrencySymbol' still came back with $641.91 i.e. still not using the negative numbers.

OK, Paul;

Your 2nd solution at least brings back a value. However the expected value should be -$371.01 and I am returning back +$641.91

There are many Negative numbers (sorry, should have...

Appreciate the quick response.

However your adjusted offering still results in a result of '0.00'.

Being arrays are a serious weakness for me, I do see the values in the array. What happens in...

I cannot get this piece of code to give me a sum - it is only returning '0.00.' :blush: Can someone please look at it and tell me where I am dropping the ball?

ALL items in the array have a value...

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...

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...

That tells me nothing in relation to what I am trying to accomplish. I understand what FormClosing does.

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...

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.

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...

Noted and that make complete and total sense to me. Conversion to label will be done this evening!

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...

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...

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...

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...

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...

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.

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'.
...

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...

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...

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...

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 =...

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...

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...

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...

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...

The message just above refers to this post... Sorry, thought I had done a quote.

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...