I am facing a problem in program; it is about API where my system is SQL Database (MSDE) with MS ACCESS (2003) front-end controlled by VBA.

Problem:

ACCESS Generates (Invoice / Quote ) using data from SQL Db, and transferred it to preformatted template in MS Word, where the program creates a tables to put Inv/Qot items and put the data in it.
then saves (Inv/Ouote) as Word Document and PDF, the PDF file will be attached to an email and send it to the client using his/her Card's data

when I execute the program for the first time, it works perfectly, then when I continue to create the second (Inv/Qot) it appeared but with NO Inv/Qot Items, the program does not create items table and populate data in it, if I log out of ACCESS program, then login back and try to generate the Inv/Qot again the first one will come out perfectly, but the all after will come without the table of the items.


Please if anybody can help, where I really did all what I can do...

Mates;

After reviewing the whole process, the problem was one out of 58 varialbles is not being distroyed and reinitiated in the second call, I redesigned the whole process, and split it into 6 processes, and make sure that all variables created within each process, is distroyed (set var = nothing) at the end of each process. and when user closes the Inv/Qot form the appication checks that all variables are cleared.

Thanx