Acess 2007 - New Record problem

[st21]

Hello,

i am having a problem with access 2007. The new records i am adding they are not saved at the next number of the form but they are getting the number of the old records and it goes to the begging.

For Example : i press the button for a new record at the "FORMS enviroment" , and when i press save, the database saves it as record 1 and tranfers the record 1 to the record 2, and when i add the next e.x 115 the database saves it as record 2 and transfers 2 to record 3... etc ?????

Note: at the "TABLES enviroment" the records appear normal 1-->1, 2-->2 etc

Also this started by accident from the keyboard when i pressed a shortcut and i pressed an other key of what i wanted, i think that some kind of setting has been changed...

ANY solution - HELLPPPPP! ??? please

[ranman256]

This is not normal behavior, have you run Compact/repair?

[CJ_London]

Note: at the "TABLES enviroment" the records appear normal 1-->1, 2-->2 etc

this implies that data is being save correctly

and when i press save, the database saves it as record 1 and tranfers the record 1 to the record 2, and when i add the next e.x 115 the database saves it as record 2 and transfers 2 to record 3... etc ?????

do you mean the record number changes? or just the order in which they appear.

If it is the latter, it sounds to me like you have sorted the form desc on the ID or a timestamp field and then saved the form (so latest one is on top). Check your form properties in the data tab for order by and remove anything that is there. You may also want to set Order on load to no

[st21]

no i havent , i do not even knew this exist ... i ll search it THX!

[st21]

This is not normal behavior, have you run Compact/repair?

no i havent , i do not even knew this exist ... i ll search it THX!

[st21]

this implies that data is being save correctly

do you mean the record number changes? or just the order in which they appear.

If it is the latter, it sounds to me like you have sorted the form desc on the ID or a timestamp field and then saved the form (so latest one is on top). Check your form properties in the data tab for order by and remove anything that is there. You may also want to set Order on load to no

It changes the nubmer automatically e.x so today i added 25 records the last saved record was saved as 25 but the actual number is 1454 and before this 1453 is saved as 24 etc

[NoellaG]

Where on the form is the number 24, 25 shown? Is it in a field on the form? Is this number stored anywhere in a table, or only shown on te form?

[mike60smart]

Can you upload a copy of the database to see if it also occurs on our PC's?

[Minty]

It sounds as if you are looking at the record selectors at the bottom of a form set to data entry.

It only counts / displays the new records entered whilst the form is open. If you close it it will start form 1 again each time.

[st21]

It sounds as if you are looking at the record selectors at the bottom of a form set to data entry.

It only counts / displays the new records entered whilst the form is open. If you close it it will start form 1 again each time.

Yes, that is true! but it is annoying and confusing doing change automatically...

[st21]

Can you upload a copy of the database to see if it also occurs on our PC's?

unfortunately i am not allowed to do that... i deleted office and re-installed it again, but didnt got fixed... so the file is the problem... some kind of setting has been changed? 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...

[st21]

Where on the form is the number 24, 25 shown? Is it in a field on the form? Is this number stored anywhere in a table, or only shown on te form?

This is a new entry and after save, it saves it at 25 number.

[st21]

This is not normal behavior, have you run Compact/repair?

i just did it, but nothing... changed...

[Welshgasman]

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

[CJ_London]

Looks like Minty is right - seems your form is set to data entry=yes.

What you are pointing to is the navigation window and is normal behaviour, however the number that is not 'right' to me is 1454 which is the total number of records in the table. What it should show is the total number of records in the form recordset. When my data entry is set to yes, I would see 25 of 25 after entering 25 records. It may have something to do with your version of access (I use 2010) or it might be you have code which is ordering the data in some way, or perhaps the language is an issue


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?

it may be the view you are showing is not the data entry view. Right click in the box with 1454 in it and sort ascending - what happens to the values at the bottom?