Search results for 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: - -------------------------------------------------------...

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 & "'" & "," _...

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

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

Hi Ettienne Thanks very much. Is it possible for you to assist with the sample code for the AccpacFiscalCalendar.GetPeriod route? Regards Simboti

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

Thanks DjangMan

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

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

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

Hi Chris I want to develop applications compartible with both ACCPAC 5.4A and 5.5A. So what do you suggest? Regards Simboti

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

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

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

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