Access version US vs EU - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Access version US vs EU

Carolyn Bendahan

2 years ago

I am struggling with some difficulties, such as events not working properly. After checking the original download database, I see it's the same issue there. So, I assume, it is because I am working on a German system. If this is a known problem, what can I do? Or am I just having a stupid day?
I would be very thankful for some advice.

	Carolyn Bendahan OP @Reply 2 years ago

	Carolyn Bendahan OP @Reply 2 years ago
this is the way it works with my system:

	Carolyn Bendahan OP @Reply 2 years ago

	Matt Hall @Reply 2 years ago
Msgbox SalesRepCombo.column(3) to see what you get. Does Val() work with commas?

	Richard Rost @Reply 2 years ago
I'm going to have to defer to some of my other EU students to answer this one. I have almost no experience with any of the foreign versions. Sorry!

	Richard Rost @Reply 2 years ago
Is everyone else correct? Did you close and reopen all of the forms?

	Carolyn Bendahan OP @Reply 2 years ago
thank you Matt! msgbox shows 0,1. CommissionRate = Val(SalesRepCombo,Column(3)) doesnt work, if thats what you meant.

	Carolyn Bendahan OP @Reply 2 years ago
Thank you, Richard. I opened and closed everything several times. There are some more problems, I just thought I should start with the easiest one. Maybe I will try to change to US English settings. Though, I am a little afraid, that my other databases won't work anymore.

	Matt Hall @Reply 2 years ago
There is a note on the Microsoft page recommending CDbl instead of Val if you don't use a period for a decimal.

	Carolyn Bendahan OP @Reply 2 years ago
Cool, cool. No idea what that's all about. But it works! Thank you! Maybe with that information, the other problems will be solved too. I will go on and try.

	Carolyn Bendahan OP @Reply 2 years ago
I found out that there is a standard difficulty while working with EU settings, and I found a video with a workaround. As it might help other students from Europe, I am sharing a link to the video that helped me, as well as a short overview of the problem in the screenshots. Link: https://www.youtube.com/watch?v=c2_fEdFBj_Q&t=1229s

	Carolyn Bendahan OP @Reply 2 years ago

	Carolyn Bendahan OP @Reply 2 years ago

	Richard Rost @Reply 2 years ago
Thanks for sharing, Carolyn. One of my weaknesses is that I have very limited experience with the foreign language versions of Office.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View