Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Display Modes
  #1 (permalink)  
Old February 20th, 2005, 05:06 AM
Authorized User
Join Date: Nov 2004
Location: North Ryde, NSW, Australia.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default API Problem

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

Reply With Quote
  #2 (permalink)  
Old March 13th, 2005, 10:03 PM
Authorized User
Join Date: Nov 2004
Location: North Ryde, NSW, Australia.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts


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.


Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
API mallik C++ Programming 2 February 20th, 2008 03:03 AM
how to learn C# and API samrath C# 2 July 9th, 2007 04:32 AM
problem in API programming in visual basic 2005 jatin Visual Basic 2005 Basics 2 March 16th, 2007 02:11 PM
API Panduchandra Visual C++ 1 March 27th, 2006 10:48 PM

All times are GMT -4. The time now is 10:08 PM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.