SQL and Bookmarks

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Gord
    #1

    SQL and Bookmarks

    Is it possible to extract the bookmark using an SQL query?

    I'm using A2007 and have a select query used as the recordsource for a
    subform. The query pulls out those records that match whatever date I
    compare to. When the date criteria matches, I'd like to store a copy of the
    bookmark from the underlying table as well.

    Thanks,

    Gord


    Tags: None
    • Wayne Gillespie
      #2
      Re: SQL and Bookmarks

      On Mon, 10 Nov 2008 01:27:01 GMT, "Gord" <x1gord1x@telus .netwrote:
      >Is it possible to extract the bookmark using an SQL query?
      >
      >I'm using A2007 and have a select query used as the recordsource for a
      >subform. The query pulls out those records that match whatever date I
      >compare to. When the date criteria matches, I'd like to store a copy of the
      >bookmark from the underlying table as well.
      >
      >Thanks,
      >
      >Gord
      >
      Why do you want to store the bookmark?

      Bookmarks are volatile and are recreated (changed) every time the recordset is
      opened or requeried so there is generally no use in storing them.

      Do you have a specific need?

      Wayne Gillespie
      Gosford NSW Australia

        Comment

        Previous template Next
        Working...