It still wasn't working properly.
It ran and asked me to confirm that I wanted to delete the entries and then it displayed the QueryResults form however said form was empty even though the actual table holds 3 entries in it.
So I thought maybe there was something wrong with the queries so I have deleted the queries and I have made them all again using the design wizard in access ... the problem is that the wizard is making them all as SELECT queries. I do not know how to change this ....
I have been looking for help via google as well but I don't really understand all of what I see.
Sofor example the View All Movies button :
button code looks like this:
and the Query code looks like this:
I found an article that helpedme to understand the append query and to create the queries that I wanted.
I now have 2 queries - the first one is to find the duplicates however it is still a SELECT query and will not execute.
The second one is an APPEND query to show all results and when I run it it deletes the data that was in the queryreults table but then it displays a BLANK reults form instead of bringing across the rata from the table as it should.
have uploaded a copy of the latest database for you to have a look at.
Bookmarks