MS Access editing Thread

[Hakeem]

Re: Re: .

Originally posted by sKIp_E
Yeah, im really not sure sometimes the new players seem to work, and other times they dont. When u say the position u gave them, do u mean the position in Arsenal, OR the positional preference of the player, because the latter always works
Also the player doesnt appear in the CC created players in the main window of the CC, but if u open the package window (the little tab), than they will appear as added players there. Its because the CC knows it didnt add them, but also knows they werent in the original FIFA db

I mean the position in Arsenal.
I change the position in the team for bergkamp (put him as a susbtitute = 32) and I put my player in the position of bergkamp and then in the game bergkamp was in the bench and my player in the field and the other players were ok, not messed up.

Originally posted by sKIp_E
Yeah Leagues do seem to cause problems. When i added the Confederations Cup, it looked fine in the CC, but in the game, not only did it not appear, it also put all the Rest of World teams into the International group, all the International teams dissappeared, and the rest of world group disappered!

I didnt checked about this but I put my created team in the rest of the World Section AND in my new league and the team appeared in the Rest of the World Section in the game but the new league didnt.

 

[Hakeem]

.

Originally posted by sKIp_E
Yeah, but u need the CC open anyway, to install the package, and can u imagine trying to describe all the different faces?
Ur better off to just leave the CC open in the background, whilst editing in access.

Maybe one day someone will be bothered to make a program which lets u see the faces etc, whilst editing the Access database (i know that VB is a very easy language to manipulate Access DB's in)

Cheers
sKIp_E

and about this, does the faces appear in the combo (when your selecting the face type, hair type, etc) listed by code?
coz I have all, the hair types, etc. together in one big image and I want to know if the first hair type that appears in the list is also the code 0 in the database and so on.

 

[Maniac]

Can someone post a list of the positions?
It says in numbers? How do I know what position is e.g 15????

thanks

 

[Hakeem]

here

0 = GK
2 = RB
3 = RCB
5 = LCB
6 = LB
9 = RCDM
11 = LCDM / CDM
14 = RM
16 = RCM
18 = LCM / LM
23 = CAM
28 = LF
29 = RS
31 = LS
32 = SUBSTITUTE
33/34 = RESERVE


use the subs/reserves only in the link_PT table not in the players table

 

[Maniac]

Thanks!

Good news! I am underway in making a "Access editor" for Fifa 2003!! All the functions will be possible, just in a more friendly and a more understandable way!!

Please, if anyone know (like Hakeem here) what the numbers of each option mean, tell me. So I can make a "option turtorial" on the menu. Thx!


Posting screens soon...

 

[Maniac]

Here is the screenshot of the Player Window:

 

[rid]

Originally posted by Maniac
Here is the screenshot of the Player Window:

what about the id of the new added player?

 

[Maniac]

I have solved that problem.

I have added a Serch function ( I will post a new screenshot). Where you can choose to either search for the Player ID or the Player name.
Either way, you chose. And the player is found!!

 

[rid]

Originally posted by Maniac
I have solved that problem.

I have added a Serch function ( I will post a new screenshot). Where you can choose to either search for the Player ID or the Player name.
Either way, you chose. And the player is found!!

no, i mean what id does a player get if you add him? is it < 54999? if not, you can forget all settings made in the access database.

 

[Maniac]

I don't get it. Why foret all of it? It works, doesn't it?
I get the 55013 number, and over....
What's wrong???

 

[rid]

Originally posted by Maniac
I don't get it. Why foret all of it? It works, doesn't it?
I get the 55013 number, and over....
What's wrong???

does the cc display the player as cc-player or default??

 

[Maniac]

I go to the CC program, I go to the CC section and to the CC players. Thats where they are.
All of those who I have made. With correct stuff. Only the abilites option is a bit weird. 0 is 1 and 9 is 10

 

[rid]

Originally posted by Maniac
I go to the CC program, I go to the CC section and to the CC players. Thats where they are.
All of those who I have made. With correct stuff. Only the abilites option is a bit weird. 0 is 1 and 9 is 10

yes, but settings like player number etc won't be importet to fifa...

 

[Maniac]

how do you add a custom kit to a club??
In the Custom_Kit table is says ID and Name. What is supposed to say in name and where do the kit parts have to be placed??

 

[Treebeard]

Does ne1 know how to disable the auto ID feature which allocates player numbers in the tables in ms access as this is preventing some changes from showing up in the game - the first player you create always has an ID of 55013 but in theory it should be and ID of 2 as there is no player 2 in the player list.

I did it once but don't know how and all changes showed up but I have never been able to repeat it and ever since the players I create never have the correct squad number...

Tb

 

[Hakeem]

.

Originally posted by Treebeard
Does ne1 know how to disable the auto ID feature which allocates player numbers in the tables in ms access as this is preventing some changes from showing up in the game - the first player you create always has an ID of 55013 but in theory it should be and ID of 2 as there is no player 2 in the player list.

I did it once but don't know how and all changes showed up but I have never been able to repeat it and ever since the players I create never have the correct squad number...

Tb

go to the relations and delete the relation between the link_PT table and the players table.
then go to the design view and change the value from Autonumeric to numeric and thats it.
after making everything I think you should create the relation back.
I havent tested it myself

 

[Hakeem]

hey Rid

how come that for some people like me, the new IDs start in 53330 and for others doesnt???

coz my created players are not listed in the CC players section but if I assign a team to them then everything is perfect: lineups, numbers, etc

 

[Ethereal]

how can i change the color of fans shirts in the crowd from ms access?

 

[rid]

Re: hey Rid

Originally posted by Hakeem
how come that for some people like me, the new IDs start in 53330 and for others doesnt???

coz my created players are not listed in the CC players section but if I assign a team to them then everything is perfect: lineups, numbers, etc

if you once added a dataset with an id like 3 or something, the next new dataset will get the next free id. hard to explain... not to understand...

 

[Alex]

Re: here

Originally posted by Hakeem
0 = GK
2 = RB
3 = RCB
5 = LCB
6 = LB
9 = RCDM
11 = LCDM / CDM
14 = RM
16 = RCM
18 = LCM / LM
23 = CAM
28 = LF
29 = RS
31 = LS
32 = SUBSTITUTE
33/34 = RESERVE


use the subs/reserves only in the link_PT table not in the players table

WAIT!

Hakeem, this list isnt the best for positions, and is often wrong.
I started this very thread with a TRUE and complete list of positions, ill repost them here. Also this list is in the Access database, so really I cant see why this above list keeps being posted (no offence Hakeem).

0-GK
1-SW
2-RWB
3-RB
4-RCB
5-CB
6-LCB
7-LB
8-LWB
9-LDM
10-LCDM
11-CDM
12-RCDM
13-RDM
14-RWM
15-RM
16-RCM
17-CM
18-LCM
19-LM
20-LWM
21-RAM
22-RCAM
23-CAM
24-LCAM
25-LAM
26-LF
27-CF
28-RF
29-LS
30-ST
31-RS
32-Sub
34/35-Reserve