Search results
-
A
Query not showing new records added though they exist in table.
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... -
A
Query not showing new records added though they exist in table.
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! -
A
Query not showing new records added though they exist in table.
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... -
A
Query not showing new records added though they exist in table.
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. -
A
Query not showing new records added though they exist in table.
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... -
A
Query not showing new records added though they exist in table.
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. -
A
Query not showing new records added though they exist in table.
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... -
A
Query not showing new records added though they exist in table.
very logical suggestion vbaInet, im working on it now thanks -
A
Query not showing new records added though they exist in table.
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? -
A
Query not showing new records added though they exist in table.
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... -
A
Query not showing new records added though they exist in table.
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...