Prev: downgrade from microsoft 2007 to 2002
Next: How To Change Form RecordSet
From: Duck on 4 Jul 2008 09:17
I am creating a client database in which I want to also store client
photos. The photos are stored in a subfolder of the folder in which
the database is created. How can I indicate in my VBA code which
populates the unbound image frame, the relative location of the
photos
folder (relative to folder in which the database is created). I want
to be able to move the database to a different folder on different
computers.
From: Dennis on 4 Jul 2008 09:39
CurrentProject.Path will give you what you want

"Duck" wrote:

> I am creating a client database in which I want to also store client
> photos. The photos are stored in a subfolder of the folder in which
> the database is created. How can I indicate in my VBA code which
> populates the unbound image frame, the relative location of the
> photos
> folder (relative to folder in which the database is created). I want
> to be able to move the database to a different folder on different
> computers.
>
From: Linq Adams via AccessMonster.com on 4 Jul 2008 09:41
CurrentProject.Path

will give you the location of the database. I use this code to archive
reports using snapshots of them. They're located in a subfolder of the folder
holding the database. You can use the same technique for your photos.

'Path to sub-folder for report archives...sets up Archive folder if itr
doesn't exist
mypath = CurrentProject.Path & "\Archive"
'If directory doesn't exist creates it
If Dir(mypath, vbDirectory) = "" Then MkDir mypath

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/200807/1

From: a a r o n . k e m p f on 4 Jul 2008 11:28
keep your data in SQL Server and you won't have problems like this
you could always say 'select * from sysfiles'





On Jul 4, 6:17 am, Duck <charles.kendri...(a)charter.net> wrote:
> I am creating a client database in which I want to also store client
> photos.  The photos are stored in a subfolder of the folder in which
> the database is created.  How can I indicate in my VBA code which
> populates the unbound image frame, the relative location of the
> photos
> folder (relative to folder in which the database is created).  I want
> to be able to move the database to a different folder on different
> computers.

From: So Sorry For Poor Aaron on 6 Jul 2008 18:41
"a a r o n . k e m p f @ g m a i l . c o" wrote:

> keep your data in SQL Server

Him jailbird, don know nuttin else, don know how, neither, dumb as dry dirt.
 |  Next  |  Last
Pages: 1 2
Prev: downgrade from microsoft 2007 to 2002
Next: How To Change Form RecordSet