Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   All queries not showing newly added records (http://www.go4expert.com/forums/queries-newly-added-records-t22508/)

richardac 23Jun2010 12:44

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:

shabbir 23Jun2010 13:51

Re: All queries not showing newly added records
 
Would you share your queries using the SQL view of your query

richardac 23Jun2010 14:05

Re: All queries not showing newly added records
 
1 Attachment(s)
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...

shabbir 23Jun2010 15:10

Re: All queries not showing newly added records
 
You have an accdb file but that is not an MS Access file.

richardac 23Jun2010 15:22

Re: All queries not showing newly added records
 
Quote:

Originally Posted by shabbir (Post 69540)
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 23Jun2010 16:09

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

richardac 23Jun2010 16:12

Re: All queries not showing newly added records
 
Quote:

Originally Posted by shabbir (Post 69546)
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 23Jun2010 17:10

Re: All queries not showing newly added records
 
Quote:

Originally Posted by richardac (Post 69547)
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.


All times are GMT +5.5. The time now is 08:23.