Photo Database

[sokkerkid13]

I have a folder without about 2,000 pictures that I would like to make searchable by an ID that is accompanied with each photo. Is there a good way to create this other than just creating thousands of hyperlinks??

 

[HiTechCoach]

I have a folder without about 2,000 pictures that I would like to make searchable by an ID that is accompanied with each photo. Is there a good way to create this other than just creating thousands of hyperlinks??

Sure. I do this know with an Access database. I tried using hyperlinks but had lots of issues.

Here is a basic example that you can use:
Document Links 2

From a fellow Access MVP, see:
One Awesome Utility -- build a database of all the images on you

 

[sokkerkid13]

This does look like a good solution but unfortunatly I work at a company with a strict no download policy. Is there any ways that I can do this working completely within access?

 

[HiTechCoach]

This does look like a good solution but unfortunatly I work at a company with a strict no download policy. Is there any ways that I can do this working completely within access?

The examples in the links I gave you were done completely in Access. So I do think it can be done completely in Access.

 

[sokkerkid13]

Is there a way in the filetrak system to search just a folder instead of the entire drive?

 

[HiTechCoach]

Is there a way in the filetrak system to search just a folder instead of the entire drive?

Sure. You can modify it to start at any folder level.

 

[sokkerkid13]

Would I need to modify the code for that specific button press? I have never worked with code in access before, im definatly a rookie!

 

[HiTechCoach]

Would I need to modify the code for that specific button press? I have never worked with code in access before, im definatly a rookie!

Here is how you can do this:
1) open in design view the code module named: crystal_FileTrak_ReadFiles
2) in the Function ReadFiles()

3) change one line of code as below:

  ' comment out the original line
  ' mPath = mDrive & ":\"

   mPath = mDrive

Now you can enter now the full path for a folder like this:

C:\Myfolder\MyPictures


Note: The prompt will still say enter a drive letter. I dod not make any changes to that part.

With the change I made above, if you did want to do a entire drive you would need to put in: C:\ not just C

 

[sokkerkid13]

Ah cool very easy!

 

[HiTechCoach]

Glad to hear that worked for you!

 

[sokkerkid13]

There are a few buttons that are on the form that I would like to remove because they do not pertain to my project, but when i delete them i get compiler errors, is there an easier way to do this?

 

[sokkerkid13]

How would you recomend I put a button into the form that would print the jpeg that i have pulled up?

 

[HiTechCoach]

There are a few buttons that are on the form that I would like to remove because they do not pertain to my project, but when i delete them i get compiler errors, is there an easier way to do this?

I would just set the visible property to No.

Before deleting any object you must make sure that ther is not other code that references the object. Yu also need to remove any VBA code attached to any event for the object

That is why I say oit is easier tyo just hide them.