Databases and recordset

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • dfg

    Databases and recordset

    Hi. I am doing some basic database stuff - read, add, delete, change etc.

    The database contains names.

    One of the things I'm trying to do is whenever I delete an item from the
    database is to show a message box with the the current name of the
    record I'm deleting...Kind a like so:

    intRetValue = MsgBox("Are you sure you want to delete " &
    adSaleData.Reco rdSet.????? & " from the database?"

    Any ideas?

    Thanks.

  • dfg

    #2
    Re: Databases and recordset

    dfg wrote:
    [color=blue]
    >
    > Any ideas?
    >[/color]

    Sorry guys, I figured it out.

    Comment

    • JR

      #3
      Re: Databases and recordset

      dfg <[email protected]> wrote in message news:<YGDvb.454 594$pl3.191261@ pd7tw3no>...[color=blue]
      > Hi. I am doing some basic database stuff - read, add, delete, change etc.
      >
      > The database contains names.
      >
      > One of the things I'm trying to do is whenever I delete an item from the
      > database is to show a message box with the the current name of the
      > record I'm deleting...Kind a like so:
      >
      > intRetValue = MsgBox("Are you sure you want to delete " &
      > adSaleData.Reco rdSet.????? & " from the database?"
      >
      > Any ideas?
      >
      > Thanks.[/color]


      Put the name of the recordset followed by the column number where the
      name is in your database.

      example: msgbox namerecordset[4] => The fifth column value will
      display his value now

      Comment

      Working...