All queries not showing newly added records
 

Hello Guys,

Sorry the continuous bother but i have a new problem in my Access program.

The queries are only showing the one record i originally added to the tables.
although they were all working just fine (on old and new records) and no change has been done to any of them.

now i just add records to the table and run all my queries but the only show the first record originally added.

Any help ???:nonod:

Re: All queries not showing newly added records
 

Would you share your queries using the SQL view of your query

Re: All queries not showing newly added records
 

i will attach a small sample of my access file so u can have a look on it.

the first record is showing but the second not .

thank you for all your help...

Re: All queries not showing newly added records
 

You have an accdb file but that is not an MS Access file.

Re: All queries not showing newly added records
 

can you please explain more ?
is this related to the problem i am having ?/

BTW in further testing the reports are working but in a weird way each time they display different info... and the "Fiche Directeur" is not displaying the new records.

Re: All queries not showing newly added records
 

Do you have an MDB file or no? I am not sure how you are using MS Access

Re: All queries not showing newly added records
 

man this is access 2007 it is not MDB form anymore accdb and accde.

this is the format of the file if converted to access 2003 it will become MDB

Re: All queries not showing newly added records
 

Ohh Ohh Ohh. I hardly use 2007 and so could not use it. If you can share the SQL I can look into it why queries do not show.