Pictures in forms

[merc007]

I have a billing database that I use to store bills that are due and bills that have been paid. When a bill is paid I scan the check and the bill associated with it to a specific folder labeled under the account number. I have about 30 different accounts i.e. 30 different folders associated with them. I'm trying to create a button that when pressed will open up the folder that goes with the account... Is there an easy way of doing this?

 

[PHV]

A starting point:
Application.FollowHyperlink "\path\to\folder"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[merc007]

Would that know to change per record?

Example:

Record: 1 = Bill 5
Record: 2 = Bill 7
Record: 3 = Bill 2

 

[PHV]

How is the folder's pathname related to the current record ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[merc007]

Its not related at all... I have a Master folder set like this:

Accounts/Bills

And then another folder like this

Accounts/Checks