Adding Photos to employee database

[vbaInet]

FireFox or IE? Try it on IE.

The Nz() function doesn't lie. Perhaps you haven't linked the pictures table to anything and hence strImagePath is always returning Null. Upload your db let me see what you've done.

 

[sladetroityer]

My database exceeds the 2meg limit.

Now what. I'd love to send this to you so that you could take a look at it. Doesn't seem possible with such a small upload limit

 

[vbaInet]

I only need a replica of what you've done. New db, one or two tables, one form, 3 to 5 test records.

 

[sladetroityer]

I've attached a DB with the two forms that I need help with. The search form has the Picture and the Main form has the export to excel button

 

[vbaInet]

What does "export to Excel" have to do with this? Your OP is about displaying a images in a report. This is the first time you're mentioning anything to do with exporting to Excel.

Also, did you test or run the stripped down db before uploading? None of the forms have incorrect Record Sources, none of the queries work and the only macro in the db doesn't work. It's a waste of our time if we download a db that isn't of any use.

 

[sladetroityer]

If I add anthing else to the DB it will be too large to load? Of course nothing works..... The new database has "one or two tables, one form, 3 to 5 test records."

My database has 13 tables, a ton of macros, about 20 forms, and 10 or so queries. It's too large
Now what? I am so close to having this database finished. I have two remaining issues. The photo's and the Export to excel function.

 

[vbaInet]

I asked you what does export to excel have to do with this thread and got no reponse.

You're trying to get the photos displayed in a report but you didn't even upload a report.

Im afraid I can't help you any further if you're unable to provide something to work with.

 

[sladetroityer]

The export to excel is on a different thread. The photo's are being displayed on a form, not a report. The pictures come up just fine, however, when the path cannot be found I want access to revert back to the NO Image jpg, not the last found file.

I'm doing my best to help you help me. It's unfortunate that I can't upload my database. A replica of my database isn't possible witht he 2meg limit.

 

[vbaInet]

The export to excel is on a different thread.

You didn't need to mention it. It's irrelevant to this thread.

The photo's are being displayed on a form, not a report. The pictures come up just fine, however, when the path cannot be found I want access to revert back to the NO Image jpg, not the last found file.

I understand your requirement and you've repeated the same thing many times.

I'm doing my best to help you help me. It's unfortunate that I can't upload my database. A replica of my database isn't possible witht he 2meg limit.

There's nothing wrong with the limit. No one I've helped have been restricted by this limit. If a report is based on multiple queries and you need to upload one query and the report, what do you do? You make a table of the results of the multiple queries and upload that and the report. You also ensure that what you've uploaded replicates the problem.

 

[sladetroityer]

There's nothing wrong with the limit. No one I've helped have been restricted by this limit. If a report is based on multiple queries and you need to upload one query and the report, what do you do? You make a table of the results of the multiple queries and upload that and [B]the report[/B]. You also ensure that what you've uploaded replicates the problem.

There are no reports for the Photos.... only one form.

I just need some code so that if access can't find the file from the path it will revert to no image file? I have given you the current code for the photos and I get questions in return instead of answers!!

 

[vbaInet]

If I can't see what you're working with I'm afraid I can't help you any further.

Perhaps someone else will be able to help.

 

[Simon_MT]

One don't store images in a database particalurly in versions below 2007 as they don't store images in their native formats. The OLE model does not handle compression because it is a bitmap (lack of) technology. Without going into all the detail bitmaps store information for every bit whilst jpgs can compress images because they are capable to handling blocks of pixels and it is lossy because it blends colour transitions into one colour and depending on the amount of compression the image definition is reduced.

The report issue can be resolved with making the Image Control Visible if found and Invisible when it is not, otherwise, in reports, the previous image is repeated until another image is found.

Simon