ms access - Using an expression in a numeric form control -


i have access form textbox bound currency field in table. expected, other numerical entry generates error. occasionally, users need enter several amounts , have added , result entered currency field.

to accomplish this, users enter equal sign followed valid arithmetical string evaluate number in excel cell. example, if user enters "=5.31+2" want field evaluate "7.31" , use value passed table when record updated or saved. current workaround use calculator application isn't ideal solution.

i tried following code , applied both beforeupdate , onlostfocus events of textbox (named "tbxtotal_paid") neither worked. got "the value entered not valid field" error.

dim charct integer dim evalstr string  if left(tbxtotal_paid, 1) = "="     charct = len(tbxtotal_paid)     evalstr = right(tbxtotal_paid, charct - 1)     me.tbxtotal_paid = ccur(evalstr) end if

is applying code incorrect event or coding issue? assistance appreciated.

for me code looks fine might put in wrong place.

like said acess giving error because textbox bound currency-field. never accept non-numerical values because value-checking code fires before before_update-event.

i think best solution hide bound text box using me.tbxtotal_paid.visible = false , creating surrogate textbox not bound. put code in beforeupdate-event or change-event of surrogate. @ end should check final result isnumeric(). way surrogate textbox writes correct values bound hidden textbox , numbers arrive @ table.

an alternative change currency column string-field not wise because of potential wrong data in database.


Comments

Post a Comment

Popular posts from this blog

python - Mongodb How to add addtional information when aggregating? -

i beginner , wrote line pipeline works, wanna add other information output, screen name , or number of tweets.i tried add under $group gave me syntax error everytime here pipeline: def make_pipeline(): # complete aggregation pipeline pipeline = [ { '$match': { "user.statuses_count": {"$gt":99 }, "user.time_zone": "brasilia" } }, { "$group": { "_id": "$user.id", "followers": { "$max": "$user.followers_count" } } }, { "$sort": { "followers": -1 } }, { "$limit" : 1 } ]; i using on example : { "_id" : objectid("5304e2e3cc9e684aa98bef97"), "text" : "first week of school on :p", "in_reply_to_status_id" : null, "retweet_count" : null, ...
Read more

java - Spring Data JPA: Why findOne(id) executing delete query internally? -

i have 1 application using @manytomany annotation link 2 different entities 1 parent entity. not sure if have implemented properly. when execute .findone() on parent entity's repository find it, @ first fetch data along executing delete queries internally delete record mapping table (a table jpa creates after adding @manytomany annotation.). following generated sql queries , code snippet: java class @entity @table(name = "inventory") public class inventory { @id long id; // many other properties @manytomany(fetch=fetchtype.lazy) private list<stream> streams; @manytomany(fetch=fetchtype.lazy) private list<subject> subjects; } there no other annotation i've put in stream , subject entity class link inventory class. when run app, create following tables: inventory stream subject inventory_stream inventory_subject (inventory_stream , inventory_subject, 2 tables created automatically, don't k...
Read more

java - Incorrect order of records in M-M relationship in hibernate -

Image
i have 4 records in bridge table in mysql database. using @manytomany in hibernate, accurate order of employees incorrect incorrect of projects. following required material figure out doing mistake. this source. @entity @table(name="project") public class projectbean { @id @generatedvalue @column(name="project_id") private int projectid; @column(name="title") private string projecttitle; @manytomany(mappedby="projects") private collection<employeebean> employees; public projectbean() { employees = new arraylist<employeebean>(); } //getters & setters } @entity @table(name="employee") public class employeebean { @id @generatedvalue @column(name="employee_id") private int employee_id; @column(name="first_name") private string ...
Read more