[AccessD] Bang v. Dot
Stuart McLachlan
stuart at lexacorp.com.pg
Fri Aug 6 05:28:07 CDT 2021
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
>
More information about the AccessD
mailing list