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.
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...