Bill,
I think I will need a dollar. I added it to my form load event added the text box with the exact name as txtFileLocation and I still see nothing in the text box.
Me.txtFileLocation = DLookup("Database", "MSysObjects", "Name='NewHires'")
Jim Wagner
________________________________
________________________________
From: Art Lorenzini <dbalorenzini@yahoo.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, April 4, 2012 3:17 PM
Subject: Re: [MS_AccessPros] Re: Display backend file path and file name
My two cents
I put it in my form load.
Private Sub Form_Load()
Me.txtFileLocation = DLookup("Database", "MSysObjects", "Name='tblUnit'")
End Sub
With warm regards,
Arthur Lorenzini
Sioux Falls, South Dakota
________________________________
From: Jim Wagner <luvmymelody@yahoo.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, April 4, 2012 5:08 PM
Subject: Re: [MS_AccessPros] Re: Display backend file path and file name
Bill,
I cannot get the expression to work. I kind of came into the thread a little late. I put it on a text box on a form. Can you explain it a little clearer for the challenged.
Jim Wagner
________________________________
________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, April 4, 2012 2:42 PM
Subject: [MS_AccessPros] Re: Display backend file path and file name
You're welcome, Art. If you poke around in the system tables you'll find all kinds of cool stuff.
Bill
--- In MS_Access_Professionals@yahoogroups.com, Art Lorenzini <dbalorenzini@...> wrote:
>
> 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@...>
> 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]
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar