[AccessD] Bang v. Dot

[Arthur Fuller]

Thanks  Stuart.

On Fri., Aug. 6, 2021, 6:28 a.m. Stuart McLachlan, <stuart at lexacorp.com.pg>
wrote:

> Prior to 2007, Access was very forgiving and you could mix up dots and
> bangs with fewer
> problems.
>
> In 2007, MS tightened it up and applied the rules more consistently.
>
> In essence:
> A bang (!) indicates that what follows is a element of a collection.
> A dot (.) means a property, collection, or method name.
>
> For recordsets.
> rs.Addnew  '  method so it's a dot
> rs!Firstname = "Fred"   'it's an element of the recordset collection so a
> bang
> rs.Update ' again a method, so a dot.
>
>
> --
> Stuart
>
> On 6 Aug 2021 at 4:09, Arthur Fuller wrote:
>
> > When working with recordsets; I have seen both bang (rs!) and dot
> > (rs.) References. Wh6 is the difference? -- AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd Website:
> > http://www.databaseadvisors.com
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>