[CGUYS] Excel Pivot Tables

2010-01-20 Thread Jay Montero
Does anyone know how to get an Excel (2007) pivot table to accept a range as a criteria in a column heading? It will allow using a constant but I need it to allow a range of values as in 20 and 50. * ** List

Re: [CGUYS] Excel Pivot Tables

2010-01-20 Thread Jay Montero
Thanks for the help. Much obliged. On Jan 20, 2010, at 8:07 AM, Jay Montero wrote: Does anyone know how to get an Excel (2007) pivot table to accept a  range as a criteria in a column heading?  It will allow using a  constant but I need it to allow a range of values as in 20 and 50

[CGUYS] The Hallmark Virus

2009-02-11 Thread Jay Montero
Anyone have a fix for this Hallmark e-mail virus that's cropped up? Comes with a zipped attachment which some of my users have opened (okay, Lots of them did) and it rendered the Windows XP machine useless (don't even think it Tom). Also comes from Ikea, CocaCola, and others)

Re: [CGUYS] MB/CPU Bundle

2008-11-25 Thread Jay Montero
By the time you figure in the cost of the MB, CPU, new RAM, etc... you may be better off looking at Dell's outlet if not their brand new desktops. But if you want to do it yourself, I say go NewEgg. on Tue, 25 Nov 2008, Marcio V. Pinheiro wrote: Where is the best place for me to buy a

Re: [CGUYS] Any recommendations about PowerLine Ethernet

2008-11-19 Thread Jay Montero
I use a NetGear power ethernet adapter which works great for my needs but I don't know if you'd be happy transmitting video over it since mine tops out at around 22Mb per second. --- Tue, 18 Nov 2008, Chris Mollner wrote: I am considering using PowerLine Ethernet Adapters to connect my TV

Re: [CGUYS] Computer won't Boot

2008-10-05 Thread Jay Montero
Bad ram could do this too. Might try simply re-seating the module(s) --- Will a bad video card keep the computer from booting? It is an onboard video card. * ** List info, subscription management, list

Re: [CGUYS] Excel on Mapped Drive

2008-08-16 Thread Jay Montero
I was thinking along the same lines but you helped define it better. Thanks very much. I will check it out. --- On Fri, 8/15/08, John DeCarlo wrote: I had a problem with Windows and an often-accessed network share. Windows had cached information (you can see this in Explorer when you

[CGUYS] Excel on Mapped Drive

2008-08-15 Thread Jay Montero
I've got a bit of a puzzler with one user on a LAN for whom it takes 30 seconds to open a particular Excel file on a mapped drive. If I copy it onto her desktop, it opens in a flash. Her coworkers, with same PC specs have no problem. This is a Windows/Novell network setup. Any ideas?

[CGUYS] Vista Dual Booting Disaster

2008-08-11 Thread Jay Montero
I did a bad thing: I installed Linux on a new laptop running Vista. I had done this before with other versions of Windows no problem. Now Windows fails to start. It just sits at the blue screen. Repair mode does the same. Googling reveals what I should have done to create dual boot but my

[CGUYS] PC Speaker

2008-06-12 Thread Jay Montero
I have a particular app that plays some sounds through the PC speaker only. It is an app that uses a bar code scanner, if that helps. My problem is the PC speaker is not loud enough. That's why I need to play through regular speakers. on Wed, 11 Jun 2008, Brian Jones wrote: Not sure that I

[CGUYS] PC Speaker

2008-06-09 Thread Jay Montero
I have a need to have the sound going to the PC speaker on a Windows XP Gateway desktop play through the desktop speakers. Anyone know of a way to do this? * ** List info, subscription management, list rules,

[CGUYS] PC Speaker

2008-06-06 Thread Jay Montero
I thought I posted this earlier but did not see it. So forgive me if I have double posted. What I am looking to do is play the sounds that come from the PC speaker on a Windows XP Gateway desktop through the desktop speakers. I have looked in the BIOS and cannot find a setting there. TIA

Re: [CGUYS] Home print server problem

2008-05-01 Thread Jay Montero
You can either delete the port or select it when choosing a port for the network printer. I suggest deleting it and starting over. on Thu, 1 May 2008, Brian wrote: Here's a problem that I hope somebody can help me with: I have a D-Link DP-301U print server installed on my home network that

[CGUYS] Word Doc Spell Check

2008-02-27 Thread Jay Montero
Someone at work has a document which was created in Word and will not allow spell check to be run on it regardless of what computer we use. We are trying to figure out how to undo this feature. We are at a loss how the document got that way. Any ideas?

[CGUYS] .org sites

2008-02-04 Thread Jay Montero
I am wondering how one goes about getting a domain with a .org url. I am looking for one for a small non-profit volunteer group. * == QUICK LIST-COMMAND REFERENCE - Put the following commands in == * == the body of an

[CGUYS] WinXP Freezing

2008-02-02 Thread Jay Montero
I've got a Windows XP Pro computer which freezes when left idle. Any ideas why this should suddenly start happening? * == QUICK LIST-COMMAND REFERENCE - Put the following commands in == * == the body of an email send 'em

[CGUYS] USB Malfunction

2008-01-28 Thread Jay Montero
Can anyone tell me why on a Windows XP machine with a scanner, printer, and multi-card reader all on USB the printer loses connectivity from time to time? Also I noticed in Device Manager there are 4 USB controller though there are 6 USB ports. What is the relation?

Re: [CGUYS] COMPUTERGUYS-L Digest - 5 Jan 2008 - Special issue (#2008-25)

2008-01-06 Thread Jay Montero
I watch on my Samsung 42 DLP connected through a HDMI port. :-) on Sat, 5 Jan 2008, Tony B wrote: So do you have to watch this material through the 6200? Or the HD5000? Or is it easy to watch it all over the house? *

Re: [CGUYS] Building Your Own TIVO

2008-01-06 Thread Jay Montero
I think I ended up spending around $300. I bought a lot of stuff on eBay and got great deals such as the case cost me nothing after rebates from NewEgg. I think the hard drive was a left over from a previous machine. on Sun, 6 Jan 2008, Site Guy wrote: What is the cost so far?

[CGUYS] Building Your Own TIVO

2008-01-05 Thread Jay Montero
Here's what I've got working. Note that for recording less than HDTV, you can get by with way less hardware in terms of CPU and video card. My MythDora 4 System: Biostar NF325-A7 754 NVIDIA nForce3 250 ATX AMD Motherboard AMD Athlon 64 3200+ Venice 2.2GHz 512KB L2 Cache Socket 754 Processor

Re: [CGUYS] Just a silly observation: future???

2008-01-04 Thread Jay Montero
I think I heard a while back that eventually HDTV will be broadcast over the current VHF channels when there is no longer a need to use them for the analog programming. on Fri, 4 Jan 2008, John Duncan Yoyo wrote: This is the FCC's take on the rules. http://www.fcc.gov/mb/facts/otard.html They

[CGUYS] Laptop Wireless Connection

2008-01-03 Thread Jay Montero
My daughter's new HP laptop with Vista works fine except when it goes to sleep it disconnects from the wireless router. She can reconnect manually no problem. But is there any way to reconnect automatically (or better yet stay connected)?

Re: [CGUYS] ATT DSL ok? Update

2007-12-13 Thread Jay Montero
I had a similar situation and I was able to put the DSL modem into bridge mode and bypass its router/firewall functions entirely. Of course, I had my own router/firewall I used in its place. Finding out how to get the modem into bridge mode did take some research. on Wed, 12 Dec, Paula

[CGUYS] Small Company VoIP

2007-11-02 Thread Jay Montero
It looks like my little company is going to have to go out and get a T1 line. Given that, I am looking at going with VoIP to save on telephone costs. Currently, we have a PBX (Vertical Networks Instant Office) which I would love to just connect to the T1. Does anyone on this list have

Re: [CGUYS] BroadBand Speeds

2007-10-24 Thread Jay Montero
wrote: By definition a T1 is only 1.5. If it was more, it wouldn't be a T1. Mike On 10/23/07, Jay Montero [EMAIL PROTECTED] wrote: I am curious why in this day age T1 lines max out at 1.5Mbps while DSL and cable speeds are many times faster

[CGUYS] BroadBand Speeds

2007-10-23 Thread Jay Montero
I am curious why in this day age T1 lines max out at 1.5Mbps while DSL and cable speeds are many times faster. * == QUICK LIST-COMMAND REFERENCE - Put the following commands in == * == the body of an email send 'em to:

[CGUYS] ISO Recommendation: LCD Monitor

2007-10-01 Thread Jay Montero
What do you folks recommend for a LCD monitor that will be used for CAD drawings (SolidWorks) and such? What specs should I be looking for? TIA * == QUICK LIST-COMMAND REFERENCE - Put the following commands in == * ==

Re: [CGUYS] controlling IP address access

2007-09-21 Thread Jay Montero
Years ago, when my kids were younger, I too needed a way to control their surfing online. What I did was I built my own firewall using an older unused computer and a free Linux software product called Smoothwall. I have since moved on to a similar product called IPCop. Whichever you choose,

[CGUYS] Very Entertaining Dell Computer

2007-07-24 Thread Jay Montero
A while back, I posted a problem I was having with a Dell computer who's fan sounded like a jet engine. I discovered this particular computer, running Windows XP Pro, was very temperature sensitive and when the office A/C got fixed, the problem went away. However, now it seems it is acting

Re: [CGUYS] Very Entertaining Dell Computer

2007-07-24 Thread Jay Montero
If only this Dell (Dimension 3000) played nice with SpeedFan. But I tried that nifty piece of software and it does not see the fan on this model computer. on Tue, 24 Jul, Rev. Stewart Marshall wrote: You might want to check your BIOS and see what the set point is for overtemp. Also download

[CGUYS] Firefox Freeze-Ups Update

2007-07-23 Thread Jay Montero
I wrote a few days back about a problem with my beloved Firefox freezing on me when I clicked on bookmarks. Here's an update:. Based on what I was reading from the list members, I deleted many of my bookmarks. I too many I guess, some of which were no longer useful or even valid. Now

[CGUYS] Firefox Freezes

2007-07-19 Thread Jay Montero
What has happened to Mozilla Firefox? I run it on several machines including a Linux box and on every one (running the latest version with no add-ons) the browser freezes when I click on bookmarks. It takes a good part of a minute for the bookmarks to present themselves. This has been

[CGUYS] Firefox Freezes

2007-07-19 Thread Jay Montero
The version that freezes on me is the most current. The last two or three versions exhibited the same issue. Someone contacted me off-list and recommended SeaMonkey. I'll give that a whirl and see if I can live without my old favorite Firefox.

Re: [CGUYS] Who's In?

2007-07-15 Thread Jay Montero
Thanks again Tom. That product looks good. on Saturday the 14th, Tom Piwowar wrote: www.glassbead.com/inoutboard/ $12 per seat or less peer to peer so requires no server cross platform demo available Before the Internet I used to use their peer-to-peer SnapMail system for intra-office email.

[CGUYS] Who's In?

2007-07-13 Thread Jay Montero
I need some help from the group. My office just moved its offices and the new layout is bigger (yay!) than the previous one. In the old place, we had a board with everyone's name on it with magnets which we would place to show whether we were in or out and if out when we would return. Low

Re: [CGUYS] Who's In?

2007-07-13 Thread Jay Montero
I will look into that. Thank you. on Fridaty the 13th, mike wrote: Would rendevous application work? * == QUICK LIST-COMMAND REFERENCE - Put the following commands in == * == the body of an email send 'em to: [EMAIL

Re: [CGUYS] SQL and VPN

2007-06-28 Thread Jay Montero
To use terminal server, I think I need to dedicate a box, is that right? Or is it just another app I could run? on Wed, 27 Jun 2007, Jeff Wright wrote: Why not just terminal into the server? * == QUICK LIST-COMMAND

[CGUYS] SQL and VPN

2007-06-27 Thread Jay Montero
Does anyone know how I can connect to a remote SQL server (2000) over a VPN connection? I am testing Hamachi but the connection is too slow to be of any use. * == QUICK LIST-COMMAND REFERENCE - Put the following

Re: [CGUYS] Printing Across the Web

2007-06-24 Thread Jay Montero
E-mailing is our Plan B. But for now it looks like Hamachi will do the trick for us. It is a free east-to-use VPN solution. Thanks for all the replies. on Sat, 23 Jun 2007, John McDonald wrote: I think you might find this an easy and virtually free way to accomplish printing to a remote

[CGUYS] CPU Exhaust Fan Running In Super Fast Mode

2007-05-29 Thread Jay Montero
What does it mean when the fan on a Dell Dimension 3000 starts running at very high speed about a minute after boot-up and stays there? The system is less than two years old and it runs Windows XP. * == QUICK

[CGUYS] Shhh...

2007-05-03 Thread Jay Montero
I am looking for advice on making my PC a little quieter. I gather I need to look at replacing my case fan and power supply...? What do you recommend that you have actually tried? (It's a Linux box in case that makes any difference.) TIA

[CGUYS] HDTV PC Project

2007-04-24 Thread Jay Montero
I am tackling a new project: I am looking to convert a PC of mine running Linux into a PVR for recording HDTV while connected to a rooftop antenna. I already have a HDTV connected to this antenna and all works well. I have decided on my video card and ASTC card but am confused what to do