Results 1 to 3 of 3
  1. #1
    jcsuarez is offline Novice
    Windows Vista Access 2003
    Join Date
    Oct 2010
    Posts
    3

    Last Record in macros ACCESS 2007

    I used to have a macro that calcultated fields in a form of an application Iīve made on ACCESS 2003, from the first to the last record. When I tried it on a computer with ACCESS 2007 the macro doesnīt stop. I donīt know how to order the macro to stop when it reaches the last record in ACCESS 2007. Can somebody help me, please?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    Need to see the code of the macro for analysis.

    Rebuild the macro in Access 2007.

    Convert macro to VBA. I only use VBA. For one reason, it is easier to debug than macros. Also easier to post VBA here for analysis.
    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.

  3. #3
    jcsuarez is offline Novice
    Windows Vista Access 2003
    Join Date
    Oct 2010
    Posts
    3
    I made a very small file in ACCESS 2007 with a form in which the macro should run; a table with data for the form; and the macro, so that you can work on it. I donīt know how can I upload it to you. Tell me, please.

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

Similar Threads

  1. Replies: 2
    Last Post: 06-18-2011, 09:55 AM
  2. Using Excel macros in Access
    By Lorlai in forum Programming
    Replies: 2
    Last Post: 06-03-2011, 02:01 PM
  3. Access macros
    By mamig in forum Access
    Replies: 2
    Last Post: 01-09-2010, 11:26 AM
  4. Replies: 0
    Last Post: 11-17-2009, 02:35 PM
  5. Replies: 0
    Last Post: 03-27-2008, 08:20 AM

Tags for this Thread

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