ACCESS FEED: RE: [MS_AccessPros] Re: Path of back-end in Access 2007

Senin, 15 April 2013

RE: [MS_AccessPros] Re: Path of back-end in Access 2007

You are welcome Kumar,

Glenn

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of access_kri
Sent: Monday, April 15, 2013 12:21 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Path of back-end in Access 2007

Thanks Glenn,
Now, I am getting the path of the backend table Usys_codeTCL.

Thanks and Regards,
Kumar

--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Glenn Lloyd"
<argeedblu@...> wrote:
>
> This code:
>
>
>
> dlookup("database","msysobjects","database <> '' AND foreignname =
> 'USys_codeTCL'")
>
>
>
> should do it.
>
>
>
> NOTE: I have highlighted in red where you should have single quotes
> (apostrophes) and not double quotes.
>
>
>
> Glenn
>
> From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of access_kri
> Sent: Monday, April 15, 2013 9:10 AM
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: [MS_AccessPros] Re: Path of back-end in Access 2007
>
>
>
>
>
> Glenn,
> There are several backends but the form is based on backend file
> "Usys_codeTCL". I want the path of this table to be displayed on the form.
I
> tried to modify your code but it does not work.
> Please help.
>
> Kind Regards,
> Kumar
>
> --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "Glenn Lloyd"
> <argeedblu@> wrote:
> >
> > If you have only a single backend then you can get the full path to the
> > backend by looking it up in msysobjects:
> >
> >
> >
> > Dim strBEPath as string
> >
> >
> >
> > strBEPath =dlookup("database","msysobjects","database <> ''")
> >
> >
> >
> > Glenn
> >
> >
> >
> > From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of
access_kri
> > Sent: Monday, April 15, 2013 8:26 AM
> > To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > Subject: Re: [MS_AccessPros] Path of back-end in Access 2007
> >
> >
> >
> >
> >
> > Glenn,
> > Thanks but I want to get the backend path displayed in a form through a
> text
> > box. How to do that in Access 2007?
> >
> > Kind Regards,
> > Kumar Iyer
> >
> > --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com> , "Glenn Lloyd"
> > <argeedblu@> wrote:
> > >
> > > Kumar,
> > >
> > >
> > >
> > > You can get the backend path from the table MsysObjects Database
field.
> > >
> > >
> > >
> > > Glenn
> > >
> > >
> > >
> > > From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of
> access_kri
> > > Sent: Monday, April 15, 2013 7:45 AM
> > > To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > Subject: [MS_AccessPros] Path of back-end in Access 2007
> > >
> > >
> > >
> > >
> > >
> > > Dear All,
> > > I converted my Acess2000 database into Access 2007. I used to get the
> path
> > > of back end displayed a textbox using in
> > > txtPath=Mid([currentdb].[TableDefs]("Usys_CodeTCL").[Connect],11).
> > However,
> > > in Access 2007, the textbox is displaying #Name? error. How to get the
> > path
> > > in Access 2007?
> > >
> > > Thanks and Regards,
> > > kumar
> > >
> > >
> > >
> > >
> > >
> > > [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]