1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Did MS Access ever tell you that.... :)

Discussion in 'Databases' started by ludwig, Oct 8, 2006.

0
  1. #1
    Hi guys,

    Yesterday I typed an SQL statement in MS Access and got an error, please see it attached.

    Does this mean my code is right but Access can't do it and that's why it is wrong?

    :)

    I was loughing for an hour or so :)
     

    Attached Files:

    ludwig, Oct 8, 2006 IP
  2. max pain

    max pain Notable Member

    Messages:
    2,179
    Likes Received:
    521
    Best Answers:
    0
    Trophy Points:
    260
    #2
    I had this error once.. and did some research on it
    Error Number: 3025
    Error Message: Reserved error <item>; there is no message for this error. Class : unused

    There are two possibilities in this case either a timestamp problem or the query hitting an un-used class.
    Removing the timestamp and recreating at end can fix this problem if its related with the first one...
    Hopefully you have fixed the error by now?
     
    max pain, Oct 8, 2006 IP
  3. ludwig

    ludwig Notable Member

    Messages:
    2,253
    Likes Received:
    66
    Best Answers:
    0
    Trophy Points:
    225
    #3
    no didn't need to continue, I just needed a system for an Army database for a friend of mine, he said its okay if I have one less function :) so I stopped it
     
    ludwig, Oct 8, 2006 IP
  4. max pain

    max pain Notable Member

    Messages:
    2,179
    Likes Received:
    521
    Best Answers:
    0
    Trophy Points:
    260
    #4
    Just out of curiosity what was that query meant to do?
     
    max pain, Oct 8, 2006 IP
  5. ludwig

    ludwig Notable Member

    Messages:
    2,253
    Likes Received:
    66
    Best Answers:
    0
    Trophy Points:
    225
    #5
    that query meant to do the following:

    When you choose a soldier and want to send him lets say to the district X, it was suppost to see how many people with the mention profession are allowed to go to district X and how many are there now. then put that data in a TEMP table, then the VB script should have checked the TEMP and see whether they can send that person there or no

    hope I was clear in explaining:)
     
    ludwig, Oct 8, 2006 IP
  6. max pain

    max pain Notable Member

    Messages:
    2,179
    Likes Received:
    521
    Best Answers:
    0
    Trophy Points:
    260
    #6
    ok :) seems pretty simple .. i am sure you must have done it easily
     
    max pain, Oct 8, 2006 IP
  7. ludwig

    ludwig Notable Member

    Messages:
    2,253
    Likes Received:
    66
    Best Answers:
    0
    Trophy Points:
    225
    #7
    i'd do it easily with ASP and MsSQL or even ACCESS but not VB
     
    ludwig, Oct 8, 2006 IP