Recent content by SLKDS

Which reference to be added to use Recordset object in Excel VBA. I added "Microsoft DAO 3.6 Object Library" reference but still its not working. I tried I tried DAO.Reader,but still it is not working. Plz help me on this. Thank in advance Sub t() 'Insert data in DB Dim dbs As Object Dim...

okay. Thank you

its in Outlook

hi thank you. The Item object was not getting initialize and so the below code was not running.

Someone plz provide solution to my issue

Hi, I am trying to capture a newly arrived mail in outlook with respective subject line. The below code works for me on 2010 outlook but when new mail arrive in outlook 2013 ,Mrthod Items_ItemAdd do not get called. Option Explicit Private WithEvents Items As Outlook.Items Private Sub...

Hi, I am trying to capture a newly arrived mail in outlook with respective subject line. The below code works for me on 2010 outlook but not working on 2013 outlook. Option Explicit Private WithEvents Items As Outlook.Items Private Sub Application_Startup() Dim olApp As Outlook.Application...

I'll try that and get back to you. thank you

No,Its text field in my case

Dim dbs As Object Set dbs = CreateObject("Access.Application") dbs.OpenCurrentDatabase "..Path of DB.accdb" Dim rst As Recordset strSQL = "SELECT * FROM Product WHERE OrderNo" _ & " ='" & Order_No & "';" Set rst = dbs.OpenRecordset(strSQL) ----Error line say Object doesn't support this method

I declare recordset as below and tried to set its value: Dim rst As Recordset strSQL = "SELECT * FROM Product WHERE OrderNo" _ & " ='" & Order_No & "';" Set rst = dbs.OpenRecordset(strSQL) ----Error line say Object doesn't support this method

Which reference to be added to use Recordset object in Excel VBA. I added "Microsoft DAO 3.6 Object Library" reference but still its not working. Plz help me on this. Thank in advance

Please someone help me on this...

Hi, I am very new to InfoPath. I want to open existing InfoPath file (where form is already designed) and want to add data in respective controls from XML file. thank you in advance.