TY Bill that works, but now another issue. The Database was split. When I attempt to run the application I get a 3044 error indicating "cannot find the be.accdb" How can I re-establish the link to the BE ? Additionally , the physical location of the BE will be relative to the location of the application, ie CurrentProject.Path.
Confussed a little
Terence
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> Terence
>
> VBA has a built-in property to get the directory of the database.
> CurrentProject.Path
>
> 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, "Terence" <buffalome90210@> wrote:
> >
> > I madde a mistake, in one of my systems, I hard coded C:\Tapestry\blah blah....
> >
> > There are a couple a places within the code where files are referd to.
> > My code always refres to "C:\TAPESTRY\FileABC", etc.
> >
> > Customer is moving to a shared drive and therefore C:\TAPESTRY will not be applicable. I do not want to Hard code a folder address. I prefer to use an implicit indicating The Same Folder that the Database is located".
> >
> > What is the prefered way to do this ?
> >
> > terence
> >
>
Selasa, 18 Oktober 2011
[MS_AccessPros] Re: best way to use an implicit folder location of SAME PLACE DB is located ?
__._,_.___
MARKETPLACE
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar