Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

number into words expresion

Discussion in 'Information Technology' started by montse, Jul 28, 2006.

  1. montse

    montse
    Expand Collapse
    Guest

    hello, i need to entre an amount in my access form and then have it appear in
    words (exapmle- i entre 450, and in another field the words "fourhundred and
    fifity" appear). i am able to do this in excell with a formula i downloaded
    from http://xcell05.free.fr/ (excelente formuals!) i wonder if:
    A- i can "import" this formula to access
    B- if there ir a similar one in access
    C- if i can use the VBA instructions to write the expression out?

    thank you
     
  2. Loading...

    Similar Threads Forum Date
    Shabad Numbering System New to Sikhism Dec 1, 2015
    USA A Heart Attack And The Numbers Breaking News Aug 2, 2014
    Pacific Borneo: Sikhs small in number, strong in presence Breaking News Nov 11, 2013
    World Shrinking Numbers and Growing Persecution Threaten Sikhs and Hindus in Afghanistan Breaking News Nov 7, 2013
    SciTech Mammals pick offspring’s sex to maximize number of grandchildren, study shows Breaking News Jul 11, 2013

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Check http://www.mvps.org/access/modules/mdl0001.htm at "The Access Web"

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "montse" <montse@discussions.microsoft.com> wrote in message
    news:84DD2BED-AA80-4F95-8FB5-EBAC493BF154@microsoft.com...
    > hello, i need to entre an amount in my access form and then have it appear

    in
    > words (exapmle- i entre 450, and in another field the words "fourhundred

    and
    > fifity" appear). i am able to do this in excell with a formula i

    downloaded
    > from http://xcell05.free.fr/ (excelente formuals!) i wonder if:
    > A- i can "import" this formula to access
    > B- if there ir a similar one in access
    > C- if i can use the VBA instructions to write the expression out?
    >
    > thank you
     
  4. montse

    montse
    Expand Collapse
    Guest

    this looks great, the only thing is that i am working in spanish. do you know
    where i can get that code?
    the other question is, what do i do with this code? where do i put it?

    thank you very much,
    montse

    "Douglas J Steele" wrote:

    > Check http://www.mvps.org/access/modules/mdl0001.htm at "The Access Web"
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "montse" <montse@discussions.microsoft.com> wrote in message
    > news:84DD2BED-AA80-4F95-8FB5-EBAC493BF154@microsoft.com...
    > > hello, i need to entre an amount in my access form and then have it appear

    > in
    > > words (exapmle- i entre 450, and in another field the words "fourhundred

    > and
    > > fifity" appear). i am able to do this in excell with a formula i

    > downloaded
    > > from http://xcell05.free.fr/ (excelente formuals!) i wonder if:
    > > A- i can "import" this formula to access
    > > B- if there ir a similar one in access
    > > C- if i can use the VBA instructions to write the expression out?
    > >
    > > thank you

    >
    >
    >
     
  5. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Create a new module (make sure it's not a Class module), and copy everything
    between Code Start and Code End into that module. Do not name the module the
    same as the function that's in it (English in this case)

    I wouldn't think it would be that difficult to replace the English words in
    that function with the equivalent Spanish words.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "montse" <montse@discussions.microsoft.com> wrote in message
    news:9B9027C1-A707-41E4-9308-153B73E55579@microsoft.com...
    > this looks great, the only thing is that i am working in spanish. do you
    > know
    > where i can get that code?
    > the other question is, what do i do with this code? where do i put it?
    >
    > thank you very much,
    > montse
    >
    > "Douglas J Steele" wrote:
    >
    >> Check http://www.mvps.org/access/modules/mdl0001.htm at "The Access Web"
    >>
    >> --
    >> Doug Steele, Microsoft Access MVP
    >> http://I.Am/DougSteele
    >> (no e-mails, please!)
    >>
    >>
    >> "montse" <montse@discussions.microsoft.com> wrote in message
    >> news:84DD2BED-AA80-4F95-8FB5-EBAC493BF154@microsoft.com...
    >> > hello, i need to entre an amount in my access form and then have it
    >> > appear

    >> in
    >> > words (exapmle- i entre 450, and in another field the words
    >> > "fourhundred

    >> and
    >> > fifity" appear). i am able to do this in excell with a formula i

    >> downloaded
    >> > from http://xcell05.free.fr/ (excelente formuals!) i wonder if:
    >> > A- i can "import" this formula to access
    >> > B- if there ir a similar one in access
    >> > C- if i can use the VBA instructions to write the expression out?
    >> >
    >> > thank you

    >>
    >>
    >>
     
  6. montse

    montse
    Expand Collapse
    Guest

    ok, i will try that. thank you
    nesxt question: i am able to use this function in a form. but i need this
    inforamtion to feed into a table and i don't know how to do it. do you know?
    i am used to putting the name of the table field in which i want the info in
    the same spot where i have now written the formula. what should i do?
    thanks

    "Douglas J. Steele" wrote:

    > Create a new module (make sure it's not a Class module), and copy everything
    > between Code Start and Code End into that module. Do not name the module the
    > same as the function that's in it (English in this case)
    >
    > I wouldn't think it would be that difficult to replace the English words in
    > that function with the equivalent Spanish words.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no private e-mails, please)
    >
    >
    > "montse" <montse@discussions.microsoft.com> wrote in message
    > news:9B9027C1-A707-41E4-9308-153B73E55579@microsoft.com...
    > > this looks great, the only thing is that i am working in spanish. do you
    > > know
    > > where i can get that code?
    > > the other question is, what do i do with this code? where do i put it?
    > >
    > > thank you very much,
    > > montse
    > >
    > > "Douglas J Steele" wrote:
    > >
    > >> Check http://www.mvps.org/access/modules/mdl0001.htm at "The Access Web"
    > >>
    > >> --
    > >> Doug Steele, Microsoft Access MVP
    > >> http://I.Am/DougSteele
    > >> (no e-mails, please!)
    > >>
    > >>
    > >> "montse" <montse@discussions.microsoft.com> wrote in message
    > >> news:84DD2BED-AA80-4F95-8FB5-EBAC493BF154@microsoft.com...
    > >> > hello, i need to entre an amount in my access form and then have it
    > >> > appear
    > >> in
    > >> > words (exapmle- i entre 450, and in another field the words
    > >> > "fourhundred
    > >> and
    > >> > fifity" appear). i am able to do this in excell with a formula i
    > >> downloaded
    > >> > from http://xcell05.free.fr/ (excelente formuals!) i wonder if:
    > >> > A- i can "import" this formula to access
    > >> > B- if there ir a similar one in access
    > >> > C- if i can use the VBA instructions to write the expression out?
    > >> >
    > >> > thank you
    > >>
    > >>
    > >>

    >
    >
    >
     
  7. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Why would you put the words into a table? As fellow Access MVP John Vinson
    likes to say "Storing calculated data generally accomplishes only three
    things: it wastes disk space, it wastes time (a disk fetch is much slower
    than almost any reasonable calculation), and it risks data validity, since
    once it's stored in a table either the Total or one of the fields that goes
    into the total may be changed, making the value WRONG."

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "montse" <montse@discussions.microsoft.com> wrote in message
    news:CFA292D5-41DD-4A63-9E9E-18C3ADA27A84@microsoft.com...
    > ok, i will try that. thank you
    > nesxt question: i am able to use this function in a form. but i need this
    > inforamtion to feed into a table and i don't know how to do it. do you
    > know?
    > i am used to putting the name of the table field in which i want the info
    > in
    > the same spot where i have now written the formula. what should i do?
    > thanks
    >
    > "Douglas J. Steele" wrote:
    >
    >> Create a new module (make sure it's not a Class module), and copy
    >> everything
    >> between Code Start and Code End into that module. Do not name the module
    >> the
    >> same as the function that's in it (English in this case)
    >>
    >> I wouldn't think it would be that difficult to replace the English words
    >> in
    >> that function with the equivalent Spanish words.
    >>
    >> --
    >> Doug Steele, Microsoft Access MVP
    >> http://I.Am/DougSteele
    >> (no private e-mails, please)
    >>
    >>
    >> "montse" <montse@discussions.microsoft.com> wrote in message
    >> news:9B9027C1-A707-41E4-9308-153B73E55579@microsoft.com...
    >> > this looks great, the only thing is that i am working in spanish. do
    >> > you
    >> > know
    >> > where i can get that code?
    >> > the other question is, what do i do with this code? where do i put it?
    >> >
    >> > thank you very much,
    >> > montse
    >> >
    >> > "Douglas J Steele" wrote:
    >> >
    >> >> Check http://www.mvps.org/access/modules/mdl0001.htm at "The Access
    >> >> Web"
    >> >>
    >> >> --
    >> >> Doug Steele, Microsoft Access MVP
    >> >> http://I.Am/DougSteele
    >> >> (no e-mails, please!)
    >> >>
    >> >>
    >> >> "montse" <montse@discussions.microsoft.com> wrote in message
    >> >> news:84DD2BED-AA80-4F95-8FB5-EBAC493BF154@microsoft.com...
    >> >> > hello, i need to entre an amount in my access form and then have it
    >> >> > appear
    >> >> in
    >> >> > words (exapmle- i entre 450, and in another field the words
    >> >> > "fourhundred
    >> >> and
    >> >> > fifity" appear). i am able to do this in excell with a formula i
    >> >> downloaded
    >> >> > from http://xcell05.free.fr/ (excelente formuals!) i wonder if:
    >> >> > A- i can "import" this formula to access
    >> >> > B- if there ir a similar one in access
    >> >> > C- if i can use the VBA instructions to write the expression out?
    >> >> >
    >> >> > thank you
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     
  8. montse

    montse
    Expand Collapse
    Guest

    ok, well i find that comment both interesting a true. my situation is that i
    need to fill about 80 contracts that need to have the contract value in
    numbers AND in words (talk about wasting time!) so the idea is entering the
    basic information in a comfotable way (being access) and then use word's mail
    merge to pop everthing into the 7 page contract. unfourtunatly i can only
    mail merge from tables or queries. that is why i need the worded out number
    value in a table.
    if you know any other solution for this i would apreciate the input and also
    apreciate asitance so far.
    montse

    "Douglas J. Steele" wrote:

    > Why would you put the words into a table? As fellow Access MVP John Vinson
    > likes to say "Storing calculated data generally accomplishes only three
    > things: it wastes disk space, it wastes time (a disk fetch is much slower
    > than almost any reasonable calculation), and it risks data validity, since
    > once it's stored in a table either the Total or one of the fields that goes
    > into the total may be changed, making the value WRONG."
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no private e-mails, please)
    >
    >
    > "montse" <montse@discussions.microsoft.com> wrote in message
    > news:CFA292D5-41DD-4A63-9E9E-18C3ADA27A84@microsoft.com...
    > > ok, i will try that. thank you
    > > nesxt question: i am able to use this function in a form. but i need this
    > > inforamtion to feed into a table and i don't know how to do it. do you
    > > know?
    > > i am used to putting the name of the table field in which i want the info
    > > in
    > > the same spot where i have now written the formula. what should i do?
    > > thanks
    > >
    > > "Douglas J. Steele" wrote:
    > >
    > >> Create a new module (make sure it's not a Class module), and copy
    > >> everything
    > >> between Code Start and Code End into that module. Do not name the module
    > >> the
    > >> same as the function that's in it (English in this case)
    > >>
    > >> I wouldn't think it would be that difficult to replace the English words
    > >> in
    > >> that function with the equivalent Spanish words.
    > >>
    > >> --
    > >> Doug Steele, Microsoft Access MVP
    > >> http://I.Am/DougSteele
    > >> (no private e-mails, please)
    > >>
    > >>
    > >> "montse" <montse@discussions.microsoft.com> wrote in message
    > >> news:9B9027C1-A707-41E4-9308-153B73E55579@microsoft.com...
    > >> > this looks great, the only thing is that i am working in spanish. do
    > >> > you
    > >> > know
    > >> > where i can get that code?
    > >> > the other question is, what do i do with this code? where do i put it?
    > >> >
    > >> > thank you very much,
    > >> > montse
    > >> >
    > >> > "Douglas J Steele" wrote:
    > >> >
    > >> >> Check http://www.mvps.org/access/modules/mdl0001.htm at "The Access
    > >> >> Web"
    > >> >>
    > >> >> --
    > >> >> Doug Steele, Microsoft Access MVP
    > >> >> http://I.Am/DougSteele
    > >> >> (no e-mails, please!)
    > >> >>
    > >> >>
    > >> >> "montse" <montse@discussions.microsoft.com> wrote in message
    > >> >> news:84DD2BED-AA80-4F95-8FB5-EBAC493BF154@microsoft.com...
    > >> >> > hello, i need to entre an amount in my access form and then have it
    > >> >> > appear
    > >> >> in
    > >> >> > words (exapmle- i entre 450, and in another field the words
    > >> >> > "fourhundred
    > >> >> and
    > >> >> > fifity" appear). i am able to do this in excell with a formula i
    > >> >> downloaded
    > >> >> > from http://xcell05.free.fr/ (excelente formuals!) i wonder if:
    > >> >> > A- i can "import" this formula to access
    > >> >> > B- if there ir a similar one in access
    > >> >> > C- if i can use the VBA instructions to write the expression out?
    > >> >> >
    > >> >> > thank you
    > >> >>
    > >> >>
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >
     
  9. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Assuming that you're calling the query from within Access (as opposed, say,
    to a VB program or an ASP page), queries can call functions.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "montse" <montse@discussions.microsoft.com> wrote in message
    news:7AC43369-AA55-4CA8-9BEE-5F1E01A8B1EF@microsoft.com...
    > ok, well i find that comment both interesting a true. my situation is that
    > i
    > need to fill about 80 contracts that need to have the contract value in
    > numbers AND in words (talk about wasting time!) so the idea is entering
    > the
    > basic information in a comfotable way (being access) and then use word's
    > mail
    > merge to pop everthing into the 7 page contract. unfourtunatly i can only
    > mail merge from tables or queries. that is why i need the worded out
    > number
    > value in a table.
    > if you know any other solution for this i would apreciate the input and
    > also
    > apreciate asitance so far.
    > montse
    >
    > "Douglas J. Steele" wrote:
    >
    >> Why would you put the words into a table? As fellow Access MVP John
    >> Vinson
    >> likes to say "Storing calculated data generally accomplishes only three
    >> things: it wastes disk space, it wastes time (a disk fetch is much slower
    >> than almost any reasonable calculation), and it risks data validity,
    >> since
    >> once it's stored in a table either the Total or one of the fields that
    >> goes
    >> into the total may be changed, making the value WRONG."
    >>
    >> --
    >> Doug Steele, Microsoft Access MVP
    >> http://I.Am/DougSteele
    >> (no private e-mails, please)
    >>
    >>
    >> "montse" <montse@discussions.microsoft.com> wrote in message
    >> news:CFA292D5-41DD-4A63-9E9E-18C3ADA27A84@microsoft.com...
    >> > ok, i will try that. thank you
    >> > nesxt question: i am able to use this function in a form. but i need
    >> > this
    >> > inforamtion to feed into a table and i don't know how to do it. do you
    >> > know?
    >> > i am used to putting the name of the table field in which i want the
    >> > info
    >> > in
    >> > the same spot where i have now written the formula. what should i do?
    >> > thanks
    >> >
    >> > "Douglas J. Steele" wrote:
    >> >
    >> >> Create a new module (make sure it's not a Class module), and copy
    >> >> everything
    >> >> between Code Start and Code End into that module. Do not name the
    >> >> module
    >> >> the
    >> >> same as the function that's in it (English in this case)
    >> >>
    >> >> I wouldn't think it would be that difficult to replace the English
    >> >> words
    >> >> in
    >> >> that function with the equivalent Spanish words.
    >> >>
    >> >> --
    >> >> Doug Steele, Microsoft Access MVP
    >> >> http://I.Am/DougSteele
    >> >> (no private e-mails, please)
    >> >>
    >> >>
    >> >> "montse" <montse@discussions.microsoft.com> wrote in message
    >> >> news:9B9027C1-A707-41E4-9308-153B73E55579@microsoft.com...
    >> >> > this looks great, the only thing is that i am working in spanish. do
    >> >> > you
    >> >> > know
    >> >> > where i can get that code?
    >> >> > the other question is, what do i do with this code? where do i put
    >> >> > it?
    >> >> >
    >> >> > thank you very much,
    >> >> > montse
    >> >> >
    >> >> > "Douglas J Steele" wrote:
    >> >> >
    >> >> >> Check http://www.mvps.org/access/modules/mdl0001.htm at "The Access
    >> >> >> Web"
    >> >> >>
    >> >> >> --
    >> >> >> Doug Steele, Microsoft Access MVP
    >> >> >> http://I.Am/DougSteele
    >> >> >> (no e-mails, please!)
    >> >> >>
    >> >> >>
    >> >> >> "montse" <montse@discussions.microsoft.com> wrote in message
    >> >> >> news:84DD2BED-AA80-4F95-8FB5-EBAC493BF154@microsoft.com...
    >> >> >> > hello, i need to entre an amount in my access form and then have
    >> >> >> > it
    >> >> >> > appear
    >> >> >> in
    >> >> >> > words (exapmle- i entre 450, and in another field the words
    >> >> >> > "fourhundred
    >> >> >> and
    >> >> >> > fifity" appear). i am able to do this in excell with a formula i
    >> >> >> downloaded
    >> >> >> > from http://xcell05.free.fr/ (excelente formuals!) i wonder if:
    >> >> >> > A- i can "import" this formula to access
    >> >> >> > B- if there ir a similar one in access
    >> >> >> > C- if i can use the VBA instructions to write the expression out?
    >> >> >> >
    >> >> >> > thank you
    >> >> >>
    >> >> >>
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     

Share This Page