MS Access editing Thread

Discussion in 'FIFA 2003 Forum' started by Alex, Nov 8, 2002.

  1. NakahoVa

    NakahoVa Club Supporter

    Joined:
    Dec 7, 2002
    Messages:
    30
    Likes Received:
    0
    Location:
    Japan
    When i choose a player on the left section the information overlaps the player information on the right side and it's quite confusing.. so i can't use the "all players" section, also things are different like the boot type.. when i don't touch anything it's 0 but when i click a player from the left section and it overlaps the untouched info the boot type is 36.. :gavin:
     
  2. Maniac

    Maniac Reserve Team

    Joined:
    Jan 15, 2001
    Messages:
    551
    Likes Received:
    0
    Location:
    Oslo, born in Sarajevo
    Well, The Section "all Players" is like a navigation menue, when you choose a player, it's information will be shown on the right. That is how it works,
    But you can also use the navigation bar on the top of the form, there you have buttons which will navigate you to the first player, last player, and next and previous player.

    All players have boot type 36, and I would also use that number, and leave the body to 0.

    hope it helps
     
  3. Phil the Leeds fan

    Phil the Leeds fan Youth Team

    Joined:
    Aug 9, 1999
    Messages:
    221
    Likes Received:
    0
    Location:
    S c u n t h o r p e, North Lincs, ENGLAND
    I understood what you meant, but I thought the whole table would save time!!

    Compacted and repaired and it's ok now, thanks.

    Phil
     
  4. Punkt

    Punkt Fan Favourite

    Joined:
    Nov 22, 2002
    Messages:
    9,708
    Likes Received:
    1
    Location:
    Lisbon - Portugal
    plz someone tell me how can i import logos to the teams? i created lokomotiv moscow and when i start a game appears the real madrid logo...:(
     
  5. Maniac

    Maniac Reserve Team

    Joined:
    Jan 15, 2001
    Messages:
    551
    Likes Received:
    0
    Location:
    Oslo, born in Sarajevo
    Well mate, it depends if you replaced a team or created a totaly new one. If you replaced it, then you can use FSH Tool to import the badge, but if you created the team, then there is no way to add a logo, yet! The Logo Raptor is underway, so all we can do is wait.
     
  6. Bolerus

    Bolerus Youth Team

    Joined:
    Nov 13, 2002
    Messages:
    158
    Likes Received:
    0
    Can anybody help me please


    using access i have added a new team (stoke city)

    and some players (18 of them)

    when i try to install the package

    it goes through the saving playes section, wiht no errors (once i had deleted a balnk record i had inadvertadly creatE)

    Then it goes through the saving teams section and i get

    run time error 3201

    Either BOF or EOF is true or the current record has been deleted. requested operation requires a record

    Any ideas where i shoudl look please.
     
  7. Punkt

    Punkt Fan Favourite

    Joined:
    Nov 22, 2002
    Messages:
    9,708
    Likes Received:
    1
    Location:
    Lisbon - Portugal
    this error appears because your new team don't have assigned kits..
    you should create new kits in the kits table and assign them to the new team;)
     
  8. Bolerus

    Bolerus Youth Team

    Joined:
    Nov 13, 2002
    Messages:
    158
    Likes Received:
    0
    ok thanks

    just to test it, i just gave my teams the numbers from a random team , i just looked down the lsit and picked one
    1642 i think

    the package is installign as i type this.

    Will i now be abale to add the corect kit using kitraptor?
     
  9. Bolerus

    Bolerus Youth Team

    Joined:
    Nov 13, 2002
    Messages:
    158
    Likes Received:
    0
    ok forget that last question.

    i have a more inportant one

    where is my team??

    just installed the package and my team isnt there

    in CC if i click on creation cetnre teams., i can see my team

    but if i make a new competition, it sasy sthe creaction centre teams list is empty

    do i have to assign my team to a competition in access and if so, which variable is it please.


    I know I am bieng a pain, but once i have learned to do it properly, i can transpose my previously created english first division teams into the database , and hopefully get it working without having to move everythign around in team management every time i make a change
     
  10. Punkt

    Punkt Fan Favourite

    Joined:
    Nov 22, 2002
    Messages:
    9,708
    Likes Received:
    1
    Location:
    Lisbon - Portugal
    you should assign your team to the rest of the world section in the federations table.next open CC and the team will be in there
     
  11. Maniac

    Maniac Reserve Team

    Joined:
    Jan 15, 2001
    Messages:
    551
    Likes Received:
    0
    Location:
    Oslo, born in Sarajevo
    It would be a lot easier if you just downloaded a Access Editor. There is mine on www.fifa-bosnia.com or www.fifaecp.com
    And there is sKIp_E's on the SG download Centre....
     
  12. Bolerus

    Bolerus Youth Team

    Joined:
    Nov 13, 2002
    Messages:
    158
    Likes Received:
    0
    I have tried that editor before and got all sorts of runtime errors

    so i deleted it

    now

    With regards to putting my team into the federations link table

    here is the link_FT sorted by ID

    id Team Federation
    32208 5026 76
    32206 97 76
    32205 110 76
    32204 95 76
    32203 94 76
    32202 91 76
    32201 1998 341

    And here sorted by Team

    id Team Federation
    32208 5026 76
    32201 1998 341
    32200 1998 340
    32199 1998 339
    32198 1998 338



    tean 5026 is my team (obviously i just ciopied and pasted fires few teams)


    If i put my team in this link table, so that it will go into a team

    i get

    Debug: unexpected error

    description: the changes you have requested to the table were not successful because thjey woudl create a duplicate value in the index, primary key or relationship. change the dta ETC
    at the end is the numbers (-2147467259)

    If I dont put my team in he linker table, then it isnt in game

    any ideas of where I am goin wrong please


    I can zip up and send you the database if you give me an email addy to send it to

    (i used to br good in access, but thats what happens when you dont use it for a couple of years lol)
     
  13. Bolerus

    Bolerus Youth Team

    Joined:
    Nov 13, 2002
    Messages:
    158
    Likes Received:
    0
    Ok

    this is mad

    Made no changes, just went in to the tables and checked the link_FT again

    decided there was definately no duplicatre

    went into cc again and this time it loaded and there was my team in rest of world

    installed package, and went into fifa

    My team was there (yay)

    BUT

    the team management was still all screwed up????????



    NOPE that doesent work, I found the table that holds the numbers for leagues and cups, add a few numbers (21 22 23 24 ) and in cc i can now make a league with upto 24 teams. but it gets an error -subscript out of range, when you try to install

    If access editing method still messes the team up, whats the point in using it.

    Unless you can create new leagues with more than 20 teams in, which im going to try next

    Am I doing something wrong here, or does access (our flexible friend) still hate me
     
  14. Alex

    Alex sKIp_E Staff Member Administrator

    Joined:
    Oct 20, 2001
    Messages:
    13,762
    Likes Received:
    12
    Location:
    Sydney, NSW, Australia
    Formations being stuffed up, is a sign of team IDs being too high (above 5000 i think is too high for teams. Start at 1800, and work ur way up. Read that adding a team in access tut. of mine for more quick info.

    If its not the teams ID that is too high, it could be the players. They also have to be low. Lower then 55000 or something for them..Ive stopped editing somewhat atm, so cant promise u exact numbers, but this is approximatley the values. use under these as ID, and u cant go wrong.

    Cheers
    sKIp_E
     
  15. Alex

    Alex sKIp_E Staff Member Administrator

    Joined:
    Oct 20, 2001
    Messages:
    13,762
    Likes Received:
    12
    Location:
    Sydney, NSW, Australia
    Try my forms then. Available at downloads.soccergaming.com in the FIFA2003-Creation Centre section.

    My forms arent as user friendly as maniacs, but because they are less complex seem to have less errors. If you get maniacs working they are most likely better, but mine are easier to get working in the first place (in my opinion ;)).

    Hey over 5000 downloads, with hardly ANY complaints...how could u go wrong :p (not meaning to be boastful of course :P)

    Cheers
    sKIp_E
     
  16. zul-aid

    zul-aid Starting XI

    Joined:
    Jul 1, 2002
    Messages:
    3,666
    Likes Received:
    0
    Location:
    Brisbane, Australia
    I sought of had one complaint thats why i sent my :drevil: package :drevil: to you.
     
  17. Alex

    Alex sKIp_E Staff Member Administrator

    Joined:
    Oct 20, 2001
    Messages:
    13,762
    Likes Received:
    12
    Location:
    Sydney, NSW, Australia
    Yeah, but that was weird. I think that was becos u used a beta originally, and over wrote it with the final release. This can cause probs ;)

    Cheers
    sKIp_E
     
  18. zul-aid

    zul-aid Starting XI

    Joined:
    Jul 1, 2002
    Messages:
    3,666
    Likes Received:
    0
    Location:
    Brisbane, Australia
    na i didnt use that one as i was using one of my numerous back ups as you would recall through our many convos on this subject i was always mucking up with database i was using.
     
  19. Hans

    Hans How big is YOUR penis?

    Joined:
    Sep 19, 2002
    Messages:
    6,350
    Likes Received:
    0
    Location:
    Between the legs . . .
    Hercules, I don`t mean to push you or anything, but I haven`t followed this thread for weeks now. I want to know how is your progress with your dbi editor ? How many percent has it been done ? Thanks. . .
     
  20. Hercules

    Hercules Starting XI

    Joined:
    Apr 16, 2002
    Messages:
    3,702
    Likes Received:
    0
    Location:
    UK
    Still a long way. It's hard work.
     
      

Share This Page