Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

access buttons dont go to correct records

Posted on 2013-01-16
7
Medium Priority
?
181 Views
Last Modified: 2013-01-21
I have a form called clients based on a table of the same.
I have several nvaigation buttons at the bottom which I put on using the wizard.

Strangely, the last button does not go to the last entry and the other buttons dont go the right one.

I would expert the "first record" button to go to the first record but it goes for one right in the middle, sequence wise. The only one which works is "add record"   !

Any insight? I have tried replacing the buttons but its the same.
0
Comment
Question by:topUKlawyer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 2

Expert Comment

by:ConnerT
ID: 38783441
It would be handy if we could have some screenshots to view your problem :)


-ConnerT
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38783571
much better if you upload a copy of the db, so we can see what weird things are on it to cause those behaviors
0
 
LVL 48

Accepted Solution

by:
Dale Fye earned 2000 total points
ID: 38783605
Tables do not have a logical sort order, so if you are simply using the table as your forms recordsource, the records will be presented to you in the order that they were entered (probably), which may not be the order you would like them in.

Create a query based on your table, but sorted the way you want it.  Then change the forms Record Source to that query and see whether the buttons do what you expect
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:topUKlawyer
ID: 38786363
Thanks for replies.

I think I have fixed it. The "order by " property for the main form seems to have been the postcode rather than the clients ID.

I have changed it and this seems to work ok.
0
 

Author Comment

by:topUKlawyer
ID: 38797296
I've requested that this question be closed as follows:

Accepted answer: 0 points for topUKlawyer's comment #a38786363

for the following reason:

discovered why I had a problem
0
 
LVL 48

Expert Comment

by:Dale Fye
ID: 38797297
Did you discover the forms order by property before or after you read my comment?
0
 

Author Comment

by:topUKlawyer
ID: 38798353
I am not sure, I think I did, but I am happy to award points for the avoidance of doubt unless there any objections from others.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question