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 Rhinorhino 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
  • Order by date
  1. Simboti1

    Accpac XAPI - Joint Query

    Hi DjangMan The "InternalSet" qualifier seems not to be recognised in VB6. I say so because when I put CSQry. I do not see InternalSet on the list. However, if I type CSQry. I can see Browse. Iam referring to the code below: - -------------------------------------------------------...
  2. Simboti1

    Updating Datetime field

    Hi Andy Below is my sample code ------------------------------------------------------------ strQuery = " INSERT INTO CLAIMSHDR " _ & "(BATCH_ID, BATCH_DATE, BATCH_DESCRIPTION, RECORD_COUNT, USER_ID) VALUES (" _ & "'" & strBATCH_NUMBER & "'" & "," & "'" & dtpBATCH_DATE & "'" & "," _...
  3. Simboti1

    Fiscal Calender View - CS0002

    Hi ettienne Your code is running fine. However, my requirements are slightly different. Here I go: - 1. I have referenced ACCPAC's Periodpicker on a form. I have named it pckACCPER. 2. When I click on the pckACCPER control, I need to select an accounting Period (Similar to what happens when...
  4. 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...
  5. Simboti1

    Fiscal Calender View - CS0002

    Hi Ettienne Thanks very much. Is it possible for you to assist with the sample code for the AccpacFiscalCalendar.GetPeriod route? Regards Simboti
  6. 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...
  7. Simboti1

    Accpac XAPI - Joint Query

    Thanks DjangMan
  8. Simboti1

    Accpac XAPI - Joint Query

    Hi DjangMan The code is for an Add-On that will be using ACCPAC 5.4A and 5.5A Regards Simboti
  9. Simboti1

    Accpac XAPI - Joint Query

    Hi aggyey Thanks for your quick response. For a single view related to GL0018, I am using the following approach: - ----------------------------------------------------------- Public ACCPAC_Session As AccpacSession Public RsGLPOST As AccpacCOMAPI.AccpacView Public strFilter as string Set...
  10. 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...
  11. Simboti1

    ACCPAC SDK Development

    Hi Chris I want to develop applications compartible with both ACCPAC 5.4A and 5.5A. So what do you suggest? Regards Simboti
  12. 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
  13. Simboti1

    User Defined Recordset in VB 6

    Thanks HarleyQuinn What are the other field types besides adVarChar Regards Simboti
  14. Simboti1

    Sending SMS messages from VB 6.0

    Hi HarleyQuinn I would like to send from an SMS Modem Regards Simboti
  15. Simboti1

    User Defined Recordset in VB 6

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

    Sending SMS messages from VB 6.0

    What is the code to send an SMS message from a VB application?
  17. 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...
  18. 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?
  19. 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...
  20. 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...

Part and Inventory Search

Back
Top