What am I probably going to do is to change the attribute type in the original from number (long) to text. Then set up some conditions/catches in the "beforeupda te" event.
Please correct me if i am on a totally wrong direction.
User Profile
Collapse
-
I am doing this in Access. Unfortuanately the post i put up on Access forum got deleted, because i accidently post it up here first.
Anyway. Thank you people, i think i understand the situation now which I should not bound the object for numberic data only from the "table" level.
Have a great coming week!Leave a comment:
-
catch data type invalid error and convert it before system does
GOOOOD DAY. Geeks
This is my first post and I do not know whether my title makes sense to you.
Here is the problem..
I have a Access database. There is a table contains two fields called Latitude and Longitude which are stored as numerical coordinate, Number (Double, decimal).
Based on this table, i crated a form to fill in these two values.
I would like to create an error...
No activity results to display
Show More
Leave a comment: