Number of Records Not Being Displayed in Split Form's Navigation Buttons
- Thread starter JamesJoey
- Start date
- Local time
- Today, 09:33
- Joined
- Oct 29, 2018
- Messages
- 22,511
Hi James. Is this in response to me? I wasn't sure. When you opened the file I posted, did it work or not?
What did you do to get this to work?
For days I opened this form an another form that worked in design view and went back and forth to compare properties.
- Local time
- Today, 09:33
- Joined
- Oct 29, 2018
- Messages
- 22,511
Hi. That's why I asked for you to provide the same information to us, so we can do the same thing. I also compared the two forms and found no obvious difference between the two that would explain the different behaviors. So, I had to do a little scientific experiment.
My first thought was maybe the form could be corrupt. So, I created a new split form based on the same table; however, the problem was still there. Next, maybe the table or the db file is corrupt, so I exported the table to a new/different database and tried again - same result. Okay, perhaps the corrupted table got imported as corrupt as well, so I created a new table in design view to copy your table structure and then inserted the records from your table. Sadly, the problem persisted. So, one last check... I created a totally different table and added completely different data to match or exceed the number of records in your table, just to eliminate that as a suspect. It worked!
At this point, I suspected it must be about your table's data. So, in a series of trials and errors, I started out by emptying your original table and then slowly added the original records one at a time, checking the split form after each record was added. Everything worked until I got to record ID 323. So, through a process of elimination, I narrowed it down to the set of records from 323 to 339. Meaning, if you remove those records from your table right now, the split form should start to work normally.
At this point, the experiment is not finished. I didn't have time yesterday to narrow it down further to see what' so special about those records to make the split form not work properly. If I find out, I'll let you know. If you know the reason, being you're more familiar with your data than I am, then please let us know.
I hope that explains what I did. Cheers!
Last edited:
- Local time
- Today, 09:33
- Joined
- Oct 29, 2018
- Messages
- 22,511
I could be wrong; but as far as I can tell, it's not the table, it's the data. I was looking for "weird" characters and things like that, but there was nothing obvious when I checked.
- Local time
- Today, 09:33
- Joined
- Oct 29, 2018
- Messages
- 22,511
Please clarify... You don't see it in your original table, or you don't see it in the file I posted?
- Local time
- Today, 09:33
- Joined
- Oct 29, 2018
- Messages
- 22,511
Okay, thanks for clarifying. As I said in my earlier post, your original form did not work because of those records, which is why I deleted them from my version, which you verified now works. So, I am saying if you delete the same records from your table, then your original split form that wasn't working should now start working. Have you given that a try yet? Make sure you have a backup copy first.
It doesn't matter if the records were duplicates of each other. Since I was not familiar with your data, I could only go by the ID number. If you delete those 13 records from your original table, then your split form should start working as normal.
At this point, I am not sure if all 13 are bad records, or if there's only one bad record within those 13. Like I said earlier, I didn't have time to check each one of them yet. I'll let you know later if I get a chance to do that and if I find anything definitive to explain the cause of the problem.
- Local time
- Today, 09:33
- Joined
- Oct 29, 2018
- Messages
- 22,511
That would certainly be an experiment you can conduct and I encourage. However, could you please confirm for us that by deleting those range of records from your original database that your original split form also started working properly?
I am also planning on reviewing those suspect records by adding them back in one at a time. I just didn't have any additional time earlier to conduct more experiments.
- Local time
- Today, 09:33
- Joined
- Oct 29, 2018
- Messages
- 22,511
I only deleted 13 records. Where did the 170 records come from?
- Local time
- Today, 09:33
- Joined
- Oct 29, 2018
- Messages
- 22,511
LOL. Sounds like you may have missed my detailed post #25. Did you have any idea why I kept saying 13 (bad) records?
I didn't miss it I misunderstood it.LOL. Sounds like you may have missed my detailed post #25. Did you have any idea why I kept saying 13 (bad) records?
I deleted the IDs from 323 to 339 and it still not displaying the number of records.
It did delete 13 records leaving a total of 201.
- Local time
- Today, 09:33
- Joined
- Oct 29, 2018
- Messages
- 22,511
I see. I would suggest the following experiment. Download the latest sample db you posted in #15. In that db, delete those 13 records and check if the split form works or not. If it doesn't, there may also be a combination of your machine setup plus the database itself. For example, when I downloaded that same db, I can duplicate your problem. After I deleted the suspect records, it started working for me. I then uploaded that same, but modified, file in post #16, and you said it was working for you. So, if you duplicate the steps I took using the same file I used, and it still didn't work, then the only difference left is yours and my machine.
I noticed that the file you have in Post 16 works fine. But, there's 194 records as opposed to 201.
Seems the pone that works had 20 records deleted stead of 13.
So I went into the datasheet and deleted 7 more records (around the 300 ID or so, I forget) and the split displayed the number of records!
If I can now find which 20 I deleted I'll try adding them back one-at-a-time and see if it works.
