Recent content by SonnyTate

This is pretty hard to explain in just a few words. I studied database design for an entire semester at school. It was complete with a 300 page textbook on the subject! But I will give it a try. One way to approach this is to model your tables after the situation. First try to find each of the...

Hehe That doesn't surprise me! Just try try to convince my supervisor!

Thanks Hi Tech. That did the trick! So there was a delay in writing to the cache? That's why it seemed like the code was running "too fast" to update the table?

I have a rather odd problem. I am importing an Excel into an Access database and then updating 2 tables from it's data. I'm doing it by using a series of DoCmd.RunSQL statements as shown below: Dim msgboxResponse Dim strSQL As String msgboxResponse = MsgBox("Are you sure you want to update...