Technical Document

Summary

This document illustrates how to integrate QuickAddress Plug ‘n’ Go applications such as Pro into Microsoft Access.

Solution

If using the Plug & Go QuickAddress product use the executable qushown.exe. If using a QuickAddress API, please refer to sample code provided with the library, and also available for download from the QAS support website.

What is qushown.exe?

Qushown.exe minimises or restores a QuickAddress application. This utility can be called by any program wishing to automatically minimise or restore a QuickAddress application that is currently loaded.

How do I setup qushown.exe in an Access form?

To do this it is best to start by creating a configuration setting called *access* and configuring this so that it pastes correctly into your chosen fields in the Microsoft Access form.

1. Load up your QuickAddress program and the Microsoft Access form.

2. Select the database that you wish to use QuickAddress with.

3. Select the Macros tab and click the New button.

4. Select RunApp from the Action control.

5. A command line box will appear at the bottom of the window. In this box type the path for the qushown.exe file e.g. c:\qaddress\pro32.315\qushown.exe. Save this Macro and close the window.

6. Select the Form tab and click the Design button.

7. Select the text box that you wish the QuickAddress product to pop-up over when entered. Then right mouse click on this box, select Properties and then the Event tab.

8. Select On Enter (or whatever is appropriate), and from the list select the name of the macro that you have just created. You can repeat this for different Events.

9. Save and close the Design Form window and then open the form. Use form as normal and when you get to the relevant box QuickAddress should Pop-up.

Full details of how to use this utility for your UK QuickAddress product can be found in utils.txt (normally located in the same folder as qushown.exe). This includes:

• Sensing whether QuickAddress is open before calling qushown.exe
• Minimising / Closing QuickAddress
• Using qushown.exe with more than one QuickAddress product
• Popping-up using specific layouts

For full details for QuickAddress World/DataWorld products please see readme.txt, this can be found in the same folder as the qushown.exe utility.

Related Links

How to automatically pop-up or invoke QuickAddress Pro