Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using eval() for flexible recordset fieldnames
There should also be an assignment at the end emptyfield=true otherwise the function will return false even when it is successful.- LouieLyle
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using eval() for flexible recordset fieldnames
Use the following syntax rs(fieldname)="" This works even if the fieldname has spaces in it. You do not need string delimiters around fieldname because it is a variable. However, if the field does not accept zero length values the procedure will raise an error. This is a setting in...- LouieLyle
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
