I am guessing that you are only dealing with one table here, and when you wrote "table1" you meant "table", correct? In other words, "t1" and "t2" are the same tables.
First, mikeblas is right in that you need to make sure that id's are not the same as part of your Where statement.
Also, I...
The only way I know to do this is via Excel's DCount function. This requires a section on your spreadsheet with the same column titles as your data range. This section allows you to put in multiple criteria ranges allowing you to do what I think you're talking about.
I agree with the prior poster. Additionally, since you do not have the background in programming, you need some proxy to be able to judge good vs. mediocre programmers.
In addition to their portfolio, look at their attention to detail. Are they organized, do they communicate well to people...
AMD isn't just CPUs. I honestly believe that financially they have their head on straight. They appear to be focused based on latest articles I have read. I'll bet they do well in 2009.
Regarding what Wall Street thinks or doesn't think about a company is irrelevant. Wall Street is basically...
Another thing to consider is moisture. We've run into issues where the paper is left out in the air too long, gets a little humidity in it, and then it jams in the copier. We've tried numerous types of paper to address this issue. So, unwrapped paper sitting in a printing bin for an extended...
Sorry if this is entirely irrelevant, but have you looked in the bios? Is there any setting for this? We have laptops at work that people use along with LCD monitors, and the LCD monitor mirrors what is on the laptop's LCD.
I have done lots of stuff with emails via C++ and automation (COM). Pretty easy and lots of info on the web on it. Regarding using a off-the-shelf tool to do this, I am not knowledgeable enough to speak to that.
If you look at their website, you'll see it has one VGA, one DVI, 1 4-port USB hub. That's it. It uses the LG IPS panel (I believe, based on another thread, it's H-IPS) and it's half the price of the NEC. Count me in.
I just saw on ShopBlt (and one other site, I think TechDepot.com) that the 305W will be roughly $1000. If that's the case for H-IPS monitor, I'll go with that instead of the 265W. $1000 for that monitor would be a heck of a price - I can see Dell have fits over that.
I have looked and looked, tried everything, still no idea. I have messed around with about every Sound Mapper (I'm assuming that the utility you're speaking of) My output source is "Output digital audio source" on the Audio I/O tab under S/PDIF settings. I selected Digital PCM Output. Nothing...
Hey, question for anyone that has this motherboard. I completed a new build with this motherboard - so far I've been very happy. When I plug a RCA cable into the S/PDIF connector on the connector block on the back of the motherboard, I get no audio. (I'm using a Pronus Firebox). I do the same...
I would love to use COM or some other method to access functionality of the software I'm working with.
RImage uses MS Visual C++ for their code, and thus the libraries they build are from Visual C++. I have been using Borland's C++ Builder for years and can knock out projects really quickly...
I'm using both C++ Builder 6.0 & RAD Studio, along with Microsoft Visual Studio 2005. Does anyone know how to link MS lib's with C++ Builder / RAD Studio? My MS product produces a DLL + LIB file, and my C++ Builder project is an EXE that needs to link to the LIB for access to the DLL at compile...
I looked at Great Lakes, HP, & Belkin. I physically looked at the HP & Belkin in 24U and decided on the Belkin (nicer case for sure).
Great Lakes sure make a number of nice cases, I just haven't seen them up close (and shipping was too much since there was no local dealer).
I have seen wi-fi picture frames that pull from directories on computers. I don't know how to push pictures to these devices. Also, if using these picture frames to pull the same pictures (pull instead of push), you would need a way to sync them.
Not much help, but there you go.
Hey guys, question: is there a way to connect a cell phone or a PDA to an ethernet network? I know I can using wi-fi for those pda cell phones that have wi-fi capabilities.
Some phones have usb connections - can I plug a usb-to-ethernet device into the cell phone and access the network that...
I picked up 1 at Microcenter for $350 and received a $50 gift card (had to ask for it though) which I used on a WD Raptor X hard drive which listed for $160. Microcenter really seems to have their stuff together. It's the only place where I can ask questions and get knowledgeable answers (as...
This is by far the best price I've seen for any 150 gig Raptor drive, let alone the X version. It's on their website as well as in the store (which is where I picked it up tonight).
Hey guys. I have a 4U case and I've been looking at heat sinks / coolers / watercooling for this case. Gigabyte motherboard, Q9450 processor. Any sugggestions on a heat sink / fan for this guy?
Secondly, any recommendations on water cooling? I've looked at every external water cooling kit I...
I am using a Thecus N5200 and it runs fine. I have lots of audio on it and it works great (5 Western Digital 750's in it). I've been happy with it. The only issue I have is that with the system nearly full, the speed is isn't all that hot when writing (readying is fine). Other than that, it...
C++. But having said that, without a knowledge of what's going on under the hood (assembly) you will be limited in your understanding. I took a class numerous years ago on C++ from an instructor who did not know squat about assembly and this diminished his ability to apply C++ effectively (he...
I called TechOnWeb this morning (I have the retail version of the Q9450 on order with them). They said the ETA is Monday (3/31). Their price for the retail version is $359 with free shipping. That's a better price than what the OEM chips are selling for.
I just got off the phone with Dell and this monitor is delayed until May 23rd. Since it's been "6+ weeks to shipping", it may be longer than that.
On another note, the NEC LCD3090WQXI 30" LCD (which is still arriving at most places it appears, meaning not in stock yet) is $1860 at...
I looked at NewEgg and read the reviews. Someone mentions that they overclocked the Q9450 to 3.80 on air. 4.0 should be reachable with better cooling. That's pretty impressive based on the 8 clock multiplier. I wonder if the Q9550 would make it to 4.0 on air.
You can also use printf to print strings (or part of them) that are not null terminated if you know the length that you want to print. For instance, if I had a character string "str" that I wanted to print the first 4 characters of, I could have the following code: printf("%4.4s").
Thanks for the input guys. As one poster mentioned, Digital audio over coax would cover the 25 feet without any problems. So I'm going to run 20' of coax from my motherboard (which has a coax digital out) to a faceplate upstairs (through the wall), then from the RCA connector on the faceplate...
Given the choice, I would go with a Firewire microphone (if they make such things) or a firewire mixer + microphone of your choice, instead of USB. Firewire guarantees timely delivery of packets whereas USB does not. This is one of the reaons that most (nearly all) audio computer equipment is...
Is there a device that you could plug a CAT 5/6 cable in that would send the magic packet to a particular IP address (or even mac address)? I'm wanting to do this without using a computer and was wondering if there is a device to pull this off.
Thanks!
I looked at "Is this an option", which I'm assuming you're referring to a portable digital music player. No, it isn't because of the amount of audio. Nice idea though, thanks.
Honestly, it would be nice to run the digital audio the 25 feet, THEN convert it to analog for listening. I wonder if...
There is only one machine, and that's in the basement. I need to get the audio out of the computer (digital or analog) and run it 25 feet to my desk upstairs, and then listen to it.
Hey guys. Question: how can I listen to audio on my computer 25' away? I'm going to put my computer in the basement and my office is on the second floor. I'm running cables through the way and wonder how to handle the audio.
One way would be to take my Pronus Firebox, plug that into the...