Greetings from Spain! Access 2024 with Spanish language Fitness #49: When entering the '=' symbol as the value for the 'calories' field, Access reports this error: "The value you specified is not valid for this field." The field is numeric and does not accept the '=' symbol.
Why is this symbol accepted in the YouTube video?
Code I used:
'If the equal sign (=) is pressed, switch to calculator mode
If KeyCode = 187 Then
Dim S As String, L As Double, msg As String ' msg = "Equation or value:" & vbNewLine & "(Do not type anything to exit)" ' S = InputBox(msg, "Calculator")
I want to thank you for your prompt response and let you know that the problem has been resolved some time after I sent my message.
The issue is that the codes returned by the KeyCode function are not the same in English as in Spanish. While in Fitness video #49 they referred to 'If KeyCode = 187 Then', my system works correctly with 'If KeyCode = 48 Then'.
I wish it were that easy to solve the date problem: Access handles dates in 'dd/mm/yyyy' format very poorly, and I'm going to have to write a function that converts the Spanish format to the English format, which Access handles better.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
