Soccer Poisson database

Football, Soccer - whatever you call it. It is the beautiful game.
Post Reply
User avatar
ChrisF
Posts: 56
Joined: Mon May 22, 2017 10:48 am

Cheers, I'm not really a user of Access so I stick with my 2013 version if there's no reason to change.
jtrader
Posts: 115
Joined: Thu Feb 09, 2017 11:35 am

I'm using Access 2019 and I have no that option in VBA editor - "Microsoft Forms 2.0 Object Library"!

Does anyone face the same problem?
User avatar
Derek27
Posts: 23678
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

jtrader wrote:
Fri Mar 15, 2024 11:02 am
I'm using Access 2019 and I have no that option in VBA editor - "Microsoft Forms 2.0 Object Library"!

Does anyone face the same problem?
Is the file FM20.DLL in your Windows\System32 directory?

If it is you may be able to attach it by clicking on the browse button and locating it. Alternatively, the Office repair facility might correct the problem.
jtrader
Posts: 115
Joined: Thu Feb 09, 2017 11:35 am

Derek27 wrote:
Fri Mar 15, 2024 5:42 pm
jtrader wrote:
Fri Mar 15, 2024 11:02 am
I'm using Access 2019 and I have no that option in VBA editor - "Microsoft Forms 2.0 Object Library"!

Does anyone face the same problem?
Is the file FM20.DLL in your Windows\System32 directory?

If it is you may be able to attach it by clicking on the browse button and locating it. Alternatively, the Office repair facility might correct the problem.

Yes,I have FM20.DLL in Windows\System32

...and I've copied it in that location on that pic,but still not solved the problem

Image


And I've read anywhere - "MS Forms 2.0 Object Library is a library used by Office products. Newer versions of Office do not have this library, and you cannot distribute it (and you never should have used it in Office development anyway)."


May be I could go back to older version of Access...
User avatar
Derek27
Posts: 23678
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

jtrader wrote:
Sat Mar 16, 2024 12:32 am
Derek27 wrote:
Fri Mar 15, 2024 5:42 pm
jtrader wrote:
Fri Mar 15, 2024 11:02 am
I'm using Access 2019 and I have no that option in VBA editor - "Microsoft Forms 2.0 Object Library"!

Does anyone face the same problem?
Is the file FM20.DLL in your Windows\System32 directory?

If it is you may be able to attach it by clicking on the browse button and locating it. Alternatively, the Office repair facility might correct the problem.

Yes,I have FM20.DLL in Windows\System32

...and I've copied it in that location on that pic,but still not solved the problem

Image


And I've read anywhere - "MS Forms 2.0 Object Library is a library used by Office products. Newer versions of Office do not have this library, and you cannot distribute it (and you never should have used it in Office development anyway)."


May be I could go back to older version of Access...
I'm using what they now called Microsoft 365 (Version 2402). Don't understand why they've removed a library and not replaced it, but I guess the best place to find an answer would be on the Microsoft forum. Sorry.
User avatar
imperatore
Posts: 4
Joined: Tue Jan 30, 2024 4:21 pm

Thanks for sharing this with us.

For those who are going to download I would like to mention that if you do not have fm20.dll you don't need to download it.
Because I do not have fm20.dll at all and it works fine.

My first comment :lol:

CHEERS
User avatar
Derek27
Posts: 23678
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

imperatore wrote:
Sat Mar 16, 2024 11:43 am
Thanks for sharing this with us.

For those who are going to download I would like to mention that if you do not have fm20.dll you don't need to download it.
Because I do not have fm20.dll at all and it works fine.

My first comment :lol:

CHEERS
I guess that wasn't the case when I wrote it because I think I tested the references, but thanks for letting us know.

And welcome to the forum. :)
jtrader
Posts: 115
Joined: Thu Feb 09, 2017 11:35 am

I think I've solved the problem,but is there a easy way to convert csv files from https://fixturedownload.com to be compatible for accdb?
User avatar
Derek27
Posts: 23678
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

jtrader wrote:
Sun Mar 17, 2024 10:22 am
I think I've solved the problem,but is there a easy way to convert csv files from https://fixturedownload.com to be compatible for accdb?
It has to me done manually. The order of fields are in the first post in this thread. You can simply cut the unwanted columns and rearrange the order of them.
jtrader
Posts: 115
Joined: Thu Feb 09, 2017 11:35 am

Derek27 wrote:
Sun Mar 17, 2024 2:10 pm
jtrader wrote:
Sun Mar 17, 2024 10:22 am
I think I've solved the problem,but is there a easy way to convert csv files from https://fixturedownload.com to be compatible for accdb?
It has to me done manually. The order of fields are in the first post in this thread. You can simply cut the unwanted columns and rearrange the order of them.

Thanks,Derek27! I've managed that and it's working quite well now ;)

And only if you could solve another problem with BF P/L sheet - viewtopic.php?p=351735#p351735 ?
Post Reply

Return to “Football trading”