Re: CALLING SQRW.DLL

[Jim Wyant <kopy_katt@YAHOO.COM>]

The following is from SQR version 4.3.4 release notes.
Jim
jwyant@ctp.com

Using SQRW.DLL from Visual Basic
--------------------------------

You can call SQR from Visual Basic, Microsoft Access
and any other application that supports VBA (Visual
Basic for Applications).  To run an SQR report, you
must declare a global external function.  This is done
from the Declarationsarea:

    Private Declare Function sqrw Lib "sqrw.dll" Alias
"sqr"
    (ByVal c$) As Integer

Note that we name the function sqrw instead of sqr.
The reason is that sqr is
a reserved word in Visual Basic-the square root
function.  We use the Alias
option to tell Visual Basic that the function within
the DLL is called "sqr".

To run a report, use the sqrw function.  For example,
consider the following
line of VBA code:

    status% = sqrw("C:\REPORTS\SALES tutorial/secret")

This example runs the Sales report using "tutorial"
and "secret" as the user
name and password respectively.


--- "J.A. Gorski" <j.gorski@NOTESMAIL2.CSUOHIO.EDU>
wrote:
> I have a need to call SQRW.DLL from MS ACCESS.  The
> SQR user guide does not
> give specifics.
>
> Joel A. Gorski
> Systems Analyst
> Cleveland State University
> J.Gorski@csuohio.edu
>

__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com