P
pingala
Hi All,
i'm bit frustrated as all my users are reporting a weird behaviour
from one of our access database. It is an ADP application on SQL
Express 2005 as backend using Access 2003.
No problem of this sort has been reported whatsoever, and no change
have been done to either the dbase structure or the vba code since the
problem came out.
to be very concise, when a form open it will load -using the bookmark
method- the first record available. this is the code:
Dim rs As New ADODB.Recordset
Set rs = Me.Recordset.Clone
rs.MoveFirst
rs.Find "[IdItemOrdered] = " & Me![machineList], 0, 1, 1
If rs.EOF = False Then
Me.Bookmark = rs.Bookmark
End If
Set rs = Nothing
where Me!machineList contains an ID previously checked with a direct
SQL query if it exist or not ... only then the control move over this
procedure ...
when i debug i can see the Me!machineList correctly populated, but
when it performs the Find method it found
nothing setting rs.EOF to True .. and so skipping the bookmark
operation.
Now this happen only on some records, while it doesn't happen on
others.. and there is no differences between these records... of
course the content is different but they contains the same amount of
data ...
any idea?
i'm completely lost.
thanks
T.
i'm bit frustrated as all my users are reporting a weird behaviour
from one of our access database. It is an ADP application on SQL
Express 2005 as backend using Access 2003.
No problem of this sort has been reported whatsoever, and no change
have been done to either the dbase structure or the vba code since the
problem came out.
to be very concise, when a form open it will load -using the bookmark
method- the first record available. this is the code:
Dim rs As New ADODB.Recordset
Set rs = Me.Recordset.Clone
rs.MoveFirst
rs.Find "[IdItemOrdered] = " & Me![machineList], 0, 1, 1
If rs.EOF = False Then
Me.Bookmark = rs.Bookmark
End If
Set rs = Nothing
where Me!machineList contains an ID previously checked with a direct
SQL query if it exist or not ... only then the control move over this
procedure ...
when i debug i can see the Me!machineList correctly populated, but
when it performs the Find method it found
nothing setting rs.EOF to True .. and so skipping the bookmark
operation.
Now this happen only on some records, while it doesn't happen on
others.. and there is no differences between these records... of
course the content is different but they contains the same amount of
data ...
any idea?
i'm completely lost.
thanks
T.