Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Simboti1
  • Content: Threads
  • Order by date
  1. Simboti1

    Updating Datetime field

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

    Fiscal Calender View - CS0002

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

    Accpac XAPI - Joint Query

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

    User Defined Recordset

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

    User Defined Recordset in VB 6

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

    Sending SMS messages from VB 6.0

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

    ACCPAC Controls

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

    DDL Language through ACCPAC XAPI

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

    Sample ACCPAC XAPI Code

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

    ACCPAC SDK Development

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

    Selecting ACCPAC Company to Log into

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

    Accpac Login session using XAPI - SDK

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

    Cannot Log into Win 2003 Server

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

    Installing ACCPAC on Linux Server

    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

Part and Inventory Search

Back
Top