Search results

  1. V

    Messing with the MIS department

    So the MIS department likes to uninstall FF from people's computers and monitor who is visiting the web using it, I'd like to write a small app that will make IE appear as FireFox when visiting websites - not too the websites, but to our MIS department. Anyone have any ideas? If you need...
  2. V

    Getting Started with Java

    edit
  3. V

    SQL Query - creating procedures & using variables: SOLVED

    This will be the first procedure I have ever written but pretty much this is what I need to do: Query against a date dimension table to return the current fiscal year Then create 8 additional variables which will use the current fiscal year variable to determine the start and end dates of...
  4. V

    Excel VBA Insert Date if Worksheet Changes

    Mind is completely mush at this point today... I have a worksheet that people constantly update, every time an update is made, I'd like the date and time to appear in field A1. Easiest way to do this would be?
  5. V

    Westinghouse 26-inch Widescreen 1080P LCD Monitor-Black $259

    http://www.buy.com/prod/westin...loc/101/207540840.html
  6. V

    MS Access - Select Query and Updating Data

    In Excel, I created a table of rows I needed to update, I imported this table into access as Sheet1. Then I created this select query to produce an easily updated view of the data: SELECT RawFinancials.* FROM RawFinancials INNER JOIN Sheet1 ON RawFinancials.Prj = Sheet1.Prj; The...
  7. V

    MS Access Delete Query

    Here is an example of what I'm trying to do: I have two tables: Table A Col 1: ID Col 2: Desc Col 3: Financials Table B Col 1: ID Table B contains a subset from Table A. I want to delete all rows in Table A that have ID's in Table B. Thanks in advance.
  8. V

    Excel question! ::NEVERMIND PROBLEM SOLVED::

    Thanks in advance for any help... I am trying to use VBA to cut and paste an entire worksheets information into a new workbook. The problem is, when this happens, all of my equations break, even if they're 'ok'. For instance: Workbook1 has two worksheets; 'budget' and 'rates'...
  9. V

    RESOLVED: PHP & SQL Server Authentication Help

    I am looking to set up a connection between a website set up on my localhost and the SQL db here at work. I have set up the ODBC connection and figured I'd be able to just use the odbc_connection() function with my UN/PW, however it does not seem to be working. Does this have anything to...
  10. V

    Fun with PHP, PDFs, and Crystal Reports!

    Hello - so in recent weeks I have been experimenting quite a bit with PHP & SQL. I am looking for guidance in how I might: a) automatically fun a crystal report using php b) print that crystal report to a pdf c) make that pdf accessible to a user Thanks in advance! Writing these...
  11. V

    SQL 2003 - Insert Help

    Hello - I am trying to do a bulk insert from a CSV file. The DST function in SQL Studio Express kind of sucks, so I am looking for a way to do this using the INSERT function. In MySQL its easy: INSERT INTO (col1,col2, etc) VALUES (val1,val2,etc), (val1,val2,etc), (val1,val2,etc)...
  12. V

    SQL Case Statement Syntax issue

    select fp.awarded_start_date, case fp.awarded_start_date when (fp.awarded_start_date >= '10/1/2006') then case '9/30/2007' when '9/30/2007' <= fp.awarded_end_date then DATEDIFF('m','9/30/2007',fp.awarded_start_date,"m") when '9/30/2007' > fp.awarded_start_date then...
  13. V

    Complex SQL Statements

    I am working with 2 tables: Submissions: ID, submitdate, groupid, statusid (60,000) Status: statusid, name (7) Currently, I have a select statement which is using nested queries and outer joins to produce a grid table with a count of submissions per group, with a given statusid ex...
  14. V

    SQL Statement

    Ok, so I am fairly new to SQL and I'm learning on the job. Any help would be appreciated, I'd also like advice on my approach if you believe it is a bit off. So, I've got 3 tables. Table B Project Req Table PIII Fund # Table Projects Project Exclude *Fund #'s are the same as...
  15. V

    Corolla Struts Need Replacing

    Exactly as the title says, i know nothing about cars, but is $1500 about right? and how often do struts need to be replaced?
  16. V

    WEP Key Automatically Provided - VISTA

    I am trying to connect to my network at work, I have a laptop with Windows Vista and directions for XP. When I try and set up the connection through the Vista - "Manually Connect to a wireless network" prompts it does not allowed me to enter that the WEP security/key passphrase is...
  17. V

    Pissed Off! Need wireless camera solution

    I am looking for a cheap camera solution, I realize this may sound ridiculous but there is dog shit nearly EVERYDAY in my parking space next to my car. It's a small space, about 20x20, just big enough for my car and my neighbors. And everyday there is a steaming piling of dog shit. I've...
  18. V

    Any MS Access Guru's in the house?

    I am trying to create a table in design view, there are 3 fields (not really but this will serve my purpose) Field 1 is someone's total money earned, Field 2 is the time they've worked here, Field 3 needs to be money / time How do I enter this? I know I can just make an update query to do...
  19. V

    Simple SQL Statement Issues

    SELECT DISTINCT b.[Employee ID], b.Project, b.Product, b.[Project Salary], b.Report FROM tbl_CHGLI030b AS b WHERE b.Report<>"exclude"; Pretty straight forward right? when I make it ="exclude" it returns all those where the Report field contains exclude, when I leave it as it is...
  20. V

    Do we have any bicyclists in the forum?

    I am looking to substitute my daily commute with a bike ride and I'd like your opinions or suggestions: Everyday I think about how ridiculous it is that it takes 45 minutes for me to travel from one side of Boston to the other (4.5 miles). My current commute consists of a 0.6 mile walk to the...
  21. V

    Buying a laptop TODAY UPDATE: PURCHASED LAPTOP

    Must have: 15.4" screen Decent battery life WiFi (they all have it now right?) Will be used for: Web Development (Dreamweaver, Adobe Photoshop, Apache, MySql, etc) Occasional movie watching on trips Bonuses: New over refurb - but I'm fine with a refurb Bluetooth - not...
  22. V

    Can someone tell me if they think this is a good deal?

    http://boston.craigslist.org/gbs/sys/726002552.html I found this laptop on Craigslist, I could definitely use a laptop at work for a combination of web development and office use. What is a reasonable offer to make? Thanks - J
  23. V

    Range Referencing in Excel

    Range("A1:L4") How would you represent this using just the column index? A1 = Range(1,1) L4 = Range(4,12) Range(1,1:4,12)
  24. V

    Storing DVDs on your computer

    What do you all use to rip DVDs to your hard drive? I am planning on picking up a 1TB drive solely for storing movies. What program is the best for ripping movies to my hard drive to stream to my PS3? How much space does each movie typically take up? Thanks
  25. V

    Excel External Data Query Refreshing issue

    In my spreadsheet I've got a list of about 400 data items I need to refresh, they are all prices. This code is supposed to refresh the prices by grabbing the new prices, then enter the new prices into another spreadsheet. What's happening though is that the prices are being copied into the...
  26. V

    XAMPP & IIS Running both concurrently.

    Is anyone running a similar set up? I'm just starting to get into more serious web development and I've had XAMPP running for awhile now, but my latest client wants an ASP platform and I'm having a hard time getting both Apache/XAMPP running with IIS running. I've changed the XAMPP port...
  27. V

    Movers Guide Coupon April 2008

    I am going to pick up a PS 3 and I can't seem to locate a copy of the movers guide April 2008 coupon? Can someone help me out? Not the right forum for this. Fortunately you already got the answer.:) Moderator allisolm
  28. V

    MySQL & XAMPP, Localhost access forbidden???

    I actually have two problems, the first: Recently I have decided to set up a test platform on my home system to test dynamic websites using PHP / MySQL. About two weeks ago I configured XAMPP to use a folder besides the XAMPP folder as my localhost/ directory to host websites in. Today...
  29. V

    Abit IP35-E Problems

    I purchased the Abit IP35-E motherboard everyone has been raving about in these forums and I have had nothing but issues. I get the double boot problem, then I started getting an error on start up that my CPU was not being recognized, now I am continuing to get weird errors where my keyboard /...
  30. V

    Newbie building an HTPC

    I am looking to build an HTPC, the goal is to replace my aging DVD player and my receiver. How can I go about creating an HTPC that will work as a receiver. How can I go about doing this?
  31. V

    Best Video Cards Under $250, $200, $150, $100

    I'm looking for your opinions, I hear so much about the 7900GTS, 1950xt, etc... What do the experts have to say if they are asked, what is the best card you can get at each of these price points? For the average user or the occasional gamer is it time to step up to DX 10? or how about for...
  32. V

    It's another one of those posts, from a long time lurker

    First off, I have to give a lot of praise for the help many of you give to those who come to the site looking for advice. This website has served as a great resource for myself and many friends. 1. What YOUR PC will be used for. That means what types of tasks you'll be performing. The PC...
  33. V

    Toshiba Tecra S1. anyone know how to open it?

    Exactly what the topic says... I've got a Toshiba Tecra S1, the screen goes beserk after about 2 minutes of having it on. It flickers and goes crazy. I was told it is probably a lose video cable. How do I get in there to check it out? Thanks in advance
  34. V

    Laptop Screen Flickering

    So, the warrantee on my lap top just ran up and now the screen is flickering, and not just a little bit. It's a Toshiba Techra, with a Radeon 9000. I've googled the problem and it looks like it may just be a loose wire. My questions are: how do I confirm this is the problem? (without...
  35. V

    Debating an upgrade...only $5-10k!

    http://www.popularmechanics.com/technology/industry/4217348.html Figured I'd post it since I hadn't seen anything since. This is an interesting concept. Imagine the games...
  36. V

    Newb question

    I have decided to build my next computer, I've enjoyed messing around in my past computers but this will be the first one I build from scratch. First off... I've noticed many power supplies appear to have fans on the top, and not many cases have top/rear vents... or the power supplies are in...
  37. V

    Graphics card question... X1300 Pro 256mb

    Would anyone recommend running this to support dual 19" Dell Ultrasharps? If was I going to upgrade what would be recommended? I'm thinking something with a similar power draw. Any idea how much I could sell this card for?
  38. V

    Dell Outlet Tracking...

    Alright, so before I get flamed for this, I am posting simply to promote some thought. I've been looking into building a computer vs buying for the past few months. I decided to start tracking prices in Dell's outlet. My thought is, but something from the dell outlet, sell the graphics card /...
  39. V

    Buying through Dell... maybe

    Alright, I've been reading and re-reading posts for the last few months. I plan on buying a new pc soon. My current set up is a bit dated. Dell 8200, p4 2.4ghz, ti4200, 512rd-ram.. yea But I do however have a nice dell 1905f LCD monitor...and I still use the 17" flatscreen that came with the...