Recent content by Simboti1

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