Excel Help Wanted (Yeah, I know I'm using a hammer to turn a screw)

Discussion in 'Techforge' started by Volpone, Jan 8, 2007.

  1. Volpone

    Volpone Zombie Hunter

    Joined:
    Nov 10, 2004
    Messages:
    43,792
    Location:
    Bigfoot country
    Ratings:
    +16,272
    OK. I've got another job. Sadly like all my other jobs this one involves a lot of work for no pay :( , but I digress.

    I'm building a database to track information on group members and I'm thrashing out the organization of it. It is pretty easy to wind up having an entry take up more than one page, and some of the fields are only going to be used rarely (but are needed).

    I'd also like to be able to "drill down" into entries. For instance I want to be able to just list the major, top-level goal each person is working on, but I'd like to be able to link fields to a more detailed entry on where they are on sub-tasks--tracking progress.

    ...I really need to create a database if I want anything that complex, don't I? :(
  2. Dan Leach

    Dan Leach Climbing Staff Member Moderator

    Joined:
    Mar 29, 2004
    Messages:
    32,366
    Location:
    Lancaster UK
    Ratings:
    +10,668
    Yep, that sounds like a job forrrr.... du duh duh doooooo
    Microsoft Access, the worlds most annoying programme :P
  3. Marso

    Marso High speed, low drag.

    Joined:
    Mar 27, 2004
    Messages:
    29,417
    Location:
    Idaho
    Ratings:
    +14,151
    Dude, what's up with all these jobs for no fucking pay? Do I have to point you to my dog eared copy of Atlas Shrugged? :mad:
    • Agree Agree x 1
  4. Ebeneezer Goode

    Ebeneezer Goode Gobshite

    Joined:
    Mar 28, 2004
    Messages:
    19,119
    Location:
    Manchester, UK
    Ratings:
    +8,244
    its a database job :itsokay:
  5. Ebeneezer Goode

    Ebeneezer Goode Gobshite

    Joined:
    Mar 28, 2004
    Messages:
    19,119
    Location:
    Manchester, UK
    Ratings:
    +8,244
    wait til the mexicans find out they can get hired for below minimum-wage, and then foist the job on to volpone at a tidy profit...
  6. Volpone

    Volpone Zombie Hunter

    Joined:
    Nov 10, 2004
    Messages:
    43,792
    Location:
    Bigfoot country
    Ratings:
    +16,272
    Wrestling with Office (and a 7 year old version, at that) makes me want to murder Bill Gates with a hammer.

    If the database wasn't so phenomenally annoying to work with I'd be using the right tool for the job. Because it is arguably the most user-unfriendly piece of mainstream software on the market, I'm trying to make a spreadsheet do the job of a database. Which is a bit like trying to build a cabinet with a handsaw, an electric drill, and a tape measure. :mad:

    So for some reason, the bastard won't let me sort the thing by fields. Well, it will let me sort by fields. But for some reason it only sorts PART of the thing by fields. That doesn't do me a whole lot of good, as I sort of want the e-mail addresses of people to correspond to the person I want to contact. :bang:
  7. Ebeneezer Goode

    Ebeneezer Goode Gobshite

    Joined:
    Mar 28, 2004
    Messages:
    19,119
    Location:
    Manchester, UK
    Ratings:
    +8,244
    meh, access is far from the worst thing i've enountered, and since 2000 has actually been okay - not that i'd normally admit that of course.

    couldn't you do the thing in sql server express with an intranet, if they can't afford to shell out for a decent RAD tool?
  8. BearTM

    BearTM Bustin' a move! Deceased Member

    Joined:
    Mar 27, 2004
    Messages:
    27,833
    Ratings:
    +5,276
    People have problems with Access???
  9. Darkening

    Darkening Guest

    Ratings:
    +0
    Never used it :D
  10. Ryan

    Ryan Killjoy

    Joined:
    Mar 29, 2004
    Messages:
    7,484
    Location:
    Lincoln, Nebraska
    Ratings:
    +1,173
    Did you select "expand selection" when prompted?
  11. Volpone

    Volpone Zombie Hunter

    Joined:
    Nov 10, 2004
    Messages:
    43,792
    Location:
    Bigfoot country
    Ratings:
    +16,272
    Eh. I had an empty column. That was acting as a buffer. After I deleted that column it worked. :garamet:
  12. Spider

    Spider Splat

    Joined:
    Jun 4, 2004
    Messages:
    5,233
    Ratings:
    +447
    This really sounds like something that should be done on a database. Look at it as an opportunity to brush up a new skill set. If you aren't being paid, you should at least try to get a few new resume points out of it. :shrug:
  13. Zenow

    Zenow Treehugger

    Joined:
    Mar 28, 2004
    Messages:
    4,081
    Location:
    Netherlands
    Ratings:
    +897
    At some point in this project, someone's going to say: 'oh yeah, did we mention we want to be able to access and edit this on the net?'
    Use a database. For this stuff, access is easy enough to use (if their website supports asp).