Results 1 to 7 of 7
  1. #1
    Manoj is offline Novice
    Windows 10 Access 2007
    Join Date
    Feb 2018
    Posts
    4

    How to Name a Formula on Control Source in MS Access Report ?

    Need to name a formula in Control Source so, I can pull this name in Report and convert currency in word - Thanks everyone....Manoj

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Create a function in a standard module
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    Manoj is offline Novice
    Windows 10 Access 2007
    Join Date
    Feb 2018
    Posts
    4

    How to name a formula in Control Source

    Quote Originally Posted by ridders52 View Post
    Create a function in a standard module
    Hie,

    I need to know how to create a function in Standard Module.
    Please help.

    I have attached the screen shot....The TOTAL AMOUNT is calculated by a formula in Control source and I need to name it so, I can convert the currency in Words while pulling that name in a module.

    The module is ready but it doesn't accept a formula.

    Thanks
    Manoj
    Attached Thumbnails Attached Thumbnails Control Source Scr Shot.png  

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    The module is ready but it doesn't accept a formula.
    no reason why a module won't accept a formula. If for some reason it doesn't it would produce an error. show the code you do have in the module and the error being generated

  5. #5
    Manoj is offline Novice
    Windows 10 Access 2007
    Join Date
    Feb 2018
    Posts
    4

    Control Source Data issue resolved

    Quote Originally Posted by Ajax View Post
    no reason why a module won't accept a formula. If for some reason it doesn't it would produce an error. show the code you do have in the module and the error being generated
    Dear Sir Colin,
    Thank you very much....Problem is resolved

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You're welcome
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  7. #7
    Manoj is offline Novice
    Windows 10 Access 2007
    Join Date
    Feb 2018
    Posts
    4

    *

    Quote Originally Posted by ridders52 View Post
    You're welcome
    Thanks - Problem resolved very fast

Please reply to this thread with any new information or opinions.

Similar Threads

  1. #Name error on Report's Control Source
    By gaker10 in forum Reports
    Replies: 1
    Last Post: 11-14-2014, 10:43 AM
  2. Replies: 3
    Last Post: 05-03-2014, 03:26 AM
  3. Report Control Source Manipulation
    By justphilip2003 in forum Reports
    Replies: 15
    Last Post: 05-19-2013, 10:06 PM
  4. Two passes through report's control source?
    By GraeagleBill in forum Reports
    Replies: 2
    Last Post: 09-03-2012, 05:50 PM
  5. Replies: 2
    Last Post: 07-30-2009, 08:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums