Query not showing newly added records

[Richardabichahla]

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 working just fine 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 ???

 

[JANR]

It's a bit wage since you haven't prvided any details, so my guess is that there is a WHERE-Clause in your queries that restricts the data pull from your tables. Perhaps post the SQL of the offending queries or a samplebase.

JR

 

[Richardabichahla]

It's a bit wage since you haven't prvided any details, so my guess is that there is a WHERE-Clause in your queries that restricts the data pull from your tables. Perhaps post the SQL of the offending queries or a samplebase.

JR

I am really confused because all my queries are not working and they are simple queries done using the access query design view, there is no complicated SQL programing.

If you like i can mail you the complete file or upload it somewhere you can access it.

 

[JANR]

Just upload it here and I'm sure somebody can give it a crack. Just make sure it's below 2MB limit. Use Compact & repair and zip it.

JR

 

[Richardabichahla]

Just upload it here and I'm sure somebody can give it a crack. Just make sure it's below 2MB limit. Use Compact & repair and zip it.

JR

Man even when zipped it is 3.2 MB

is there any common reason related to some activeX or some access property settings that might cause this problem ?

 

[Galaxiom]

For now just post the SQL text of a query. Right click to get the sql view. It might be something obvious like date format issues.

Otherwise sanitise your data and delete all but a handful of records.
Compact the database, zip it and post here using Manage Attachments in the Advanced editor.

 

[Richardabichahla]

For now just post the SQL text of a query. Right click to get the sql view. It might be something obvious like date format issues.

Otherwise sanitise your data and delete all but a handful of records.
Compact the database, zip it and post here using Manage Attachments in the Advanced editor.

Kindly find my program attached with the reports deleted ( only queries left)
the 1st record is the only record displaying the second one is newly added but not displayed ( although it is compatible to the queries).

 

[Galaxiom]

The queries are returning what I would expect since there is only a single record of each Account type. When I add more records to the Payments table they show up.

I highly recommend you modify your tables.

Firstly get rid of the the Caption properties of the fields so the table fields show their real name. No feature of Access was ever so ill conceived as Field captions and they present a nighmare to subsequent maintenance by either you or anyone else.

Normalise many of the fields into a numerical ID which will be much faster in a query. The forms should use multicolumn combos to store the number but display the text. eg Regions should come from a table of regions represented by a number.

Would recommend this be done in conjunction with a change to table based row sources for your combos. These are much easier to maintain than List rowsources and allow users to easily add new values via form. Contacts.PTime is a particularly unweildy construct for a field.

 

[Richardabichahla]

The queries are returning what I would expect since there is only a single record of each Account type. When I add more records to the Payments table they show up.

I highly recommend you modify your tables.

Firstly get rid of the the Caption properties of the fields so the table fields show their real name. No feature of Access was ever so ill conceived as Field captions and they present a nighmare to subsequent maintenance by either you or anyone else.

Normalise many of the fields into a numerical ID which will be much faster in a query. The forms should use multicolumn combos to store the number but display the text. eg Regions should come from a table of regions represented by a number.

Would recommend this be done in conjunction with a change to table based row sources for your combos. These are much easier to maintain than List rowsources and allow users to easily add new values via form. Contacts.PTime is a particularly unweildy construct for a field.

Man thanks for these info... but they do not solve my problem.

I think you missed some queries that should display both names but are not doing that ... like what is called "fiche_directeur" and many others.

all newly added records are not displayed , i had to delete them to make the file smaller but you can try that locally and see it.

thanks for your help,

 

[Galaxiom]

The joins probably need to be changed to Left Joins otherwise you only get the records that have a related entry in every joined table/query.

 

[Richardabichahla]

The joins probably need to be changed to Left Joins otherwise you only get the records that have a related entry in every joined table/query.

Man i figured out the problem but still don t know how to solve it.
i have 3 queries that are called by the query "Fiche_directer" that should calculate the balance of 3 accounts "colonie", "cantine", and "transport". when their is no receipts entered for one or many of these accounts then their query will return empty value for this record and the main query is not displaying them.

how can i manage to solve this issue while having the same output ??
I want the record to be displayed even if the return value of the sub-query is empty.

 

[Galaxiom]

All records for the Contacts table will be returned if you use a Left Join to the other queries. Those with no results will have the Null value.

Right click on the Join lines in design view and select Join Properties.

 

[Richardabichahla]

All records for the Contacts table will be returned if you use a Left Join to the other queries. Those with no results will have the Null value.

Right click on the Join lines in design view and select Join Properties.

WOOOOOWWWW man thankssss.... that worked fine.
thanks alot...

 

[Galaxiom]

Sorry I didn't explain it a little more in post 10.

 

[Richardabichahla]

Sorry I didn't explain it a little more in post 10.

It s my mistake, i am still slow a little bit in access but thanks to ur help i have a wonderful application now.

Thank you.