Just create an append query in the query designer, save it and run that as you did for the Clear query?
Just create an append query in the query designer, save it and run that as you did for the Clear query?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Cross posted with code supplied here?
https://www.access-programmers.co.uk...ations.316636/
That's me out.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
I apologize; I'm new to forums and didn't realize that who can't post on multiple ones. I felt bad asking you so many questions so I asked elsewhere when I ran into multiple problems
It's etiquette to advise if you post the same question elsewhere and provide a link, as it saves people answering things twice.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
This might help. Ought to be a part of every cross posting warning that's not given by the OP, IMO. It will provide some perspective and what to do in the future
https://www.excelguru.ca/content.php?184
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Got it. Thanks for the help
I've now added it to my signature.This might help. Ought to be a part of every cross posting warning that's not given by the OP, IMO. It will provide some perspective and what to do in the future
https://www.excelguru.ca/content.php?184
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
If it helps, I just have it as a bookmark. I'm used to opening the page from the bookmark and copying the url but I just found out that when using FireFox it seems possible to copy and paste the bookmark itself.