I can refer to some, but not all, of the fields in the RecordSource of a Form in the VBA code-behind. I have been careful to name the controls which provide data display/entry for the fields differently from the fields, and to name any variables differently from both fields and controls.
If I reference certain fields in an expression, I get a compile-time error "Variable not defined". Also, the same field names that throw...
2 results in 0.0022 seconds.
-
BarksWorseThan started a topic "Variable not defined"; VBA and Intellisense using outdated table schemain Access"Variable not defined"; VBA and Intellisense using outdated table schema
-
how to get the ID autonumber field to be added when importing
I am doing the
TransferText method to import a tab delimited file. I am using a saved
specification.
DoCmd.TransferT ext acImportDelim, "myinputspe c", "tblnames", File, True
no autonumber ID is created, how can I fix this?
but when I do it from the access import from menu choice, it adds an ID.
how to do in code.
Thanks...
