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@yahoogroups.com] On Behalf Of access_kri
Sent: Monday, April 15, 2013 9:10 AM
To: MS_Access_Professionals@yahoogroups.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> , "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@yahoogroups.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>
> 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> , "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@yahoogroups.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>
> > 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]
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (7) |
Tidak ada komentar:
Posting Komentar