Hot to jump to or find a specific field name in a table

[VonFlorida]

Does anyone know how to quickly locate and/or jump to a known field name? I have a database table containing a lot of fields, and I want to go to a specific field, but the Find feature in Access only searches the data, not the field names. Locating the field name manually is turning out to be extremely tedious. Thank you in advance for any suggestions.

 

[KenReay]

Hi

Do not quite understand your question


Suggest you look up DAO.Tabledefs collection, (in help)
you can address fields directly using the syntax tdf.Fields("MyFieldNAme&quot, wgere tdf is a tabledef object pointing to the required table



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[JeremyNYC]

It sounds to me as if the OP is working directly in the tables. That's generally considered a very risky thing to do.

Make yourself a query that only shows the fields you need, in the order you need.

Then put that in a datasheet-view form.

Then put that in an unbound form.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.