Results 1 to 3 of 3
  1. #1
    shod90 is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Jan 2016
    Posts
    134

    Find last record and print it

    Dear Gents,
    I have a data entry forms and in this forms there are many users adding their data,
    No i need to make a small window next to the data entry form to remind ( Every user ) what was the last record he typed in the form .


    Um guessing that should be done with query but how exactly should be done ??

  2. #2
    vicsaccess's Avatar
    vicsaccess is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Apr 2015
    Posts
    451
    are the users logged in and is that reference saved with the record? if so then a SQL would work. play with a query and look at the SQL. maybe something like
    select logid
    from table
    where (logid=me.logid)
    order by logid desc

  3. #3
    shod90 is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Jan 2016
    Posts
    134
    Thanks for the reply , But I need the only last record to be shown nxt to the data entry form .

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

Similar Threads

  1. Replies: 5
    Last Post: 07-29-2014, 01:05 PM
  2. Replies: 1
    Last Post: 06-23-2014, 07:21 AM
  3. Replies: 1
    Last Post: 05-26-2014, 12:39 PM
  4. Replies: 4
    Last Post: 04-01-2014, 02:33 PM
  5. Replies: 5
    Last Post: 10-26-2011, 02:59 PM

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