Duane,
I tried:
SELECT Database
FROM MSysObjects
WHERE Name='tblUnit'
And it returned a blank record. Then I tried:
SELECT Database
FROM MSysObjects
It returned 746 rows which were all blank. The only thing that pops out at me is, does this only work with the database is split?
With warm regards,
Arthur Lorenzini
Sioux Falls, South Dakota
________________________________
From: Duane <duanehookom@hotmail.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, April 4, 2012 9:46 PM
Subject: [MS_AccessPros] Re: Display backend file path and file name
Jim,
Create a query with this SQL:
SELECT Database
FROM MSysObjects
Where Name="NewHires";
What do you see?
Duane
--- In MS_Access_Professionals@yahoogroups.com, Jim Wagner <luvmymelody@...> wrote:
>
> 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@...>
> 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@...>
> 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@...>
> 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]
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar