Computing.Net > Forums > Office Software > adding fields in form

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

adding fields in form

Reply to Message Icon

Name: Neo
Date: July 1, 2003 at 00:05:31 Pacific
OS: Windows XP
CPU/Ram: Intel/512MB
Comment:

I am having a problem in Access 2002 and was wondering if
> anyone came across it. I have a table that requires more
> than 255 fields and because Access does not allow this, I
> created two tables of about 200 fields in them. Now, the
> problem is when I design a form I need fields from both
> these tables. I tried creating sub-forms but it slows the
> speed of the computer as we have thousands of data.
>
> Do you know if there is a way to include fields from
> different tables into a form without using sub-forms? Or
> if there are any add-ins for this?
>
>
> My experience with Access is reasonable but I am not
> familiar with coding yet. Any help will be highly
> appreciated. Thanks



Sponsored Link
Ads by Google

Response Number 1
Name: seawatch
Date: July 1, 2003 at 10:54:39 Pacific
Reply:

Run a query on both tables for all fields. Save the query, build a form from the query.

Larry


0
Reply to Message Icon

Related Posts

See More







Post Locked

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


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: adding fields in form

Linking Fields in Forms www.computing.net/answers/office/linking-fields-in-forms/2315.html

listing joind fields in Access 2002 www.computing.net/answers/office/listing-joind-fields-in-access-2002/4741.html

format fields in a record? www.computing.net/answers/office/format-fields-in-a-record/806.html