Substitution of variable contents in a command

T

TerryL

Some languages allow you to force the interpreter to evaluate the contents of
a variable in a command before the command is executed. Is there a way to
do this in VBA. Here is an example.

The objective is to develop a common routine to apply a set of
transformation rules to the contents of a field in a table. The name of the
table and the name of the field is supplied to the routine in string
variables. The table name is not a problem since the OpenRecordSet command
uses a string for the table name. It is the field name I am having a problem
with. In the update section the logic looks like:

recordset.Edit
recordset!FieldnameVariable = strfieldvalue
recordset.Update

Where both FieldnameVariable and strfieldvalue are string variables defined
in DIM statements. The value of FieldnameVariable changes with the table
name supplied. As the code is presented above, you get an error because
"FieldnameVariable" is not a column name defined in any table. If the
contents of FieldnameVariable is "ActualFieldName", how can I force VBA to
substitute the variable contents in the command so it looks like:

recordset!ActualFieldName = strfieldvalue

when it gets excuted.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to copy table of contents to a new doc 0
Use a variable in a ShapeRange.Increment 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Adding Heading to Table of Contents after a column break 1
Lost my Table of Contents , Appendices and Page numbers ? 2
Macro for Table of Contents 2
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Unreadable text when viewing organization chart in Web version of Visio 365 0

Top