Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Quote Originally Posted by Gicu View Post
    Is that good or bad ?
    Can't see it being bad?, can you.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  2. #17
    Solong is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2022
    Posts
    2
    Hey guys,
    Wow! Thank you folks, all of you! Plenty of food for thought there - yes I had wondered about time-stamping the entries and even setting up a history trail, but I'm going to investigate the RecordSetClone as much out of curiosity as anything else - I'd not encountered it before. I've also had a look at Allen Browne's solution - yes, Vlad's is similar - great minds and all that - I shall play when I next get the chance. (Retirement takes up a lot of time!)
    Cheers
    Steve

  3. #18
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    my method simply positions the form at the last used record.
    Vlad, maybe I'm not understanding completely what you suggested. Based on that quote it appears to me that if I navigate to a record, the serial gets updated. Then I close the form and reopen and your suggestion will take me back to that record. However, since I didn't edit it, it's not the record I created or edited last. That's why I said you need a time stamp for new or edited records because OP said
    I would prefer the form to open on the last record I was working on.
    I take that and
    Once I have completed an update,
    to mean that just looking at the current record doesn't count. I suppose you could only write the serial when the form is dirty (which still doesn't guarantee that anything was changed) but I'd say that's the same as what I said. It's just a different stamp value?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #19
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Micron, yes I agree with your scenario and having a timestamp is such an easy thing to implement (we even have data macros now), my thinking is (was) that you would want to return to the last record to "viewed" not necessary the one you just completed (because if you have validations going on you shouldn't be able to leave it half done anyway).
    I guess just different ways of interpreting Steve's post...

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 12
    Last Post: 07-25-2019, 02:47 PM
  2. Replies: 24
    Last Post: 09-16-2018, 04:02 PM
  3. Replies: 3
    Last Post: 11-28-2016, 03:17 PM
  4. Replies: 1
    Last Post: 12-31-2012, 06:25 PM
  5. Replies: 3
    Last Post: 08-15-2011, 10:06 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