Results 1 to 3 of 3
  1. #1
    zozzz is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2013
    Posts
    49

    Find Last Number Of Document


    Hello and good time
    I need a code to find the Last number In Form

    Thank You
    Attached Files Attached Files

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    You can add this code to the click event for your button.

    Code:
    Private Sub Command7_Click()
    MsgBox " The last number is " & DMax("Doc_No", "table1", "Document ='" & Me.Combo4 & "'")
    End Sub

  3. #3
    zozzz is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2013
    Posts
    49
    Thank you orange

    was completely accurate



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

Similar Threads

  1. Replies: 0
    Last Post: 11-01-2014, 12:35 PM
  2. VBA to find/replace text in word document
    By Goodge12 in forum Programming
    Replies: 1
    Last Post: 07-16-2014, 01:23 PM
  3. Replies: 5
    Last Post: 01-23-2014, 09:36 AM
  4. Find Max number
    By NISMOJim in forum Programming
    Replies: 11
    Last Post: 05-17-2013, 03:01 AM
  5. Replies: 0
    Last Post: 10-04-2012, 01:39 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