Results 1 to 11 of 11
  1. #1
    nahum abramovich is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    62

    records navigation buttons does not work

    hi all

    in one form navigation buttons work
    in other form not

    for example when i press the NEXT RECORD button it shows - you cant go to the specified record

    what could be the problem?

    thanks
    Last edited by nahum abramovich; 07-26-2020 at 04:22 AM. Reason: specified - Word correction

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    or example when i press the NEXT RECORD button it shows - you cant go to the specific record

    what could be the problem?
    You don't have another record.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    nahum abramovich is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    62
    i have 5 records

  4. #4
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,655
    Are you at the last record?
    Is this a custom button or built in button?

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,811
    Information provided is too sketchy to provide more than just shots in the dark.
    Explain more an you'll get more focused responses.
    Do you get the error after modifying or entering a record and then you try to navigate? Happens when trying to go from any record to the next or previous record or just one or the other? Any code behind the form (esp. on Current event)? Already asked - are these custom buttons and if so, show the code for the one(s) that raise the error.

    If you're only getting this after editing or adding a record, it can be because the changes are not being saved for some reason. Improper code on custom navigation buttons can cause this.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #6
    fcbuek is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2019
    Posts
    6
    When entering a macro on click
    Code:
    Private Sub Numer2_Click()
    Dim MyControl As Object
    Numer2 = Left(Numer2, 3) & "/000" & Mid(Numer2, 4, 4) & "/" & Right(Numer2, 1)
    End Sub
    Then, after hovering over the text field, he receives the following message:
    "The expression On Click you entered as the event property setting produced the following error: Invalid outside procedure."

  7. #7
    nahum abramovich is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    62
    I will try to explain properly.

    from design i created several buttons
    save record
    next record
    previews record
    and add new record

    now

    now the fault appear every time i go out from the form and return to form. look like it dost "remember" the records

  8. #8
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,811
    Then I guess you have to post the code for each button. However, you didn't answer any of the questions I asked so I don't know if showing the code will help at all. If you cannot answer those questions I can't begin to help you but maybe someone else can.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  9. #9
    nahum abramovich is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    62
    HI

    on my form when i put records and save i can navigate through them and everything is good As long as I do not leave the form- when i close the form and reopen i cant navigate (there is no records at all).

    No code behind the form.

    the buttons are built in.

  10. #10
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    Make sure the form's Data Entry property is set to No
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  11. #11
    nahum abramovich is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    62
    thank you it works

    thanks to all

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

Similar Threads

  1. Replies: 7
    Last Post: 03-03-2017, 05:12 AM
  2. Replies: 4
    Last Post: 09-22-2015, 09:06 AM
  3. navigation for records with buttons
    By waqas in forum Programming
    Replies: 2
    Last Post: 02-23-2013, 06:48 AM
  4. Record navigation buttons work backward
    By jonesy29847 in forum Access
    Replies: 22
    Last Post: 04-11-2011, 06:17 AM
  5. Navigation Buttons not working please help
    By dinarocks74 in forum Access
    Replies: 3
    Last Post: 06-26-2009, 10:15 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