Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Access Field List

Name: seawatch
Date: January 20, 2005 at 12:01:15 Pacific
OS: Win2K
CPU/Ram: 2.8ghz, 512meg

Comment:

I'm using Office Xp. In Access 97 I used to be able to link table A and Table B and have them show up in Field List. The tables are in a 1 to many relationship. However I cannot remember how to build a form using the tables. I've used the Wizard, which works fine, but in the Design View the Field List button is greyed out. Would someone refresh my memory on how to use the field list?

Name: seawatch
Date: January 20, 2005 at 14:30:45 Pacific

Reply:

I found it. Ran a query. Saved the Query. Opened a new form in Design view. Went up to the corner where the rulers meet. Selected Properties, All. Then record source and my query popped up on the list. Selected it and thr form list was active. Yeaaah!!

0

importing from outlook to...

Word - NO menus at top of...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I'm trying to create a field in a table MS Access that writes a string dependent on a series of Yes/No fields. I would prefer to do this without a macro, but using an update query would work fine. H...

Summary: Access 2002 - SQL Server 7.0 We have a SQl database with a huge number of fields, and I want to create an Access database and some of the fields will link to some of the SQl fields (for only viewing t...

Summary: File, Print will print any form. I guess I just don't understand the question. Does this form have a field list and you just want to print the form design without any data in the fields? Life is mor...