Search results for query: *

I am having problems with updating a datetime type field using the INSERT SATEMENT IN Ms Sql 2005. This is the scenario: - 1. dTrxDate is defined as datetime field in Ms Sql 2005. 2. There is no problem if I update the field through: - 2.1 Reading a Record set from the Table. 2.2...

May someone please Help. I have covered 95% of my conversion project from pure VB6 to VB6 plus XAPI for ACCPAC 5.4A and 5.5A. I am able to use access the GL0001 view through the following code: ------------------------------------------------------------ Public ACCPAC_Session As AccpacSession...

I have the following SQL query in VB6 SELECT A.GLREF, A.GLDESC, A.AMTEXTNDHC, B.GLBATCH, B.GLENTRY FROM APPJD AS A INNER JOIN APPJH AS B ON A.POSTSEQNCE = B.POSTSEQNCE AND A.TYPEBTCH = B.TYPEBTCH AND A.CNTBTCH = B.CNTBTCH AND A.CNTITEM = B.CNTITEM AND...

How do I add records to a User Defined Recordset? My declaration is as follows: - Dim Rs as ADODB.Recordset Set Rs = NEW ADODB.Recordset With Rs.Fields .Append "Field1", adVarChar, 20 .Append "Field2", adVarChar, 10 End With

How do I declare and use a user defined recordset in VB 6.0

What is the code to send an SMS message from a VB application?

Is it possible to make use of the following ACCPAC controls in VB6/XAPI environment: - 1. Period Picker Control? 2. ACCPAC Finder to search and filter specific GL Code? If and of the above is possible please provide sample code for: 1. Trapping the selected Fiscal Period and Year into some...

Could someone advise if there is a way to create a DATABASE and or a TABLE through ACCPAC's XAPI?

Can anyone help? I am converting a VB6 application so that it fetches data from GL0018 view instead of the convensional SQL code. I need XAPI code that will achieve what the following SQL code is doing? 1. SELECT FISCALYR AS FSC_YEAR, JRNLDATE AS DOC_DATE FROM GLPOST WHERE ACCTID = '4020' AND...

I have the following questions regarding ACCPAC SDK: - 1. Do I need C++ installed on the development computer? If the response is No, which URL can I get Vcvars32.bat file from? 2. Which URL can I download the following files from: - 2.1 Microsoft's Cabinet SDK 2.2 Microsoft's...

I have written a stand alone VB6 app that picks data from ACCPAC. I have created a form that passes the user name and password to access ACCPAC as follows: - theSession.Open(txtUSERID, txtPASSWORD, "SAMINC", dNow, 0) My challenge is How can I have access to the ACCPAC Companies so that the...

Can anyone help with the code of calling the ACCPAC login Session (login screen) using API in VB6. I am able to log in when I hard code the login credentials using the following code: ---------------------------------------------------------- Set ACCPAC_Session = New AccpacSession...

I am failing to log into a Windows 2003 Server I have just installed. The error message I get is "NOT ENOUGH STORSGE IS AVAILABLE TO PROCESS THIS COMMAND". I have installed SP 2 for Win 2003 and the HDD Storage is 250gig and memory is 2 gig. I have changed the IRPStakeSize DWord value in the...

I am trying to install ACCPAC 5.4A on a Linux Server and Windows XP workstations. What are the requirements and what is the procedure. Please advise