Results 1 to 6 of 6
  1. #1
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231

    Is there a way to get =Now() to print in Spanish?


    I have letters that need to go out in either English or Spanish. While the rest of the Spanish letter is in Spanish, the date, (=Now()) in the footer, is in English. Is there a way to get =Now() to print in Spanish?

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Try Googling Spanish to English =ahora()

    HTH

  3. #3
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231
    I dont need a translation, I need to know if MS Office has the Spanish equivilent of "=Now()" for use in headers or footers in MS Office 2010 (English version)? Oh, and this is not Dave.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    As far as I know, the Spanish translation for "=Now()" is "=Now()". I have seen some IDE's that convert VB6, etc to languages other than English. Don't know if anything like that is available for VBA. Maybe you can search for a "Spanish IDE add in for Access".

    As for "=Now()" appearing in the footer, I do not know what that means.

  5. #5
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231
    =Now() generates a date in the form of "Friday, May 2, 2014" in headers and footers of reports for Access, Excel and Word and I'm sure in the other Office products as well.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    =Now() is an expression that Access will evaluate and return:

    5/2/2014 11:58:42 AM

    How would that be different in Spanish?

    =Format(Now(),"Long Date") will return:

    Friday, May 02, 2014

    If you want that to return in Spanish then maybe need to select Spanish as the language setting for db in Options.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 6
    Last Post: 03-01-2014, 07:07 AM
  2. Replies: 1
    Last Post: 12-03-2012, 03:15 PM
  3. Replies: 5
    Last Post: 10-26-2011, 02:59 PM
  4. Replies: 0
    Last Post: 02-22-2011, 05:04 AM
  5. Translate English to Spanish
    By marge0513 in forum Import/Export Data
    Replies: 0
    Last Post: 05-28-2009, 10:09 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