I have seen this issue posted a huge amount of times so I am going to post how to resolve this issue.
Access does not have any type of wait, pause or sleep functions. So the question is always, "How do I make Access VBA wait for some length of time before going on?"
The typicall answer is...