Recent content by shirley_kee

ok... am so sorry guys... cheers..

Does anybody know how to use recordset.moveprevious? I'm using Access 2000. I want to use moveprevious function but it generates an error. Following are my codes and I've attached the error screen. Thanks a lot... Private Sub cmdPrev_Click() If rstProceeds.BOF <> True Then...

Does anybody know how to use recordset.moveprevious? I'm using Access 2000. I want to use moveprevious function but it generates an error. Following are my codes and I've attached the error screen. Thanks a lot... Private Sub cmdPrev_Click() If rstProceeds.BOF <> True Then...

Dim dsRecordSet As ADODB.Recordset Dim cmdAuctioneer As ADODB.Command Dim sSQL As String Set dsRecordSet = New ADODB.Recordset Set cmdAuctioneer = New ADODB.Command On Error Resume Next dsRecordSet.Open "tblAuctioneers", CurrentProject.Connection, adOpenStatic...

Thankx a lot Rat. Really appreciate it. I've been cracking my brain few hours figuring out what's wrong with it... Am downloading the software and will try it.

Please help. My access prompt out this error when i used combo box wizard Method 'Connection' of object ' _CurrentProject' Failed. I couldn't use this VBA Command as well "CurrentProject.Connection". Does anybody know how to solve this. I've tried reinstalling ms access but the problem...