All queries not showing newly added records

richardac's Avatar, Join Date: Jun 2010
Newbie Member
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 ???
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Would you share your queries using the SQL view of your query
richardac's Avatar, Join Date: Jun 2010
Newbie Member
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...
Attached Files
File Type: rar Contact management database small.rar (71.0 KB, 13 views)
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
You have an accdb file but that is not an MS Access file.
richardac's Avatar, Join Date: Jun 2010
Newbie Member
Quote:
Originally Posted by shabbir View Post
You have an accdb file but that is not an MS Access file.
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.
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Do you have an MDB file or no? I am not sure how you are using MS Access
richardac's Avatar, Join Date: Jun 2010
Newbie Member
Quote:
Originally Posted by shabbir View Post
Do you have an MDB file or no? I am not sure how you are using MS Access
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
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Quote:
Originally Posted by richardac View Post
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
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.