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. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
how do i set access to use fractions and add/multiply them?
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 |
#22
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|