My Access database is mixing up the record numbers in the table

My Database is mixing up the record in the table and the form. It says its a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11986-my-access-database-mixing-up-record.html
1017 system error. How do I get the records back into their correct order?

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

What exactly are the symptoms?

You do realize, I hope, that you cannot make any assumptions about the order
of records in tables.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11986
(no e-mails, please!)


"achristian" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11986
news:AD29AC74-2515-46E1-80D7-0858069643DB@microsoft.com...
> My Database is mixing up the record in the table and the form. It says
its a
> 1017 system error. How do I get the records back into their correct
order?

Records are not stored in any order. You can display them in an order by
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11986
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11986
indexing or setting sort in a query, form or report.

"achristian" wrote:

> My Database is mixing up the record in the table and the form. It says its a
> 1017 system error. How do I get the records back into their correct order?

achristian wrote:
> My Database is mixing up the record in the table and the form. It
> says its a 1017 system error. How do I get the records back into
> their correct order?

What record numbers? Access does not have record numbers.

Records in a table are not in a specific order. If you want records in
an order, you need to provide for that. Considering a table as a bucket of
data is the best way of handling it.

Autonumber is not intended as a way of providing a record order, only a
way of providing a unique number for each record.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11986

How does the error message fit into the problem?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11986

--
Joseph Meehan

Dia duit

Hi.

> It says its a
> 1017 system error.

Do you mean system error -1017? If so, what's the exact error message? The
error number means different things, depending upon the context, such as a
replicated database's synch error, a compaction error, or a conversion
error.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"achristian" wrote in message
news:AD29AC74-2515-46E1-80D7-0858069643DB@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11986
> My Database is mixing up the record in the table and the form. It says
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11986
> its a
> 1017 system error. How do I get the records back into their correct
> order?