Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Access 2010 Entering Percent Value
Posted on 2011-03-04
Where would I find the Access setting to adjust how a percent value is added on a form?
One user enters 20 in a percent field and gets the value of 20%
Another user enters 20 in the same field of the same form and gets a value of 2000%
The percent field in the form is formated as a percent with auto in the decimal places
Is there a global setting that I've missed?
One user enters 20 in a percent field and gets the value of 20%
Another user enters 20 in the same field of the same form and gets a value of 2000%
The percent field in the form is formated as a percent with auto in the decimal places
Is there a global setting that I've missed?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5-
4
10 Comments
Active 3 days ago
in the after update event of the textbox,
private sub text0_afterupdate()
me.text0=me.text0/100
end sub
set the format property of the textbox to "Percent"
private sub text0_afterupdate()
me.text0=me.text0/100
end sub
set the format property of the textbox to "Percent"
I am aware of this option, but my question is there a global setting?
Why would one user be able to enter 20 and get 20 and another user enter 20 and get 2000?
Why would one user be able to enter 20 and get 20 and another user enter 20 and get 2000?
Active 3 days ago
..and, set the field ( control source of the textbox) Field size property to double or single
Active 3 days ago
<Why would one user be able to enter 20 and get 20 and another user enter 20 and get 2000?>
are the two pc in the same location?
are they using the same database?
is your database application split, BE and FE?
are the two pc in the same location?
are they using the same database?
is your database application split, BE and FE?
It is on a terminal server. Access 2010 is the front end and SQL is the backend.
Each user has to set their Access options individually. Is there a setting in the options that determines how it handles entries of percents?
Each user has to set their Access options individually. Is there a setting in the options that determines how it handles entries of percents?
Active 3 days ago
< Is there a setting in the options that determines how it handles entries of percents?>
i don't think there is such option.(as far as i know)
i don't think there is such option.(as far as i know)
<Access 2010 is the front end and SQL is the backend.
Each user has to set their Access options individually....Each user has to set their Access options individually>
That does not directly answer his question...
Does each use having their own copy of the font end installed of their local machine?
(Not "sharing" the front end)
Each user has to set their Access options individually....Each user has to set their Access options individually>
That does not directly answer his question...
Does each use having their own copy of the font end installed of their local machine?
(Not "sharing" the front end)
Featured Post
Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month6 days, left to enroll
626 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.