Search results

As far as I know, Access 2007 doesn't support attachment field type for SQL-Server. Or Access 2010 already does? :-)

Does default picture is visible in report preview?

I know that this is dirty trick, but you can connect Access to MySQL database via a sort of ODBC connector and pull this image and other things from da DB )))

You can run your imagelist with the series of search-and-replace to make it nice. Check our AccessImagine component - automatically does all the work for organizing network image storage. No need to write the line of code here. But, maybe you will need to convert your images to JPEG one.

Or you can try AccessImagine, some people like it as simple and clear solution of all picturing problems in MS Access.

By the way, AcessImagine control scans direct to database and is able to maintain external image storage automatically. In fact, the is no need to write a single line of code to solve this task. And you don't need to purchase it, it works good in shareware mode.

If you are using Access 2007+, you can use regular Picture control. You need to organize your data source in such a way, that the field bound to Picture control contains the full image filename with path.

For now it supports TWAIN sources only. Some webcams do, but some need third-party connector (WIA->TWAIN).

If you have Access 2007+, you can use regular Picture control for this. Just bind it to the picture full filename source. If you use lower version of Access, you can use AccessImagine for this - http://access.bukrek.net

You are making a lot of work here. Sure, its good to play with code, but some people would like to spend time developing DB instead of fighting Access poor imaging. I'd like to suggest the component we have developed for images, AccessImagine - http://access.bukrek.net You just need to place it...

It can be done via nice query. I'm not good query writer on a knee, but i'll try to give you a tip. If we want 1 image and Data is a table, it is done like this: GET ID, Data1, Image FROM Data JOIN Images WHERE Data1=Images.ID For 3 images it is a bit more complex: GET ID, Data1, Data2...

Access imaging possibilities are quite poor, especially when it comes to image printing. You can try using our AccessImagine control for image display, it is specially tuned to give the full-resolution images, when it comes to printing.

Usually this happens, when new application changes the way the association for this filetype is processed. Compare HKEY_CLASSES_ROOT\.bmp on "good" and "broken" machines.

It seems that the application has some prefs set to hide controls. Double-click the MDB file, and then quickly press left Shift key and hold it while the application starts.

You can try some programs for OLE objects extraction, like this one - http://www.lebans.com/oletodisk.htm After you have saved your pictures as image files, there is a wide selection of ways. For example, you can try our AccessImagine component for convenient pictures handling.

Sorry for delay with my answer. Does the "Labels_Query_Labels" is the report you are talking about and "tpb_logo" is the picture you need to rotate? If it is so, i've made the corrections i was talking before in attached file.

Huh, thats a big piece of code. I hope it works at least :) There is a lot of preparations in it, but there is no the report we need here. There is a report in your database called "label_sub_label". You need to make things i've said before to it. Post here if you need further help.

Lets try step-by-step. 1. Create report, place AccessImagine component on it, name it "Pic". 2. In CurrentRecord event write two lines: Pic.LoadFile(MyFile) - (instead of MyFile write the name of the field with image name with path) Pic.TurnLeft If you still have problems with this, just...

Once you have arranged AccessImagine to display proper image, you can write following in some record processing event (i.e. CurrentRecord) [AccessImagine control name].TurnLeft This will rotate the image every time new record is processed.

Access 2003 has poor imaging controls. For good results, try AccessImagine component - it shows and prints high-quality pictures. In fact, its the only way to print smooth 300 dpi images from Access.