In access i have an automation that will get new addresses from the address book of outlook express. Then i also have a command button that will determine the duplicates among the new addresses. Upon clicking of the buttton a query will run on the background then append the query in a table then the table will show up.
What i want to do is that when i click the duplicate command a new form will appear with a subform in it containing the duplicate addresses. Why do i want a subform for? because in a subform i can put check boxes, then on those checkbox the user can have an option whether he wants to delete the addresses or put them some place else, just like how the yahoo mail works. Got me?
I tried using the autoform where it did worked, it automatically showed the results of the query in it but then what if i want to make things fast i can't do that because i have to navigate on each data in order to delete it. But with subform i can have a check all button then will delete it.
So please help me how do this. I'm also a beginner in vba code so if ur willing to show me the code on how to do this, i would really appreciate it. thanksssss!
What i want to do is that when i click the duplicate command a new form will appear with a subform in it containing the duplicate addresses. Why do i want a subform for? because in a subform i can put check boxes, then on those checkbox the user can have an option whether he wants to delete the addresses or put them some place else, just like how the yahoo mail works. Got me?
I tried using the autoform where it did worked, it automatically showed the results of the query in it but then what if i want to make things fast i can't do that because i have to navigate on each data in order to delete it. But with subform i can have a check all button then will delete it.
So please help me how do this. I'm also a beginner in vba code so if ur willing to show me the code on how to do this, i would really appreciate it. thanksssss!
