Recent content by utahjzz98

I also want to add that I am aware of using Update [table name] Set [column name]=’[integer]’ where City = ‘chicago’, but due to the large number of rows, I don't want to have to manually update each ID separately.

I have a .csv file with several hundred million records that I have imported into a SQL Server table. In an attempt to normalize the data, I have created several sub tables that contain ID for several respective values contained in the main table. I am looking to update the values in the main...

Thanks, that did the trick!

I have a column that has values between 1-10 and I am attempting to use a nested IF statement to generate a value based on that number range. If the number is >= 8, it should be "1 - High", <= 3, it should be "3 - Low", and finally > 3 AND < 8 should be "2 - Medium". Here is what I am...

Thank you! For some reason, I thought pivot tables were only used for numbers and calculations. I didn't know it could be used like that.

I have a spreadsheet of data that I will attempt to partially replicate in a demonstration below. OK, Column A below is the main category and repeats over and over. Column B is always a unique value for whatever color, so Bob will never show up more than once in Red. However, Bob can be...

But if I make a property, then it will be visible outside the class correct? If it doesn't need to be accessible outside the class then I can just refer to it by it's name inside the local object instead of creating a property?

If you only reference member variables inside the object they are contained in, do you need to create properties for those member variables, or can you just reference them directly?

Greetings, I am trying to write a simple MadLib program and I am having trouble when it comes to displaying the data at the end of the program. It appears that it all crams together and the text is near unreadable. Am I doing something incorrectly? Thanks in advance. import javax.swing.*...

Thanks so much for the help! That fixed it.

I have a class with a constructor that accepts 5 args including 3 String data types. When I attempt to create a new object of that class and pass the constructor the String data types I receive the following error: "illegal start of type". I'm not sure what I am missing, any help would be...

I have a piece of code that iterates through the sent items folder in Outlook and sends an email back with information regarding those sent items. However, as I am iterating through those items I need to seperate them and get a count by day. I can't seem to wrap my head around how to do this...

I have been looking at using a reoccuring appointment item hat fires off at a certain time every day and then sending an email based on that event firing. Thus far I am unable to find the mehtod/event that is triggered when the appointment reminder pops up on a user's screen. I think I'm on...

Thanks for the suggestion. I have looked into the event model in VBA. I am still hitting a little bit of a road block trying to think of which event to use. I found the ItemSent event which is used after something is sent. However, I just need something to fire off at a particular time each...

I have a working VBA script that checks the sent items folder to see if there are items there from a specific date and then fires off an email to me with the status. However, I need this script to run automatically every day and I can't think of a way to do that. Any suggestions?