RE: [SPAM SUSPECT] [H] MS Access question
Brian, My first inclination would be to build a lookup table that has the value and its related value and then link to that table in your query. SomeTable OldValueNewValue A1 January A2 February ... The other thing you could do would be to use the switch statement, either on the report or in the query: =Switch(FieldName=A1,January,FieldName=A2,February,...) I think the 1st option is the most appropriate here. As for the sum part, I am not clear on exactly what you are wanting. Are you saying? A1 A1 A3 A2 A1 A3 count of a1=3 count of a2=1 count of a3=2 If so, I am not sure how to do that. Bobby -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Weeden Sent: Monday, November 06, 2006 6:51 PM To: hwg Subject: [SPAM SUSPECT] [H] MS Access question Importance: Low It's been a long while since I did any work with Access and I ran across a problem today. I have a database where the end column is an alphanumeric code. I want to generate a report that substitutes in a certain value in the report instead of the actual DB value without changing the value. For example, if the DB shows A1 I want it to show Jan and if A2 Feb. I would also like the report to do counts for me, like if A1 appears 6 times in a column to display the total number. I know it is possible but can't quite figure it out. -- Brian
Re: [SPAM SUSPECT] [H] MS Access question
What I was looking for with the counting was if there were 10 A1s in that field in the entire database, I wanted it to show the number. Thanks for the suggestion, I will try it out today. On 11/7/06, Bobby Heid [EMAIL PROTECTED] wrote: Brian, My first inclination would be to build a lookup table that has the value and its related value and then link to that table in your query. SomeTable OldValueNewValue A1 January A2 February ... The other thing you could do would be to use the switch statement, either on the report or in the query: =Switch(FieldName=A1,January,FieldName=A2,February,...) I think the 1st option is the most appropriate here. As for the sum part, I am not clear on exactly what you are wanting. Are you saying? A1 A1 A3 A2 A1 A3 count of a1=3 count of a2=1 count of a3=2 If so, I am not sure how to do that. Bobby -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Weeden Sent: Monday, November 06, 2006 6:51 PM To: hwg Subject: [SPAM SUSPECT] [H] MS Access question Importance: Low It's been a long while since I did any work with Access and I ran across a problem today. I have a database where the end column is an alphanumeric code. I want to generate a report that substitutes in a certain value in the report instead of the actual DB value without changing the value. For example, if the DB shows A1 I want it to show Jan and if A2 Feb. I would also like the report to do counts for me, like if A1 appears 6 times in a column to display the total number. I know it is possible but can't quite figure it out. -- Brian -- Brian
RE: [H] TV Card Software
I still haven't decided on software to use...I'm currently running the Beyond TV trial, using a DVICO FusionHDTV5 Gold tuner and a VBox Cat's Eye 150 HDTV tuner. Anyone have experience with BTV, Sage, and GBPVR that provide some qualitative comments? Greg -Original Message- From: [EMAIL PROTECTED] [mailto:hardware- [EMAIL PROTECTED] On Behalf Of Wayne Johnson Sent: Monday, November 06, 2006 11:30 PM To: The Hardware List Subject: Re: [H] TV Card Software At 11:33 PM 11/6/2006, lopaka typed: I'm not sure if any of these support that specific card. I use GBPVR with hauppauge cards (2 PVR250's and 1 PVR550 dual tuner), and a sapphire theater 550 card. I love it. GBPVR has a built in webserver so you can access from any web browser to search TV listings and schedule recordings. I use TitanTV.com from any web browser any computer to record with the MyHD card that I have in my HTPC. ---+-- I'm a geek that loves to tweak.
Re: [H] TV Card Software
I've had problems with SageTV on a few boxes with infrequent lockups during recording. I haven't had any problems with GBPVR on the same machines and I also use it to serve video to 2 MediaMVPs for watching live TV and recorded shows. I've also had SageTV mess up the TV lineups when provided the correct cable provider info intermittently. GBPVR works better with my hardware and is free ;) lopaka Greg Sevart wrote: I still haven't decided on software to use...I'm currently running the Beyond TV trial, using a DVICO FusionHDTV5 Gold tuner and a VBox Cat's Eye 150 HDTV tuner. Anyone have experience with BTV, Sage, and GBPVR that provide some qualitative comments? Greg -Original Message- From: [EMAIL PROTECTED] [mailto:hardware- [EMAIL PROTECTED] On Behalf Of Wayne Johnson Sent: Monday, November 06, 2006 11:30 PM To: The Hardware List Subject: Re: [H] TV Card Software At 11:33 PM 11/6/2006, lopaka typed: I'm not sure if any of these support that specific card. I use GBPVR with hauppauge cards (2 PVR250's and 1 PVR550 dual tuner), and a sapphire theater 550 card. I love it. GBPVR has a built in webserver so you can access from any web browser to search TV listings and schedule recordings. I use TitanTV.com from any web browser any computer to record with the MyHD card that I have in my HTPC. ---+-- I'm a geek that loves to tweak.
Re: [H] TV Card Software
Hows the vbox cats eye working for you? I almost got one of those some time back. I've been using a Aver MCE180 for HDTV that I got for cheap. lopaka Greg Sevart wrote: I still haven't decided on software to use...I'm currently running the Beyond TV trial, using a DVICO FusionHDTV5 Gold tuner and a VBox Cat's Eye 150 HDTV tuner. Anyone have experience with BTV, Sage, and GBPVR that provide some qualitative comments? Greg -Original Message- From: [EMAIL PROTECTED] [mailto:hardware- [EMAIL PROTECTED] On Behalf Of Wayne Johnson Sent: Monday, November 06, 2006 11:30 PM To: The Hardware List Subject: Re: [H] TV Card Software At 11:33 PM 11/6/2006, lopaka typed: I'm not sure if any of these support that specific card. I use GBPVR with hauppauge cards (2 PVR250's and 1 PVR550 dual tuner), and a sapphire theater 550 card. I love it. GBPVR has a built in webserver so you can access from any web browser to search TV listings and schedule recordings. I use TitanTV.com from any web browser any computer to record with the MyHD card that I have in my HTPC. ---+-- I'm a geek that loves to tweak.
RE: [H] XP Pro/Home shared printer...
The enabling of the guest account did the trick. Thanks! Bobby -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bobby Heid Sent: Monday, November 06, 2006 10:12 AM To: 'The Hardware List' Subject: RE: [H] XP Pro/Home shared printer... Hi Harry, I did the permissions on the printer. What else will that open me up to if I enable the guest account? Thanks, Bobby -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Harry McGregor Sent: Monday, November 06, 2006 9:56 AM To: The Hardware List Subject: Re: [H] XP Pro/Home shared printer... Options: Enable the guest account on the XP Pro box Set perms on the printer to give Everyone access to it. Harry Bobby Heid wrote: Hey all, I have an XP Pro box with a shared printer on it. I can install the printer on the Home boxes in which it requires a logon/password. So I give it the administrator login and pw. I can then print to the printer form the Home box. But, if I reboot the Home machines, they can no longer print to the printer. What am I doing wrong? Any advice? Thanks, Bobby
RE: [H] TV Card Software
I've been running SageTV on a AMD XP 2500+ based system 24/7 for over 2 years and have no complaints. It integrates with the Hauppauge products I own without a problem. I run a PVR500 dual tuner and two USB2 PVRs allowing me to record 4 programs simultaneously. The quality of my cable signal is not the best, but at the long play DVD quality setting, the recordings are quite good, vastly better than the VCRs they replaced. I don't have HDTV signal or monitor, so no comments but I believe SageTV has or will be offering support. Overall, I couldn't be happier. I purchased version 2.0 in 2004 and have received free version updates ever since. Current version is 5.0. It has an active forum with lots of suggestions and helpful people. I basically have accepted all the default parameters and am satified with the results. My understanding is that there is lots to tweak under the hood if so desired. I have never had a problem with the system freezing or not recording, unless it was a guide problem. I love that this one system replaces 4 old VHS VCRs, schedules the recordings for me, stores the recordings in far less room, and allows me to edit and archive any shows I wish. NO REGRETS. As always, JMO and YMMV. Jim Maki [EMAIL PROTECTED] -Original Message- From: Greg Sevart I still haven't decided on software to use...I'm currently running the Beyond TV trial, using a DVICO FusionHDTV5 Gold tuner and a VBox Cat's Eye 150 HDTV tuner. Anyone have experience with BTV, Sage, and GBPVR that provide some qualitative comments? Greg
RE: [H] TV Card Software
I haven't had a chance to play with it too much yet. I installed XP x64 on the HTPC box first since all of my hardware was supported, but the DVICO FusionHDTV 5's 64bit driver had some quirks. I just recently installed XP x32, and finally got BTV installed last night. I have the more expensive DVICO card set up as the primary card, so all of the live TV I've watched on the box has been on that card. The tuner may be a little less sensitive (a bad thing) than the Fusion, though. But for $50 at Microcenter, who can complain? On a side note, any suggestions for a good inside VHF antenna? I get 100% (30dB or higher) signal on all my UHF channels, but ABC here is broadcast on VHF. I was getting about 65% (19dB or so) on that channel using a Terk HDTVi...which I got up to ~83% (22-23dB) by means of some goofy looking aluminum foil. Greg -Original Message- From: [EMAIL PROTECTED] [mailto:hardware- [EMAIL PROTECTED] On Behalf Of lopaka Sent: Tuesday, November 07, 2006 8:16 AM To: The Hardware List Subject: Re: [H] TV Card Software Hows the vbox cats eye working for you? I almost got one of those some time back. I've been using a Aver MCE180 for HDTV that I got for cheap. lopaka Greg Sevart wrote: I still haven't decided on software to use...I'm currently running the Beyond TV trial, using a DVICO FusionHDTV5 Gold tuner and a VBox Cat's Eye 150 HDTV tuner. Anyone have experience with BTV, Sage, and GBPVR that provide some qualitative comments? Greg -Original Message- From: [EMAIL PROTECTED] [mailto:hardware- [EMAIL PROTECTED] On Behalf Of Wayne Johnson Sent: Monday, November 06, 2006 11:30 PM To: The Hardware List Subject: Re: [H] TV Card Software At 11:33 PM 11/6/2006, lopaka typed: I'm not sure if any of these support that specific card. I use GBPVR with hauppauge cards (2 PVR250's and 1 PVR550 dual tuner), and a sapphire theater 550 card. I love it. GBPVR has a built in webserver so you can access from any web browser to search TV listings and schedule recordings. I use TitanTV.com from any web browser any computer to record with the MyHD card that I have in my HTPC. ---+-- I'm a geek that loves to tweak.
Re: [H] Greasemonkey help
Could it be you have NoScript installed the .js you're installing from is local so therefore you need to enable scripts for file:// (hopefully only temporally)? Brian Weeden wrote: For those of you using Firefox, have you tried the Greasemonkey extension? Everyone raves about it but I am having problems getting it to work. It is an extension that allows you to load little snippets of javascript on your end to run on pages that you want. For example, you can install a little JS script that allows you to right-click on any Youtube video and save it to your hard drive. Another script merges Gmail and Google Messenger together on the same page. Another can be used to insert isohunt links to moves on their IMDB pages :) Anyways, I installed the extension and then tried to install a script. I clicked the .js file of the script and got a little install/about/cancel window. But clicking on the install button does nothing, it just sits there. Any ideas? Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. http://new.mail.yahoo.com
[H] Can't get in BIOS
Can anyone suggest I reason I can't get into the BIOS? I have a Gigabyte GA-SinXP1394 mobo. Manual says to press DEL immedicately after Powering on. I do that, but I still just end up in Windows, every time. I want to turn off onboard audio has I now have a SB X-Fi in there. It seems as if the keyboard isn't recognized at boot. Argh!
Re: [H] Can't get in BIOS
USB keyboard ? if so plug in a hardwired one. fp At 04:03 PM 11/7/2006, Anthony Q. Martin Poked the stick with: Can anyone suggest I reason I can't get into the BIOS? I have a Gigabyte GA-SinXP1394 mobo. Manual says to press DEL immedicately after Powering on. I do that, but I still just end up in Windows, every time. I want to turn off onboard audio has I now have a SB X-Fi in there. It seems as if the keyboard isn't recognized at boot. Argh! -- Tallyho ! ]:8) Taglines below ! -- Repunzel, Repunzel, ... turn on your modem.
Re: [H] Can't get in BIOS
I tried that! I was using a USB keyboard so I just figured the damn thing couldnt see it during boot. So, I plugged in a old kb with a PS2 connected and had a go at that. No go. Even worse, windows didn't see the PS2 keyboard. Well, it saw it but would not load a driver for it. So I had no kb inside windows either. Luckily, in windows one can do a lot with just a mouse. I've been goofing with this most of the day. I'm thinking about dumping all of these WinPCs and moving to one MAC (well, two, desktop / laptop). Wayne Johnson wrote: At 06:03 PM 11/7/2006, Anthony Q. Martin typed: It seems as if the keyboard isn't recognized at boot. Is the keyboard USB ? Try a USB to PS2 adapter if the system has a PS2 port or if you can find an old PS2 keyboard but I have seen this happen before. ---+-- I'm a geek that loves to tweak.
[H] Two Sound Cards?
There really should be no problem with this, right? Right now, i have both on board sound enabled with drivers installed in windows, and the SB X-Fi loaded with drivers installed. Sound seems to be working, though I only care to listen to one.
Re: [H] Two Sound Cards?
From what I understand, installing the X-Fi overrides any onboard sound. Apparently Vista will allow you to choose between sound card and onboard. - Original Message - From: Anthony Q. Martin [EMAIL PROTECTED] To: The Hardware List hardware@hardwaregroup.com Sent: Tuesday, November 07, 2006 3:34 PM Subject: [H] Two Sound Cards? There really should be no problem with this, right? Right now, i have both on board sound enabled with drivers installed in windows, and the SB X-Fi loaded with drivers installed. Sound seems to be working, though I only care to listen to one.
Re: [H] Two Sound Cards?
Well, both of them show up in XP in control panel. I haven't tried to use both at the same time, so I guess a signal going out has to go to one or the other and not both, so you may well have a point. I'd just prefer not to have software loaded for both. That don't seem right. Veech wrote: From what I understand, installing the X-Fi overrides any onboard sound. Apparently Vista will allow you to choose between sound card and onboard. - Original Message - From: Anthony Q. Martin [EMAIL PROTECTED] To: The Hardware List hardware@hardwaregroup.com Sent: Tuesday, November 07, 2006 3:34 PM Subject: [H] Two Sound Cards? There really should be no problem with this, right? Right now, i have both on board sound enabled with drivers installed in windows, and the SB X-Fi loaded with drivers installed. Sound seems to be working, though I only care to listen to one.
Re: [H] Can't get in BIOS
Right...but it's a damn PC! :) Win should let you at the bios, too! :) Wayne Johnson wrote: At 06:33 PM 11/7/2006, Anthony Q. Martin typed: I've been goofing with this most of the day. I'm thinking about dumping all of these WinPCs and moving to one MAC (well, two, desktop / laptop). Windows should have nothing to do with whether you can get into your bios or not. ---+-- I'm a geek that loves to tweak.
Re: [SPAM SUSPECT] [H] MS Access question
At 09:31 AM 07/11/2006, Brian Weeden wrote: What I was looking for with the counting was if there were 10 A1s in that field in the entire database, I wanted it to show the number. SELECT Count(FieldName) FROM TableName WHERE (((FieldName)='A1')); T
Re: [H] MS Access question
At 07:50 PM 06/11/2006, Brian Weeden wrote: It's been a long while since I did any work with Access and I ran across a problem today. I have a database where the end column is an alphanumeric code. I want to generate a report that substitutes in a certain value in the report instead of the actual DB value without changing the value. For example, if the DB shows A1 I want it to show Jan and if A2 Feb. I'd do as Bobby said and create a second table with two fields: MonthID Month Name A1 Jan A2 Feb etc etc Then I'd create a relationship and pull the data across that way. T
Re: [H] Two Sound Cards?
At 07:34 PM 07/11/2006, Anthony Q. Martin wrote: There really should be no problem with this, right? Right now, i have both on board sound enabled with drivers installed in windows, and the SB X-Fi loaded with drivers installed. Sound seems to be working, though I only care to listen to one. Should work fine. I've done this before (not with that card though.) T
Re: [H] Can't get in BIOS
At 07:33 PM 07/11/2006, Anthony Q. Martin wrote: I tried that! I was using a USB keyboard so I just figured the damn thing couldnt see it during boot. So, I plugged in a old kb with a PS2 connected and had a go at that. No go. Even worse, windows didn't see the PS2 keyboard. Well, it saw it but would not load a driver for it. So I had no kb inside windows either. Luckily, in windows one can do a lot with just a mouse. If Windows isn't seeing the PS2 keyboard, then it sounds to me like you have a PS2 port problem - it's not in the wrong port is it? No bent pins? I've been goofing with this most of the day. I'm thinking about dumping all of these WinPCs and moving to one MAC (well, two, desktop / laptop). Because of a BIOS problem? I would assume the Intel-based Macs also use a BIOS which would be very similar to an AMD/Intel Windows box. T
Re: [H] MS Access question
That's what I did to solve the first problem. Thanks guys. On 11/7/06, Thane Sherrington [EMAIL PROTECTED] wrote: At 07:50 PM 06/11/2006, Brian Weeden wrote: It's been a long while since I did any work with Access and I ran across a problem today. I have a database where the end column is an alphanumeric code. I want to generate a report that substitutes in a certain value in the report instead of the actual DB value without changing the value. For example, if the DB shows A1 I want it to show Jan and if A2 Feb. I'd do as Bobby said and create a second table with two fields: MonthID Month Name A1 Jan A2 Feb etc etc Then I'd create a relationship and pull the data across that way. T -- Brian
Re: [H] Can't get in BIOS
At 08:14 PM 07/11/2006, Anthony Q. Martin wrote: Right...but it's a damn PC! :) Win should let you at the bios, too! :) There might be a utility to do this - one can flash the BIOS from inside Windows (ugh!) so it should be possible to edit it. Some of the FSB modifiers even do it on the fly. T
Re: [H] Can't get in BIOS
Thane Sherrington wrote: At 07:33 PM 07/11/2006, Anthony Q. Martin wrote: I tried that! I was using a USB keyboard so I just figured the damn thing couldnt see it during boot. So, I plugged in a old kb with a PS2 connected and had a go at that. No go. Even worse, windows didn't see the PS2 keyboard. Well, it saw it but would not load a driver for it. So I had no kb inside windows either. Luckily, in windows one can do a lot with just a mouse. If Windows isn't seeing the PS2 keyboard, then it sounds to me like you have a PS2 port problem - it's not in the wrong port is it? No bent pins? Well, it has a problem with the PS2 keyboard, not that it didn't see it. I'm sure I had the right port. I've been goofing with this most of the day. I'm thinking about dumping all of these WinPCs and moving to one MAC (well, two, desktop / laptop). Because of a BIOS problem? I would assume the Intel-based Macs also use a BIOS which would be very similar to an AMD/Intel Windows box. Not really. I'm just frustrated with all my systems going bonkers...this and that not working, needing to reformat/reloadwhen you have 1, 2, 3, 4, 5, 6 computers.
Re: [H] Two Sound Cards?
Thane Sherrington wrote: At 07:34 PM 07/11/2006, Anthony Q. Martin wrote: There really should be no problem with this, right? Right now, i have both on board sound enabled with drivers installed in windows, and the SB X-Fi loaded with drivers installed. Sound seems to be working, though I only care to listen to one. Should work fine. I've done this before (not with that card though.) It does seem to work fine, though I have a control center app loading for one that seems useless. I guess I could disable the device in control panel.
Re: [H] Can't get in BIOS
On 11/7/06, Thane Sherrington [EMAIL PROTECTED] wrote: ... Because of a BIOS problem? I would assume the Intel-based Macs also use a BIOS which would be very similar to an AMD/Intel Windows box. The Intel Macs have something called EFI. I don't know how to get into the settings on my Macbook, if it's even possible, but have never needed to either, and can't think of why I would need to given the various boot time shortcut keys they have. http://en.wikipedia.org/wiki/Extensible_Firmware_Interface So far I've reformatted my Mac once, to be sure I was rid of the crap Microsoft eval software that put parts of itself all over the HD (like Windows!), to use the case sensitive filesystem, and also just to see what was involved with the process.
[H] Re: RAID 5 upgrade planning
So is my plan of upgrading the drives one at a time to a larger capacity and then upping the RAID size sound? I really don't want to lose my data that I can't backup. Of course, my only other option would be to buy another RAID controller, all new drives, build a new RAID, then port all the data over. I don't think my power supply could handle that :) On 11/4/06, Brian Weeden [EMAIL PROTECTED] wrote: When I built my HTPC a year ago I used a MegaRAID controller and 5 250GB SATA drives. This gave me a RAID 5 array with about 1.1 TB usable. Things have been working quite well, except that I am down to my last 100GB of free space. I was doing some calculations trying to figure out how much storage I would need. I have 400 DVDs that I own. If I were to store each one as a Xvid file in addition to the ~5000 TV shows, music, photos, and ebooks I would need around 3TB of space. If I were to store them in vob form that number jumps to around 6.7 TB. Using 750GB drives, 6 in a RAID 5 gives about 4.5 TB total and 3.8 TB of usable space. Good enough for xvid, but not for vobs. Even if I waited for the 1TB drives in the spring I wouldn't be able to get enough space out of a 6-drive array (now that's scary). So I guess my only option for now (is to stick with the xvid solution. It works fine (AutoGK does a wonderful job) but every once in a while you get an xvid with offset audio and it's a pain to line it up properly. So with that figured out, next I need to figure out the best way to upgrade the RAID in terms of cost and time. It is my understanding that the size of each element in the array is only as big as the size of its smallest member. So if I start replacing the 250GB drives with 750GB ones, I should be able to do that without too much disruption to the array other than the time needed to rebuild it after I swap each drive. Then, once I have all 6 swapped out I should be able to increase the size of the array, correct? I don't really have the ability to backup the full 1TB of data on some other device which is what's causing the problem. The only thing I know of that can handle that much data is a tape drive and that is several hundred dollars I would like not to spend. Anything I've forgotten? -- Brian -- Brian
