Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: DAO Information for newbies

Discussion in 'Information Technology' started by Dirk Goldgar, Jul 28, 2006.

  1. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "HK" <Harlan.Koehn@gmail.com> wrote in message
    news:1147106844.540847.101840@i40g2000cwc.googlegroups.com
    > I sure appreciate the help here. I'm a very inexperienced programmer
    > and I don't reference the DAO object at all. My code typically looks
    > like:
    >
    > My.Recordsource = "Select * from tblNewbie"
    > Me.Requery
    >
    > I do like the input I'm getting. Thanks and keep it coming.


    That code doesn't use DAO *or* ADO at all; at least, not directly.
    There, you're manipulating an object that is defined by Microsoft Access
    itself: the Form object. (But "My.Recordsource" is likely to be a typo,
    and should be "Me.RecordSource".)

    Note, by the way, that when you change a form's RecordSource property,
    there's no need to requery it. Access automatically requeries the form
    when you change its recordsource.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     
  2. Loading...


Share This Page