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
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old February 20th, 2005, 06: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.

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


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

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

Reply With Quote
  #3 (permalink)  
Old November 30th, 2017, 06:51 AM
Registered User
Points: 15, Level: 1
Points: 15, Level: 1 Points: 15, Level: 1 Points: 15, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2017
Posts: 5
Thanks: 1
Thanked 0 Times in 0 Posts
Default

REST API is becoming the most popular way to communicate between multiple systems.
To know about more Try these two:

1- Load JSON / REST API to SQL Server in SSIS
2- HTTP POST in SSIS – Send data to Web API url

I hope these article will help you to resolve your Issue.
Good Luck
Reply With Quote
Reply


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 04:03 AM
how to learn C# and API samrath C# 2 July 9th, 2007 05:32 AM
problem in API programming in visual basic 2005 jatin Visual Basic 2005 Basics 2 March 16th, 2007 03:11 PM
API Panduchandra Visual C++ 1 March 27th, 2006 11:48 PM



All times are GMT -4. The time now is 07:13 AM.


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