Enabling Decimals And Fractions In MS ACCESS
Feb 17, 2007
I am trying to develop a customized program in MS Access,
but one of the input parameters needs to be a decimal or
fraction (ie: I need to enter values that are not whole number
integers). Unfortunately, it seems that MS Access won't
enable me to input values that are not whole number integers.
I had this same difficulty in the past, and in that case, it turned out that the non-integer value was not used. But in
the current program I'm trying to develop, I definitely need
to get the non-integer data inputting to work, since the
parameter that I'm entering these values for is "percentage".
It turns out that if I enter a value from 0.51 to 1, it rounds
up to 100%, and if I enter a value that's 0.5 or lower, it rounds down to 0%. There is no in-between. I tried looking
into the various settings in DESIGN mode, but nothing seems
to correct this problem. Is there anyone out there reading
this that has insight into my problem? Could my version of
MS Access have a software corruption? Or is there just a
setting that I've overlooked? I appreciate any advice that
can be offered. Thanks for your help.
View Replies
ADVERTISEMENT
Apr 25, 2005
Good morning, Can sks oblige me by telling how I can enter a fration (eg three quarters0 in a table please
Terry
View 2 Replies
View Related
Jul 11, 2006
Hi Guys,
I have just finished a DB in access, so I went into options and disabled all menus and shortcuts (I wanted to make it foolproof, this DB is for my mum!).
Anyway, it turns out that I wasn’t completely finished, and now I want to make a change to the DB. How can I do this?
Please view the screenshot, it shows which menus are/aren't enabled. I have explored all of the menus and I cant think of anything.
View 2 Replies
View Related
Jan 17, 2006
Hi - my first post on this newly discovered forum..
I hope you'll bear with me as I'm quite the noob concerning programming etc..
My question is simple, I know that there are some kind of program or plugin or whatever it is, enabling a user to input data into a MS Access Database without having MS Access installed. But what is it? where can I find it? and how is it done?
Hope you guys can help :)
(hope this is the proper section for this question, if not I'm sorry :o )
View 4 Replies
View Related
Jun 12, 2014
In my database (access 2007) I have code similar to this
Dim Ulaz As String, Izlaz As String, UkKol As String, UkFin As String
and at the end of the code I have this
Me.NC = UkFin / UkKol
Me.NC respresents avaerage price.
If for result I have 0.498 value, I would like for that value to be shown as 0.50. In another words, it must be rounded to two places.
How can I do that in VB? That value will be passed to NC field on Form, however..
View 2 Replies
View Related
Apr 24, 2013
I have the following query, which I simplied to show only the WHERE clouse.
Code:
WHERE ((([Using our own appt date].PrblDiagCode) Like "519" Or ([Using our own appt date].PrblDiagCode)="414" Or ([Using our own appt date].PrblDiagCode)="428" Or ([Using our own appt date].PrblDiagCode)="250" Or ([Using our own appt date].PrblDiagCode)="430" Or ([Using our own appt date].PrblDiagCode)="585" Or ([Using our own appt date].PrblDiagCode)="573"));
Is there any way to also include the ones with fractions? For example, a record can be 519.3. I find that the current code doesn't give me the ones with fractions. What needs to change in the query?
View 1 Replies
View Related
Jun 10, 2014
I haven't created classes in a while, and I don't see what is the problem
I'm modifying a function to get fractions from double. It worked well, but it returned a string.
I need it to be in parts, so I created this class
Code:
Option Compare Database
Public Entier As Integer
Public nominateur As Integer
Public denominateur As Integer
Public Function getText()
getText = Entier & " " & nominateur & "/" & denominateur
End Function
I changed the function type and the assignation:
Code:
Function GetFraction(ByVal Num As Double) As nombreEnFraction
Set GetFraction = New nombreEnFraction
If Num = 0# Then
GetFraction = "None"
Else
Dim WholeNumber As Integer
Dim DecimalNumber As Double
[Code] ....
For some reasons, when I get to the end of the function, I get a 91 error, like if it was nothing
But when I use a spy, I see values in the object until the end.
View 1 Replies
View Related
Jan 17, 2008
I'm by no means an expert when it comes to using access and its many controls that are avaliable to use on forms. Thats why I've come here to seek your help.
I have a database that has been created by someone who has now left the company and it needs a little work done to it.
The ideal thing we would like to get working on form, is that we would like a number of options to be greyed out and only accessable when another option is ticked.
I'm not sure how to group these options together, nor an I sure how make them active only when an specific tick box is ticked. Any help would greatly appreciated on this matter.
Thanks for your time and patience.
Menes.
View 5 Replies
View Related
Mar 10, 2005
Working in the theatreworld, I'm trying to create something which will usefully combine my contacts and also a database of which shows we have done (dates, actors involved etc, etc) and what shows we have bought in.
So far, I have created my form which has the usual fields (name, address and so on) and also a field which asks users to describe what type of contact they are ie. are they an actor, or a director, or a theatre company.
There are also two command buttons, which will either open up another form which lists all the productions they have been in with us over the years (In-house productions), or one that opens up another form which lists what shows each theatre company has brought to us.
I would like to be able to select 'actor' in the category field which will then enable the command button for me to see what productions that person has been in. Or if I selected the 'theatre company' category then the other button becomes enabled.
Can anybody advise me on this please? Alternatively, if this all sounds far too convoluted, then I am open to suggestions!
Many thanks in advance,
Popps
View 1 Replies
View Related
Oct 1, 2005
Hi all,
I was just wondering if it is difficult to enable a cmd button when a text box has been filled in. I have a button that allows users to add a file which displays the filepath in a text box. So what I wanted to do was when the path appears in the text box then this will enable the button. I thought that It may have been something like
Private Sub FilePath_Change()
cmdOpen.Enabled = True
End Sub
but as usual i was wrong lol
Anyone got any advice on this , thanks
J
View 1 Replies
View Related
Oct 9, 2005
I have code set up to disable a textbox by clicking on it (Yes, that right, I want the textbox disabled as soon as it is clicked on) with Me.Txt.enabled = false during the _onClick Event.
However, the with which I am working has 500 textboxes. Is there a way to call a function or something that would disable just the textbox that is clicked on?
View 2 Replies
View Related
Nov 8, 2005
I want a form to default open in read only mode to avoid users deleting info. I want them to be able to edit the form by pressing a button. Does anyone know the VB code to run from a command button to do this.
Regards :confused:
View 6 Replies
View Related
Nov 26, 2005
what's wrong with this Code ?!
Private Sub Form_Current()
If Date = Null Then
Forms!getorder![Orders].Form.ProductID.Enabled = True
Else
Forms!getorder![Orders].Form.ProductID.Enabled = False
End If
End Sub
getorder is a Form
Orders is a Subforms
i want to do something that if i didn't entered a text in a date field hole subforms or Product id will be Disable
but if any texts enterd in Date Field it will be Enabled
thanks
View 1 Replies
View Related
Nov 28, 2005
hi, there is this form i want to create which uses a drop down list.... i want to be able to auto enable and disable selective fields upon selecting one of the choices.
e.g. in a drop down list containing: choice 1, choice 2 and choice 3
and there are the fields field no. 1, field no. 2 and field no.3
If i select Choice 1 --> field no. 1 get enabled and the other 2 gets disable... so on and so forth....
How do i go about doing this?
View 1 Replies
View Related
Jan 22, 2006
Hi, I have a field in a form that says when you are able to book a certain event, and i want the field in which the event can be booked, to remain unable to be edited until the tick box says yes. Is that possible?
Chris
View 4 Replies
View Related
Aug 22, 2006
Hey,
In the form I am creating, I have checkboxes. Some of these checkboxes, when ticked, need additional comments entered into a comments box.
Only when the box is ticked, the comments box should appear/become enabled.
Any pointers in the general direction I should help would be greatly appreciated.
Thanks.
View 6 Replies
View Related
Mar 14, 2007
Hi, I have a form called Product Details Display Form, which is for Product Details Display table. This form contains a button "Done" which saves everything into the table, or in other words, bounds the unbounded textboxes to the table. Basically, I want this button to be disabled at the begining, when the form loads, and when the user enters ALL the fields, it becomes enabled. Here is the code I have at the moment:
Private Sub Form_DataChange(ByVal Reason As Long)
If Me.Product_Brand = Null Or Me.Product_Code = Null Or Me.Product_Name = Null Or Me.List34 = Null Or Me.Price = Null Or Me.Details = Null Or Me.Discount = Null Or Me.Combo0 = Null Or Me.Combo2 = Null Then
Me.Command36.Enabled = False
Else
Me.Command36.Enabled = True
End If
End Sub
I also have Me.Command36.Enabled = False in the Form-Load. I dont really know if it has to be in Private Sub Form_DataChange or not.
Please help me ASAP
Thanx in Advance
View 4 Replies
View Related
Sep 11, 2006
Hi i have done this before but can not remeber how i did this.
Basically i am doing a report function where users can choose which type of report they want to print- i am decided to use a radio button function so user have to click on the radio button to enable which report they want to view
(see pic) http://img153.imageshack.us/my.php?image=radiobuttonstu8.jpg
Can some1 help me with the code i need to use so when a user clicks on the radio button one combo box is enabled and the other is disabled
Many thanks in advance
View 3 Replies
View Related
Aug 30, 2004
I have two text boxes and a check box - so the user can enter (1) patient weight, (2) patient height and then check whether the patient is male or female. The first two are then used to calculate a Body Mass Index. (simple enough and works OK). What I then want to do is have four command buttons that become visible when the calculation is within a certain range. So - simplistically- if the calculation (calctxtbox) is between 0 and 5 AND the patient is female then the command button called "normal"(Command79) is enabled.
My VB code writing is improving (thanks largely to this forum!) but still very basic - can some-one help please?
Do I put my code in the "after update" event of the calctxtbox?
Private Sub calctxtbox_AfterUpdate()
If calctxtbox > 0 (How do I say and <5) and then how do I say Female =Yes Then
Command79.Enabled = True
End Sub
Am I close?
Also can you enable labels and text boxes or just buttons.
View 4 Replies
View Related
Jan 26, 2005
Hi all,
This is a simple question i think, but how do i enable my drop down menu to work for a combo box. I have a search query bound to a form and the combo box bound to a field of that query. At present my query just display the first record for any search result from my query on the combo box.
Thanks in advance,
M-.
View 10 Replies
View Related
Aug 31, 2005
Hello,I was wondering if anybody knew if it was posslble to show an aproximated value of a field with decimal records. I would like to see only integer values on my form.
View 3 Replies
View Related
Oct 27, 2005
I have a field that holds a unit price. I can't use currency as the data type because the currency type is different for each client. I have another field that specifies the currency type for each department. Up to now I've been using a double format with a 2 decimal places. We now need to increase the decimal places to 4 but don't necessarily want to see all four places if only 2 are required - 1.5000 against 1.50. However if I make the decimals as auto, if I have 1.50 it rounds to 1.5.
Any other way to give a bit of flexibility to this?
Thanks.
Dawn
View 8 Replies
View Related
Feb 23, 2005
I am trying to round decimals to either .5 or 0 right now i have it set to 1 decimal place and it rounds to to the next place. So if a user puts in 1.23 it would round to 1.2 instead of 1.0, is there a simple way to solve this issue?
View 1 Replies
View Related
Oct 18, 2012
Is it possible to return an age as: 21.45 or 64.93?
I have done some searching and can't find any formatting or code to make it work.
I have changed the field format to Fixed and then it gives: 21.00 or 64.00
I like the 2 decimal places for quick at-a-glance-knowing of the age.
Of course I have a formula that returns an age with decimals in EXCEL, that's why I think it should somehow be possible in Access.
View 1 Replies
View Related
May 16, 2005
Hi,
Is it possible to enable and disable fields on a form with another field that is a check box?
i.e. a text box is greyed out until a check box is ticked.
Any help is appreciated,
Cheers,
Phil
View 1 Replies
View Related
Jun 27, 2005
Hello,
I've recently been told how to enable/disable fields in a form by ticking/unticking a box. Is there a way that, on a tabulated form, i can only disable/enable the field for the same record as the one the check box is in rather than for every record?
Any help will be greatly appreciated.
Thanks,
Phil
View 2 Replies
View Related
