Results 1 to 12 of 12
  1. #1
    Join Date
    Aug 2006
    Posts
    559

    Unanswered: ERRORS GALORE! (Think its with Access, not the user)

    Ok, so I just did a fresh install of WinXP Pro and Office 2003 but when I try to type in code in VBA EVERYTHING is saying that its invalid.

    It doesn't matter what I type, just even like a DoCmd, still puts everything behind it with an error. I know I'm not typing it wrong because I even printed out the code of an entire other DB that I did where all the coding works.

    Anyone got any idears?

  2. #2
    Join Date
    May 2008
    Location
    Raleigh, NC
    Posts
    151

    Just a thought...

    Have you checked what references are loaded? Could be something got hosed during the install.

    Good luck,
    Stu
    --If its free, take it for what its worth!

  3. #3
    Join Date
    Aug 2006
    Posts
    559
    Stu,

    Thanks for the tip. I checked everything that I know of. The machine, even though it was wiped and reloaded, has major issues. Well, I should say, it's not with the machine particularlly, it's actually with the administration in the IT department who configured that DC. I don't know what they did, and they don't even know what they did. So I had to set up a dumb terminal to do everything on. Geez!

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    ^^ Awesome work there by the IT department ^^
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Aug 2006
    Posts
    559
    Quote Originally Posted by StarTrekker
    ^^ Awesome work there by the IT department ^^
    Yeah, don't I know it! I told them there's issues, they deny it or just don't care. I can't even use the scroll on my mouse cause it doesn't work! I mean, dud, seriously!!!!

  6. #6
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    IT ! have you tried talking to them WITHOUT using the word "why" ?

    ...they feel less threatened that way.

    izy
    currently using SS 2008R2

  7. #7
    Join Date
    Aug 2006
    Posts
    559
    Quote Originally Posted by izyrider
    IT ! have you tried talking to them WITHOUT using the word "why" ?

    ...they feel less threatened that way.

    izy
    Yeah, don't I know it. Funny thing, I'm in that IT department but I've just started the job and they don't like it when someone is there that knows more than they do and tells them that something is wrong.

  8. #8
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    If they were my IT department, I would fire them for incompetence and hire new people -- how can they refuse to help??
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  9. #9
    Join Date
    Aug 2006
    Posts
    559
    Don't ask Trekk!

  10. #10
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    When you're new it's easy to spot the mistakes - fresh pair of eyes. People grow to become accustomed to kludgy, different, interesting stuff like this.

    My tip would be to not say anything about the way things work for the first 3 months or so - just note down anything you see as odd and bring it up appropriately later.

    I work in the IT department, not all of us are that bad
    George
    Home | Blog

  11. #11
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by georgev
    ....I work in the IT department, not all of us are that bad
    theres a world of difference between the development team(s), DBA's and others invovled wth applciation development and deployment.

    virtually without exception the network & hardware IT people a a bunch of misanthropes who seem to believe that its 'their' network, and any /every body else is the enemy.... hence why I call 'em trolls. the nuber of days wasted becasue they changed a site environemnt (because they wanted to), the number fo problems caused because sureptisious chanegs to the applciation platform nuke config files & settings
    the number of times when they have decided to do what they want rather than what the organistaion requires.

    trolls....
    I'd rather be riding on the Tiger 800 or the Norton

  12. #12
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740

    If they were my IT department, I would fire them for incompetence and hire new people -- how can they refuse to help??

    __________________
    Owner and Manager of

    ...i guess having that in your signature makes life simpler.

    izyMegaCorp IT-darlings don't have names or phone numbers or mail-addresses - i start with a call center and only after convincing them that i have plugged in the PC, i have rebooted, i have entered my password correctly, andOnAndOnAndOnAndOnAndOn do i get a ticket with the right to talk to intelligent lifeforms. to be fair tho, the "trolls" who foster-care my SQLserver instances are 1000x more awake than the rest of them, but i still need to go thru the ticket-generation 8u££$#1t first.

    its the weekend! forget IT.

    izy
    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •