Search results

Actually I am new to access so I do not have much idea. I will try to work out with what you said. Thank you.

Go to Tools - Reference -Tick Microsoft ActiveX Data Objects 2.8 library It will work perfectly. :)

Hi Galaxiom! Thank you for the reply. I tried your suggestion but it did not work. There is an error in Set Me.Recordset = rs The error is "The object you entered is not a valid Recordset property" Thank you.

Set cnn = Access.CurrentProject.Connection Set rs = New ADODB.Recordset strsql = "SELECT tblAcqDetails.*,tblItems.* FROM tblAcqDetails,tblItems WHERE tblAcqDetails.fkItemID=tblItems.pkItemID AND tblAcqDetails.fldNote = 'New Stock'" rs.Open strsql, cnn Me.txtID = rs!pkItemID...

Hi everyone! I am able to populate the text box with ADO recordset but i am not able to navigate between the records might be because only first record is displayed and not all. In my navigation button it should come 1 0f 21 but its coming 1 of 1. I am new to access and this is my first...

Hi all members! I am new to this forum as well as access. So, i just wold like to request all members to please bear with me and my silly problems... I hope I will enjoy this forum..:) Thank you.