Field Properties in VBA (Primary key, etc)

S

sqluser

Hi,

How do i set the following properties for a field in VBA(Primary Key, Look
Up, Row Source Type, Row Source, etc)?

I am using an ADODB connection/recorset. I have tried using
currentdb.tabledefs(i).fields(i).property(i).value but i don't get any of the
above properties.
 
¹

¹Ú¹®¼ö

sqluser said:
Hi,

How do i set the following properties for a field in VBA(Primary Key, Look
Up, Row Source Type, Row Source, etc)?

I am using an ADODB connection/recorset. I have tried using
currentdb.tabledefs(i).fields(i).property(i).value but i don't get any of the
above properties.
Click to expand...
 

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

ASK Field Formatting 1
VBA word change keys 0
Drop down list control value in vba 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Finding the right style field in VBA 0
Automation of scanned file storage based on content 0
Math in fields using values in Document Properties 3
Finding the proper style field and the numbered paragraph value within the style 0

Top