Newbe A2000 - generating filename on form

[Splinters]

This is my first Access 2000 form & I need to add a photo of a product, the path to the photo depends on the value of the product ID field -> "C:/photos/{]product ID}.jpg.

For example:
Product Ash07-001 would use photo "C:/photos/Ash07-001tmb.jpg"

The path needs to be generated on the fly for each record and then used to bring up the proper image.

Do I need to do this using a field in the database, or can I do it dynamically in the form itself, as I move from record to record?

Or am I going to have to jump in & learn VBA?

Also, I did a search on the forum, saw several possible answers, but they refer to a Northwind database - what is that?

 

[b4rt07]

Hi,

Northwind is the sample database that is delivered with Access. This might help with the path http://support.microsoft.com/kb/824265

Re driving your images, from memory Northwind does have that does this so should help you.

Cheers.

 

[Splinters]

Hi,

Northwind is the sample database that is delivered with Access. This might help with the path http://support.microsoft.com/kb/824265

Re driving your images, from memory Northwind does have that does this so should help you.

Cheers.

Apparently that did not get installed when I installed Office 2000. I found & downloaded it, and it opens fine. I do see the image (a bitmap) in the Employees DB & form - but I do not see how the link to the image is generated. It looks like the image is loaded in each record, which I am trying to avoid having to do.

For clarity, let me state my problem:

I have a record for each piece of wood I use, and when produced that includes a name for the bowl turned from it (I am a wood turner making wooden bowls for sale). The name of the product might be Asho7-001. I want to use this information to generate - on the fly - the path to the jpg image of Ash07-001, which exists in the folder C:/turnings/cards. I do not want to have to enter each image into the DB record when a bowl is created - that would be more work than I want to go to (I currently have almost 300 pieces of wood with existing records), I want to have the path generated dynamically as I view the record for each product. In addition, I will be using this same path to an image in at least one other DB - and would like to avoid the repetitive work of loading it in both DB files.

What I need is a way to do this - preferably without getting into learning VBA, but if that is the path I have to take, I'll have to take the time to investigate it.

Thanks,

Stephen

 

[b4rt07]

If it's just creating the path that shouldn't be too bad. You can either use a form and put some code in that or use an update query. Either way you will need to create an expression that build your path. Should be something like:-
"C:/turnings/cards/" & [Product Name] & ".jpg"
Cheers.

 

[Splinters]

If it's just creating the path that shouldn't be too bad. You can either use a form and put some code in that or use an update query. Either way you will need to create an expression that build your path. Should be something like:-
"C:/turnings/cards/" & [Product Name] & ".jpg"
Cheers.

OK, thanks - that should give me the syntax I was looking for. I'll try working with it tomorrow.