Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Save a number in Access Table

Posted on 2014-01-14
2
Medium Priority
?
409 Views
Last Modified: 2014-01-14
Is it possible to enter a numeric value in a form and have access save the value multiplied by 2 on it's table. Not having the actual value that was entered stored on any table... the saved value would be the number on the form times two.

Thanks!

Chris
0
Comment
Question by:cansevin
2 Comments
 
LVL 22

Accepted Solution

by:
Kelvin Sparks earned 2000 total points
ID: 39781250
Yes, create a field that is not bound to any field in the table. have a second invisible field that is bound to your actual field that you want value saved in. The on the form fields after update event use something like

If IsNumeric(Me.fieldname) then
    me.actualfield = me.fieldname*2
Else
   MsgBox "The value you entered is not numeric", vbOK, "Invalid Entry"
End IF


Kelvin
0
 

Author Comment

by:cansevin
ID: 39781255
Thanks Kelvin!
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Implementing simple internal controls in the Microsoft Access application.
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question