MS Access Built-In Functions in Query Builder RRS feed

  • Question

  • Question: How can I get Access 2013 to recognize Access 2007 built-in functions (i.e.: Format () ) in the query builder?

    In VBA, I add the library prefix to the code (i.e.: VBA Format () ) to use the built-in functions, but this does not work in the query builder.

    • Moved by Mike Kinsman Tuesday, September 3, 2013 4:39 PM off topic
    Friday, August 30, 2013 10:42 PM

All replies

  • There must be an access related forum where you can get the answer to this question.  For some reason, the TechNet Website Feedback forum is a catch all for everything not related to TechNet's website.    There is an access developer forum here on MSDN's forum: http://social.msdn.microsoft.com/Forums/en-us/home?forum=accessdev&filter=alltypes&sort=lastpostdesc    Thanks - Mike

    Unfortunately your post is off topic here, in the TechNet Site Feedback forum, because it is not Feedback about the TechNet Website or Subscription.  This is a standard response I’ve written up in advance to help many people (thousands, really.) who post their question in this forum in error, but please don’t ignore it.  The links I share below I’ve collected to help you get right where you need to go with your issue.

    For technical issues with Microsoft products that you would run into as an end user of those products, one great source of info and help is http://answers.microsoft.com, which has sections for Windows, Hotmail, Office, IE, and other products. Office related forums are also here: http://office.microsoft.com/en-us/support/contact-us-FX103894077.aspx

    For Technical issues with Microsoft products that you might have as an IT professional (like technical installation issues, or other IT issues), you should head to the TechNet Discussion forums at http://social.technet.microsoft.com/forums/en-us, and search for your product name.

    For issues with products you might have as a Developer (like how to talk to APIs, what version of software do what, or other developer issues), you should head to the MSDN discussion forums at http://social.msdn.microsoft.com/forums/en-us, and search for your product or issue.

    If you’re asking a question particularly about one of the Microsoft Dynamics products, a great place to start is here: http://community.dynamics.com/

    If you really think your issue is related to the subscription or the TechNet Website, and I screwed up, I apologize!  Please repost your question to the discussion forum and include much more detail about your problem, that could include screenshots of the issue (do not include subscription information or product keys in your screenshots!), and/or links to the problem you’re seeing. 

    If you really had no idea where to post this question but you still posted it here, you still shouldn’t have because we have a forum just for you!  It’s called the Where is the forum for…? forum and it’s here: http://social.msdn.microsoft.com/forums/en-us/whatforum/

    Moving to off topic. 

    Thanks, Mike

    MSDN and TechNet Subscriptions Support
    Read the Subscriptions Blog!

    Tuesday, September 3, 2013 4:39 PM