Rabu, 04 April 2012

Re: [MS_AccessPros] Re: Display backend file path and file name

 

Biil,
That was outstanding.  I like it when it's that simple... :)

With warm regards,

Arthur Lorenzini
Sioux Falls, South Dakota

________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, April 4, 2012 4:07 PM
Subject: [MS_AccessPros] Re: Display backend file path and file name


 

Art

The path is stored in the hidden MSysObjects table. A quick DLookup would be something like:
DLookup("Database", "MSysObjects", "Name='YourTableNameGoesHere'")

To see the tables in 2003, Click on Tools>Options>View. Check the box for System Tables.

In 2007/2010, Right-click the Navigation Pane header. Select Navigation Options.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca

--- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@...> wrote:
>
> Is there a way to display the path and name of the backend file in a text box?
>
> Thanks
>
> Art Lorenzini
> Sioux Falls
>

[Non-text portions of this message have been removed]

__._,_.___
.

__,_._,___

Tidak ada komentar:

Posting Komentar