Create Structure (1 Viewer)

A

amerifax

Registered User.

Local time

Today, 00:51

Joined

Apr 9, 2007

Messages

304

• Jun 14, 2013

• #1

Some time ago I watched a technician creating structure from a table, using 2013, as fast as 123. I have been looking through the menu system in Access, and can't find how to accomplish this. Saving active table as a structure.

Bob

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Today, 01:51

Joined

Feb 19, 2002

Messages

43,257

• Jun 14, 2013

• #2

Copy a table (cntl-c) and then paste it (cntl-v). The paste dialog will give you the option of saving only the structure but no data. There are similar options using the get external data (ribbon tab) option. You need to select a table and then click the options button. Choose the import option you want.

 

A

amerifax

Registered User.

Local time

Today, 00:51

Joined

Apr 9, 2007

Messages

304

• Jun 16, 2013

• #3

Thanks for the help Pat.
Bob

 

S

smithdavid

Registered User.

Local time

Yesterday, 22:51

Joined

Jun 26, 2013

Messages

13

• Jun 26, 2013

• #4

Search on google to form the structure.

 

A

amerifax

Registered User.

Local time

Today, 00:51

Joined

Apr 9, 2007

Messages

304

• Jun 26, 2013

• #5

hi David. I you talking about the topic that I left about trying to put together my linked forms. If so, I have been to many forums and never got off to first base. Eight months later and I'm still trying to figure out how to do it.

If you're talking about the above structure it worked out great, using the help I got from Pat. Actually, I ended up sharing it with the Microsoft technician I'm working with Re: memory limitations.
Bob