Acess 2007 - New Record problem

[st21]

That is the record number?

If the table is sorted, and you add new records, record 25 could be completely different?

I am at the record number 1454, but access saved it at the record number of the entry 25... (i had added 25 entries, it started from 1 etc.... )

I do not have any problem at the TABLE ENVIROMENT only at the FORM ENVIROMETN...

[CJ_London]

but access saved it at the record number of the entry 25

NO - it hasn't, it is just telling you that in the current recordset you are in the 25th record. Data is stored in the table randomly - often in order of the record ID but that is more by luck than anything else

[Minty]

This is a really important point to understand: Table data has no intrinsic order. New records will generally displayed at the end but you can't guarantee it, and it shouldn't matter.
If the order they are entered in does matter add a timestamp field.

You can set an order on a form based on sorting by a field. So you have two issues.
1. When doing data entry on a form set to data entry the record selector will only show the records you have entered in that forms current session.
2. When you are displaying all the records, you want them to appear in a specific order, so you have to specify that in the forms underlying query. (e.g. the timestamp if that is what you want.)

[st21]

NO - it hasn't, it is just telling you that in the current recordset you are in the 25th record. Data is stored in the table randomly - often in order of the record ID but that is more by luck than anything else

no it is not randomly, every day it starts from entry 1 and saves... and now if i close the file and open it again, and start edditing it will start from the beggining 1 etc and will push the other entries to the next one... OMG!

[st21]

This is a really important point to understand: Table data has no intrinsic order. New records will generally displayed at the end but you can't guarantee it, and it shouldn't matter.
If the order they are entered in does matter add a timestamp field.

You can set an order on a form based on sorting by a field. So you have two issues.
1. When doing data entry on a form set to data entry the record selector will only show the records you have entered in that forms current session.
2. When you are displaying all the records, you want them to appear in a specific order, so you have to specify that in the forms underlying query. (e.g. the timestamp if that is what you want.)

I have a physical database with this numeration and i am tranfering the data to access, so it is important to have the same numeration, but the good and strange thing is that this is happening only at the FORM ENVIROMENT

ALso, it is not randomly, every day it starts from entry 1 and saves... and now if i close the file and open it again, and start edditing it will start from the beggining 1 etc and will push the other entries to the next one... OMG!

[Welshgasman]

I have a physical database with this numeration and i am tranfering the data to access, so it is important to have the same numeration, but the good and strange thing is that this is happening only at the FORM ENVIROMENT

ALso, it is not randomly, every day it starts from entry 1 and saves... and now if i close the file and open it again, and start edditing it will start from the beggining 1 etc and will push the other entries to the next one... OMG!

I do not think Access is for you?
That, or this is just a windup?

[CJ_London]

every day it starts from entry 1

what do you not understand about

it is just telling you that in the current recordset you are in the 25th record.

Have you even tried

The values you are seeing show where you are (which record) in the form recordset. Click on the < or > buttons either side of numbers should take you to the previous or next record and the |< and >| to the first and last records. So trying clicking on the > or >| buttons - where does it take you? and what does the 1454 value at the top of your form change to?

I'm going to drop off this thread, seems to me you haven't read or understood anything you have been told and I have more pressing things to attend to

[Minty]

I have a physical database with this numeration and i am tranfering the data to access, so it is important to have the same numeration, but the good and strange thing is that this is happening only at the FORM ENVIROMENT

ALso, it is not randomly, every day it starts from entry 1 and saves... and now if i close the file and open it again, and start edditing it will start from the beggining 1 etc and will push the other entries to the next one... OMG!

Did you not read or possibly not understand the posts I made or Ajax made.
This behaviour is EXACTLY how the form you have made will work with the current settings.

You have set the form to DATE ENTRY = YES

The numbers at the bottom of the form are only showing you a COUNT of the current NEW records that you have entered since opening that form.
It is not a record number, and never will be. It is purely a representation of the current record set. If you filter the records your total number will change to reflect the new filtered record count.

If you don't understand this I suggest you go and find an introductory basic Access course on line and study it carefully.

[st21]

what do you not understand about

it is just telling you that in the current recordset you are in the 25th record.

Have you even tried



I'm going to drop off this thread, seems to me you haven't read or understood anything you have been told and I have more pressing things to attend to

Yes i have! i am working like that for a week now, what do you think? and i ve understand they way it works and saves the records!

I do not think that you have understand the problem and how to solve it and you are not obligate too, spend your time to most important things!

[st21]

Did you not read or possibly not understand the posts I made or Ajax made.
This behaviour is EXACTLY how the form you have made will work with the current settings.

You have set the form to DATE ENTRY = YES

The numbers at the bottom of the form are only showing you a COUNT of the current NEW records that you have entered since opening that form.
It is not a record number, and never will be. It is purely a representation of the current record set. If you filter the records your total number will change to reflect the new filtered record count.

If you don't understand this I suggest you go and find an introductory basic Access course on line and study it carefully.

You havent red anything of what i have writen... Goodbuy, and rename your forum to ....sth else

[Welshgasman]

You havent red anything of what i have writen... Goodbuy, and rename your forum to ....sth else

Don't waste your time posting in another forum. They will tell you exactly the same.
If you do so, be sure to tell them you have already asked here and link to this thread, otherwise if they find you are crossposting without advising, they will be less than pleased. Standard forum etiquette.

So if this is yours https://www.access-programmers.co.uk/forums/threads/iello-a-newbie.320374/ beware!

[NoellaG]

I'm starting to think, that the 'Data entry' property is set on True by accident. So, in the past the counter gave the total amount of records and now only newly added records are shown see:

the last saved record was saved as 25 but the actual number is 1454
...
This started by accident... when i pressed a shortcut to save an entry and i pressed an other key of what i wanted, and then this started...

Please note that the order in which the data are shown depends only on the filter and the sorting order you apply. The counter below only shows you the current position of the record in the part of the dataset you asked to see.

[Welshgasman]

O/P has already been advised of this and indeed that is him crossposting in another forum.
https://www.access-programmers.co.uk...s-2007.320375/

[mike60smart]

Can you upload your database?

[st21]

1. THX the professional for the attitude!
2. Data Entry wasnt set to YES (as you told me), it was set to NO... i checked it, so the problem wasnt this!

For those who are not proffesionals and like to read also...

The solution i found and solved it eventually... so the answer is :


1. open design view (THE FORM FILE)

2. PROPERTY SHEET --> Tab - ALL-> ORDER BY ON LOAD --> set to NO


That worked for me at the moment... - Regards