ACCESS FEED: RE: [MS_AccessPros] How did I do this?

Kamis, 15 Maret 2012

RE: [MS_AccessPros] How did I do this?

Tiffany-

You didn't do anything except perhaps define a relationship between the table
Assets and the second one. It's called a subdatasheet, and it's a bad idea for
performance because every time you open the Asset table, Access also opens the
related table. You can remove it by opening the table in Design view, opening
the Properties window, and setting the Subdatasheet Name property to [None].
You also need to turn off Name AutoCorrect, or the change won't "stick." Click
the Office button, choose Access Options, then select Current Database. Under
Name AutoCorrect Options, turn off Perform name AutoCorrect.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

================
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of cc0623
Sent: Thursday, March 15, 2012 6:31 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] How did I do this?

I have two tables Assets and tblunitmonthmileage and I noticed that when I have
the Assets table open there is a plus sign in front of the row and when I click
on it I can see the data associated with the Unit in Assets from
tblunitmonthmileage.

Can I add more Links? to another table with data that is associated with the
unit? How might I do this?

Tiffanny