Keep getting .NoMatch!

Discussion in 'Microsoft Access Getting Started' started by Guest, May 17, 2006.

  1. Guest

    Guest Guest

    The help I found here has much improved my prospects for making this form do
    what I need, but this code fails to find the record, though it runs. It runs
    from VBA, and MchDonANDI is a field in the form's RecordSource query. Where
    should I start looking for my (next) flaw?

    Dim rst As DAO.Recordset
    Set rst = Me.RecordsetClone
    With rst
    ..FindFirst "[MchDonANDI]= '1204749'"
    End With

    Thanks in advance
    --
    Dave
     
    Guest, May 17, 2006
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    Private Sub UseRealFieldName_AfterUpdate()
    Dim rs As Object

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[MchDonANDI] = " & Str(Me![MchDonANDI])
    Me.Bookmark = rs.Bookmark
    End Sub


    Try this on the AfterUpdate on your text box (UseRealFieldName), hope it helps

    --
    Wayne




    "David Habercom" wrote:

    > The help I found here has much improved my prospects for making this form do
    > what I need, but this code fails to find the record, though it runs. It runs
    > from VBA, and MchDonANDI is a field in the form's RecordSource query. Where
    > should I start looking for my (next) flaw?
    >
    > Dim rst As DAO.Recordset
    > Set rst = Me.RecordsetClone
    > With rst
    > .FindFirst "[MchDonANDI]= '1204749'"
    > End With
    >
    > Thanks in advance
    > --
    > Dave
     
    Guest, May 17, 2006
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    OOOPS - sorry

    Private Sub UseRealFieldName_AfterUpdate()
    Dim rs As Object

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[UseRealFieldName] = " & Str(Me![UseRealFieldName])
    Me.Bookmark = rs.Bookmark
    End Sub
     
    Guest, May 17, 2006
    #3
  4. Guest

    Guest Guest

    Sorry about this - it's late and I'm a bit stupid at this time of night.


    Private Sub UseRealFieldName_AfterUpdate()
    Dim rs As Object

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[MchDonANDI] = " & Str(Me![UseRealFieldName])
    Me.Bookmark = rs.Bookmark
    End Sub
     
    Guest, May 17, 2006
    #4
  5. Guest

    Guest

    DAO is crap don't listen to these idiots.

    MDB files are obsolete; wake up and smell the coffee kid
     
    , May 22, 2006
    #5
  6. Guest

    Terry Kreft Guest

    From this and other posts I suspect you're just a troll, but there is the
    possibilty that you're actually incompetent and prefer to blame the tool.

    --

    Terry Kreft


    <> wrote in message
    news:...
    > DAO is crap don't listen to these idiots.
    >
    > MDB files are obsolete; wake up and smell the coffee kid
    >
     
    Terry Kreft, May 23, 2006
    #6
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. msmcnewsxp

    keep subforms on tab control in sync

    msmcnewsxp, Sep 16, 2003, in forum: Microsoft Access Getting Started
    Replies:
    0
    Views:
    266
    msmcnewsxp
    Sep 16, 2003
  2. Sally

    Export with pipes delimited but keep fixed length!?!

    Sally, Feb 10, 2004, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    925
    Nikos Yannacopoulos
    Feb 10, 2004
  3. David Garlikov

    Numbers keep rounding up

    David Garlikov, Jul 5, 2004, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    202
    JulieD
    Jul 5, 2004
  4. Box 666

    Trim and keep

    Box 666, Sep 24, 2004, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    184
    Ken Snell [MVP]
    Sep 24, 2004
  5. Guest

    I keep getting a syntex error mising operator

    Guest, Feb 25, 2005, in forum: Microsoft Access Getting Started
    Replies:
    2
    Views:
    313
    Van T. Dinh
    Feb 25, 2005
  6. Guest

    I keep getting message telling me I need to install ocr software

    Guest, Oct 20, 2005, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    232
    Rick B
    Oct 20, 2005
  7. Guest

    why do i keep getting spam

    Guest, Mar 3, 2006, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    354
    Rick B
    Mar 3, 2006
  8. K90267000 via AccessMonster.com

    Files keep getting bigger

    K90267000 via AccessMonster.com, Apr 10, 2007, in forum: Microsoft Access Getting Started
    Replies:
    5
    Views:
    576
    Guest
    Apr 10, 2007
Loading...