Search results for query: *

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

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

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

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

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

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

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

Greetings, I am fairly new at DB design and I am having difficulty grasping how to create relationships between my tables. Please see my tables below. ---------------------------------- | CUSTOMER TABLE | +---------------|-------|--------+ Customer_ID |INT |PRIM Key|...

I just purchased a new motherboard model M811. When I try to boot up I can see that it recognizes my processor, RAM, and video card, but it is not reading any of my IDE devives. This includes the HD, CD-ROM, CD burner, and floppy drive. I have heard suggestions of flashing the BIOS but I...

I have a program that goes through an Outlook folder and counts all of the email items in that folder and seperates it by date. However, I am running into type mismatch error if the program runs across a meeting request or any other object in the folder that's not a mail item. I tried using...

I created a user form in Outlook using VBA and now I am looking to distribute this form to a couple different users. Unfortunately, I unable to find any documentation for how to accomplish this in Outlook. Can anybody enlighten me? Thanks, Corey

Hello, I am trying to count the number of emails in a particular Outlook folder. However, I need the results returned to me by DAY. For example, if there are 3 emails total in the folder I need to know that 1 email is for 01/17/05 and 2 are for 1/23/05. I am able to get a count for the...

I have a .txt that has tab delimited values and I need to parse this data and add it to a table in an Access database. I can't think of an efficent way of doing this. I have tried using string manipulation functions to parse all the data out serpately, but that is not working the way I had...

Greetings, I have an .asp page where I connect to a Access database on the back end. It's a pretty basic login page, that post back to itself and allows the admin to save information to the db as well. My problem is this...I can use the admin page once and save data to the db just fine...

I am attempting to use the SQL update command in an .asp page connected to an Access db. Regardless of whether I try to use the SQL update command in the .asp page, or an update query in Access, it is not updating any data. When I run the query in Access I get the message, &quot;You are about...

I need to create a program that will allow a user to export information from an excel spreadsheet and load that info into an Access table. The program uses Access forms for the front-end and Access back-end. I am vaguely familiar with VBA, but I am not sure how to begin this project. Any...

Is there a way to play a .wav file for the duration of a slide show, without having to alter something for every single slide? For example, I am creating a photo album and I would like to play a song while the pictures are displaying. I have around 50 slides and I would like the song to play...