[AccessD] Recordset references

jack drawbridge jackandpat.d at gmail.com
Mon Sep 6 16:33:26 CDT 2021


Arthur,

Use [First  Name]  -s

On Mon, Sep 6, 2021 at 5:28 PM Arthur Fuller <fuller.artful at gmail.com>
wrote:

> Given a DAO recordset based on a table, some of whose fieldnames contain
> spaces, how does on refer to them?
> For example:
> stEmployees!FirstName
>
> Down't work because the actual fieldname is "First Name" not FirstName
>
> Do I wrap the actual first name fieldname in quotes after the bang? Or
> what?
>
> Thanks.
>
> --
> Arthur
> --
> 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