referring to a field in a table in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was sure that I knew this but...

How do I retrieve the value from a field in Visual Basic? I am using a
table to store some constants and want to use them in some code.
Thank you
Alice
 
Alice Dawson said:
I was sure that I knew this but...

How do I retrieve the value from a field in Visual Basic? I am using a
table to store some constants and want to use them in some code.
Thank you
Alice
Click to expand...

Dlookup("FieldName", "TableName", "Criteria")
 
You must log in or register to reply here.

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

VBA - retrieve data on last create named range from previous inserted named range 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
acnewrec? 1
Basic Form Examples in Access. 4
Reference a cell in a named range 1
How to Populate Data from a table to another 0
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Combining two fields in a table 2

Back
Top