dcsimg

Search:

Type: Posts; User: Siachin

Search: Search took 0.02 seconds.

  1. MsOf03 Unable to set Installed property of Add in class-Excel error Citrix

    Hi
    I have access to this application on citrix server via their website.The application launches an excel utility and only that application has that vb code where all add ins are getting...
  2. Access report in ADP pulling different data via SP than the BE data shown

    I have an access report which calls a SP from its designer ie. i have set the RecordSource property to that as :-
    dbo.uisp_RptJobSummary and i have also set the property for Input Parameters to...
  3. Error:2427 you entered an expression that has no value while using reports in ADP

    I have an ADP project that prints some reports and it was working fine with sql server 2000 but we migrated the entire database to sql server 2008 but i am not able to print reports now...
  4. Error while entering records to excel using JET

    I am having problem with the below code when i try to insert records into it
    With RS
    Do Until .EOF
    rstExcelReordset.AddNew
    ...
  5. Re: Problem while Writing into excel without using office objects

    Thanks for responding.
    I am bound to use this format and formatting can be done by writing the formatting code in a template ,right?
    I am looking into your code bank,it would be helpful if you can...
  6. Problem while Writing into excel without using office objects

    I am frustrated over something big...i have automated a report which worked fine over my machine but it gave error while scheduling it on sql server and when i enquired i came to know that there is...
  7. MsOf03 Re: Problem while copying data from recordset to excel

    I want to apply this code if the records exceed 65535 limit of excel sheet.
    But right now i am trying it for 130 records or so ,just to make sure they are multiple sheets after each 10 records.
    I...
  8. MsOf03 Problem while copying data from recordset to excel

    I am using below code

    cnt.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source=" & "C:\work\User Audit Tool\AuditReports\;" & _
    "Extended Properties=""Text;HDR=No;"""...
  9. Replies
    11
    Views
    1,972

    Re: Error ActiveX can't create object in VB6

    Thanks it worked perfect on my machine but i used late binding to try to solve problem when running it on Server but again it run as failure on Server with the below code giving me error:-

    Dim...
  10. Replies
    11
    Views
    1,972

    Re: Error ActiveX can't create object in VB6

    Thanks for responding regarding Late binding part.I did try this(i still need to see the results if they are fine or not) but i am getting error at below line now

    WS.Cells(2, 1).Select...
  11. Replies
    11
    Views
    1,972

    Re: Error ActiveX can't create object in VB6

    Even i use the code you mentioned i get error at the very first line
    ie. Set xls=New Excel.Application

    i don't know why is it not working on server ,though i can run it fine on my machine....
  12. Replies
    11
    Views
    1,972

    Re: Error ActiveX can't create object in VB6

    Thanks for making that nice tutorial but i am not able to use the built-in variables like xlContinuous,xlVerticalInside and Selection.ColumnWidth ...can you please suggest how to deal with them?
  13. Replies
    11
    Views
    1,972

    Re: Error ActiveX can't create object in VB6

    Hi

    NewWB.Add-----sorry but there is no thing like this in VB6 ,can you please be more clear..:(
  14. Replies
    11
    Views
    1,972

    Error ActiveX can't create object in VB6

    I have this report that i am building which works fine on my machine

    But below code is giving error "ActiveX can't create object" when i run it on a SQL server

    Dim NewWB as Workbook

    Set...
  15. Re: Error while function returning recordset in VB6

    i think i am stupid could not see i didn't add exit function before error handler so it was going inside error handler.....arghhhhhhh
    Thanks JCIS for you response too i had SET...
  16. Re: Error while function returning recordset in VB6

    No i am using an error handler and it just shows in which function error has occurred but nothing in name of description..
  17. Error while function returning recordset in VB6

    i have a function
    Public Function Recon(strRe As String) As ADODB.Recordset
    --do something with the query string and then pass it on to other function

    Recon=SelectRS(strRe)

    Exit function
    ...
  18. Re: Current provider does not support returning multiple recordsets from a single exe

    Hi,thanks for responding so quick.
    So when i try the code you mentioned it throws me error:"Operation is not allowed when the object is open."
  19. Re: Current provider does not support returning multiple recordsets from a single exe

    Yes,you are right about cursortype and all but i don't have much knowledge about them...you can call me a newbie
    Here is what the the VBA code looks like for proc call:

    RS.Open...
  20. Re: Current provider does not support returning multiple recordsets from a single exe

    Umm..i am using a class's object which has all connection related settings which further accesses a DAL so i believe i can't change the code in DAL as it is standard over here.
  21. Re: Current provider does not support returning multiple recordsets from a single exe

    I am using a USP
    Set RS = objADO.GetRS("exec usp_Rev_DumpTransferred 'PR5001','2009-02-28','2009-03-30'")

    As i can see into procedures it has got lot of SELECT statements so it means lots of...
  22. Current provider does not support returning multiple recordsets from a single executi

    Hi
    I am trying to convert a VBA code into VB one but i stuck with the recordset problem because in VBA the connection is open so it can access diff' recordsets one by one but in case of VB it...
Results 1 to 22 of 22



Featured


Click Here to Expand Forum to Full Width