Recent content by Ahmsv1

Many thanks. I beleive the problem has been solved. Firstly after using vbaInets logical suggestion of removing and re building the query got it working again and made me realise it really was a null character problem. The Nz. method suggested by GalaxiomAtHome was used in the query via...

Aah thats how it would be in the SQL. Now I have two methods to use. If one fails ill use the other. working on it now!

Looking back to what GalaxiomAtHome, who was right about the Null thingy. I tried to put the Nz function into the SQL which was a disaster. I then went into design view for the query and put it in there, and now I can delete the field which it applies to and the record is still returned in the...

Hi, The data was initially imported from excel. From that point onwards any additional data is entered by the user via a form I created.

hello again. Earlier to check if the problem was null field related I created new records in which all fields had values and they did not show up, so i dismissed this. Then I tried as per vbaInet has suggested and now I am able to see these records I added. Now, I have added a new complete...

Hi, In normal operation, this query is run from a form accessed by the user via the switchboard. When it is run, the button simply runs the query and displays it to a form. There is no refreshing happening that I know of. The database has been closed and reopened numerous times now.

Hi Again folks, So like was suggested by vbaInet I removed all criteria, and added them back one by one. And immediately the queries now return the new records entered. I have just created another brand new record and it returns in the query. I have changed nothing, not a bean. So it makes me...

very logical suggestion vbaInet, im working on it now thanks

Hello To firstly look at whether the problem lies in null fields I have added records which have content in every field. However these are still not featuring in the search results so im thinking this wont be it?

Excellent post. I think you hit the nail on the head with the points on null values and excel substituting them, it makes perfect sense. It's 2:20 am so I shall act on this after a sleep! Also I did not write the excel I used the designer. Is this bad SQL? Should I try editing it ( not that I...

Hello, I have a simple database in access 2007. It contains only one table. I have a form called qryAll. From this form the user can enter criteria for a query that queries all of the fields in a table. (so you can query with criteria from more that one field) Anyway this all works fine. I...