record number in recordset

  • Thread starter Thread starter bob
  • Start date Start date
B

bob

I use the rs.index and rs.seek and it works fine. I am
looking to get the exact row that the rst is at. I have
tried with no luck using the bookmark. any help would be
greately appreciated
 
bob said:
I use the rs.index and rs.seek and it works fine. I am
looking to get the exact row that the rst is at. I have
tried with no luck using the bookmark. any help would be
greately appreciated
Click to expand...


You can use the AbsolutePosition property.
 
by "not work" i mean that after i try to set a bookmark I
would think (probably wrong) that I could do a msgbox
boomark and get something to display. I get a "?" in the
box
Here is the quick scenario.

My forms have the same name as my tables. I want to limit
the "find" fields to those that have an index. Then be
able to move the current displayed record on the form to
the "find" value. I was hoping to use variables so that I
can use the procedure over and over without lengthy
changes. I have all the pieces except syncing the "seek"
value with the "form value"
 
bob said:
by "not work" i mean that after i try to set a bookmark I
would think (probably wrong) that I could do a msgbox
boomark and get something to display. I get a "?" in the
box
Here is the quick scenario.

My forms have the same name as my tables. I want to limit
the "find" fields to those that have an index. Then be
able to move the current displayed record on the form to
the "find" value. I was hoping to use variables so that I
can use the procedure over and over without lengthy
changes. I have all the pieces except syncing the "seek"
value with the "form value"
Click to expand...

Do you check NoMatch after the Seek? Are you sure you're
assigning the recordset's bokmark to the form's bookmark?
Do you trap all errors? Is the recordset opened with
dbOpenTable?

It sounds like you need debugging help here, but we'll have
to see the relevant code before anyone can provide useful
help with that.
 
you can see the code sample in the post called "code
example" dated february 19.

It does not have the bookmark statements because i havent
gotten them to work. any suggestions to that code would be
very helpful
-----Original Message-----
bob said:
by "not work" i mean that after i try to set a bookmark I
would think (probably wrong) that I could do a msgbox
boomark and get something to display. I get a "?" in the
box
Here is the quick scenario.

My forms have the same name as my tables. I want to limit
the "find" fields to those that have an index. Then be
able to move the current displayed record on the form to
the "find" value. I was hoping to use variables so that I
can use the procedure over and over without lengthy
changes. I have all the pieces except syncing the "seek"
value with the "form value"
Click to expand...

Do you check NoMatch after the Seek? Are you sure you're
assigning the recordset's bokmark to the form's bookmark?
Do you trap all errors? Is the recordset opened with
dbOpenTable?

It sounds like you need debugging help here, but we'll have
to see the relevant code before anyone can provide useful
help with that.
--
Marsh
MVP [MS Access]


would
be
Click to expand...

.
Click to expand...
 
I
would think (probably wrong) that I could do a msgbox
boomark and get something to display. I get a "?" in the
box
Click to expand...

The bookmark is technically as string, but it's not restricted to visible
ASCII codes -- this is explicitly documented in help files. If you pass a
string containing control codes to a MsgBox, you should not be surprised to
get something odd back.

B Wishes


Tim F
 
bob said:
you can see the code sample in the post called "code
example" dated february 19.

It does not have the bookmark statements because i havent
gotten them to work. any suggestions to that code would be
very helpful
Click to expand...

You have two threads going on the same question? What a
waste of everyone's time.

I see that Tim and Bas are giving you some good advice so
I'll retire from this confusion.
 
Back
Top