record number in recordset

[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

 

[Marshall Barton]

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

You can use the AbsolutePosition property.

 

[bob]

does not work for me

-----Original Message-----



You can use the AbsolutePosition property.

 

[Marshall Barton]

does not work for me

Would you care to share what you are doing?

What does "not work" mean?

 

[bob]

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"

 

[Marshall Barton]

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"

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.

 

[bob]

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-----

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"

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

.

 

[Tim Ferguson]

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

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

 

[Marshall Barton]

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

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.