Search results for query: *

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?

That did it! Thank you.

I am really new to Crystal so this may be an easy question but I am having trouble with a record selection formula. Everthing works fine except where I attempt to narrow 'LOOKUP2' down by 'Help Desk'. It continues to return other records including blank ones. When I have removed the OR...

Thanks for the suggestion CosmicCharlie. I found a good deal for that book online and have placed my order. It seems like a good place to start for what I am looking to accomplish. I also liked how you said "It helped me go from a coder to an application architect". That is what I was...

Thanks all for the suggestions, I will take a look at those articles and hopefully they will help. Thanks again.

I have been attempting to learn programming for a few weeks now but I am having some difficulty and was hoping for suggestions. I have no problem learning the syntax of the programming languages. My problem is applying that knoweledge and building a real world application. The books that I...