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]
>
Tidak ada komentar:
Posting Komentar