A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how do i set access to use fractions and add/multiply them?



 
 
Thread Tools Display Modes
  #22  
Old June 30th, 2007, 01:44 AM posted to microsoft.public.access.forms
KevinKBM
external usenet poster
 
Posts: 14
Default how do i set access to use fractions and add/multiply them?

there is not enuff space where the fractions are entered to use the combo
boxes. can a single or 3 text boxes be used?

"Steve" wrote:

Look back at the tables I suggested. Look at TblFractionPart.
DecimalOfFractionPart gives you the decimal.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications





"KevinKBM" wrote in message
...
STOP THE PRESSES!!

Ok i now have the text boxes accepting fractions.
and that gave me a idea.

in After Update will it work if i had it convert the fraction (in text) to
decimal, then send that to a query to do the math in and then have that
report the rounded up total to the final box?

that should make things far more simple.
the converter will have to read a text based fraction, in the format of
(##/##)

think that will work? and if so, how do i do it?
thats everybody you have all be most helpful




  #23  
Old June 30th, 2007, 02:59 PM posted to microsoft.public.access.forms
jrmask via AccessMonster.com
external usenet poster
 
Posts: 8
Default how do i set access to use fractions and add/multiply them?

I do this for corrugated sheets to fiqure board feet. I use fractions for the
calculations and taught my people to use them by suppling a conversion sheet.
Now they enter 1.75 for 1 3/4 inches or 5.625 for 5 5/8. Most do not have to
look at the conversion chart any longer. =([txtLenght] * [txtwidth]) /144



KevinKBM wrote:
going to be calculating board feet, the formula is WxL \ 144 (11 7/8 x 12 7/8
Divided by 144 and the rusult will be shown in a seprit text box . I can send
you the DB if that will help.

Show me how you are going to apply a measurement that includes fractions and
maybe I can help you from there. For example, your measurement is 125 5/8",

[quoted text clipped - 74 lines]
ba
able to add, multiply and divide them.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200706/1

  #24  
Old July 5th, 2007, 02:16 PM posted to microsoft.public.access.forms
KevinKBM
external usenet poster
 
Posts: 14
Default how do i set access to use fractions and add/multiply them?

That would be a simple solution, however this will be used not only by the
workers here but by our clients when they come in to the office and place
orders on site.
and possibly on the road with our sales people.


"jrmask via AccessMonster.com" wrote:

I do this for corrugated sheets to fiqure board feet. I use fractions for the
calculations and taught my people to use them by suppling a conversion sheet.
Now they enter 1.75 for 1 3/4 inches or 5.625 for 5 5/8. Most do not have to
look at the conversion chart any longer. =([txtLenght] * [txtwidth]) /144



KevinKBM wrote:
going to be calculating board feet, the formula is WxL \ 144 (11 7/8 x 12 7/8
Divided by 144 and the rusult will be shown in a seprit text box . I can send
you the DB if that will help.

Show me how you are going to apply a measurement that includes fractions and
maybe I can help you from there. For example, your measurement is 125 5/8",

[quoted text clipped - 74 lines]
ba
able to add, multiply and divide them.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200706/1


  #25  
Old July 5th, 2007, 09:05 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default how do i set access to use fractions and add/multiply them?

On Thu, 28 Jun 2007 11:12:03 -0700, KevinKBM
wrote:

going to be calculating board feet, the formula is WxL \ 144 (11 7/8 x 12 7/8
Divided by 144 and the rusult will be shown in a seprit text box . I can send
you the DB if that will help.


Kevin, did you ever get this working? I really think that the function I
posted will let you do so. Please let me know if you're having trouble
implementing it and if I can help get it working.

John W. Vinson [MVP]
  #26  
Old July 9th, 2007, 03:50 PM posted to microsoft.public.access.forms
KevinKBM
external usenet poster
 
Posts: 14
Default how do i set access to use fractions and add/multiply them?

OK looks like i won't get the mathmatics i need to work in Access directly.
so how do i tell a imbeded Excel sheet to lookup information from a access
text field?

"KevinKBM" wrote:

I need to use fractions in a Access Form to calculate sq foot and other board
dimentions. can't find anything in the help file or settings. I need to ba
able to add, multiply and divide them.

  #27  
Old July 9th, 2007, 04:52 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default how do i set access to use fractions and add/multiply them?

On Mon, 9 Jul 2007 07:50:01 -0700, KevinKBM
wrote:

OK looks like i won't get the mathmatics i need to work in Access directly.


You CAN get the mathmatics you need to work in Access directly. Did you try my
function? IT WILL WORK.

If you tried and had problems, please post what you did and what problem you
had.

John W. Vinson [MVP]
  #28  
Old July 9th, 2007, 05:48 PM posted to microsoft.public.access.forms
KevinKBM
external usenet poster
 
Posts: 14
Default how do i set access to use fractions and add/multiply them?

ok the fields where fractions will be used are named "width## and Height##"
where ## are numbered 01 to 41. there will be several lines on the order
form where this will be done. the error i get is telling me the number i
enter is to large for the field (5 7/8) the error reads "The Value you
entered isn't valid for this field" "For example, you may have entered text
in a numeric field or a number that is larger then the Field Size setting
permits."

I placed your code in a public module and named it "fractonum"
the field properties are as follows

Name width01
controle source (blank)
Format Scientific
Decimal Places Auto
Input Mask (blank)


"John W. Vinson" wrote:

On Mon, 9 Jul 2007 07:50:01 -0700, KevinKBM
wrote:

OK looks like i won't get the mathmatics i need to work in Access directly.


You CAN get the mathmatics you need to work in Access directly. Did you try my
function? IT WILL WORK.

If you tried and had problems, please post what you did and what problem you
had.

John W. Vinson [MVP]

  #29  
Old July 9th, 2007, 07:09 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default how do i set access to use fractions and add/multiply them?

On Mon, 9 Jul 2007 09:48:04 -0700, KevinKBM
wrote:

ok the fields where fractions will be used are named "width## and Height##"
where ## are numbered 01 to 41.


Then your table design IS WRONG.

"Fields are expensive, records are cheap". If you have 41 sets of dimensions,
you'll someday have 42. You should have the data stored in a second table,
with one set of dimensions per record, rather then per field.

It may be that you're starting your database design with the form (perhaps
imitating a paper form?); if so, that's the wrong end about. You wouldn't
start building a house frame before you've poured the foundations - and a
properly normalized set of Tables is the foundation of your database! The
forms come later.

there will be several lines on the order
form where this will be done. the error i get is telling me the number i
enter is to large for the field (5 7/8) the error reads "The Value you
entered isn't valid for this field" "For example, you may have entered text
in a numeric field or a number that is larger then the Field Size setting
permits."


I placed your code in a public module and named it "fractonum"


Change the name of the module. It must have a name *DIFFERENT* from the name
of the function. I'd just call it basFracToNum.

You need TWO TEXTBOXES - one, probably unbound, let's call it txtWidth; and
the other bound to a Number field in your table, let's call it txtNumWidth.
Put the following code in the AfterUpdate event of txtWidth:

Private Sub txtWidth_AfterUpdate()
Me!txtNumWidth = FracToNum(Me!txtWidth)
End Sub

Or, if you want to *store* the 12 15/16 text string in your table, change the
datatype of the Width field (or fields, if you really insist on using a VERY
BADLY FLAWED design) from Number to Text; you can *display* the decimal size
by setting the control source of a textbox (unbound) to

=FracToNum([txtWidth])

However, I'd stick with the number field in your table - one width and one
height per record NOT 41 of them! You're using a relational database, not a
spreadsheet!

John W. Vinson [MVP]
  #30  
Old July 9th, 2007, 07:57 PM posted to microsoft.public.access.forms
Steve[_10_]
external usenet poster
 
Posts: 608
Default how do i set access to use fractions and add/multiply them?

Kevin,

I offered to help you and you let Douglas Steele sway you from the
opportunity of getting the help you want!

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications





"KevinKBM" wrote in message
...
OK looks like i won't get the mathmatics i need to work in Access
directly.
so how do i tell a imbeded Excel sheet to lookup information from a access
text field?

"KevinKBM" wrote:

I need to use fractions in a Access Form to calculate sq foot and other
board
dimentions. can't find anything in the help file or settings. I need to
ba
able to add, multiply and divide them.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:12 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.