Solved

Access 2010 Entering Percent Value

Posted on 2011-03-04
10
1,143 Views
Last Modified: 2012-08-13
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?
0
Comment
Question by:dleads
  • 5
  • 4
10 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 35035820
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"
0
 

Author Comment

by:dleads
ID: 35036283
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?
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 35036289
..and, set the field ( control source of the textbox)  Field size property to double or single
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 35036318
<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?
0
 

Author Comment

by:dleads
ID: 35036373
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?
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 119

Expert Comment

by:Rey Obrero
ID: 35036454
< 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)
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35058505
<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)
0
 

Accepted Solution

by:
dleads earned 0 total points
ID: 36421072
Apparently there is a setting on the local machines that control the way you enter percents.
0
 

Author Closing Comment

by:dleads
ID: 36445938
My questiion was not answered.
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 36446707
dleads,

could you elaborate, which setting on the local machines was altered ?
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

706 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now