Access 2007 Form stuck in "calculating" after adding picture control 2

[con10t]

I have a 2007 Access database to inventory my supplies. I was embedding pictures into the various forms and noticed that my database was exploding in size.In an effort to cut down on the size of my database, I followed the instructions on this truly incredible thread, wherein instead of imbedding pictures, you simply store a path to the picture:

thread702-289543

I started with just one section of my database. On this particular form's detail property I added this code to the On Paint event procedure:

Me![PictureImage].Properties("Picture") = Me![PicPath]

So when I opened my form, the image object PictureImage was to find the picture on my computer designated by PicPath and display it.

My table holds 35 records and when I was first implementing this only one record held a path. I changed from Form Design to Form View and it worked (happy dance!). Then I closed the database and walked away for an hour.

When I came back, I went back to that form, but it did not display correctly and the term "calculating" was seen in the bottom left hand corner. I thought maybe it was stuck because the other records did not have paths, so I copied the same path into my other records (as a quick way to fill the field for the time being), but my form still will not display.

Any ideas? Thanks in advance for your help . . .

 

[TheAceMan1]

How are ya con10t . . .

For forms, it all depends on wether you've selected [blue]single view[/blue] or [blue]continuous view[/blue]? The thread you reference is only good for [blue]single view[/blue] forms and it does save a great deal of space. So if your forms in question are in [blue]single view[/blue], by all means use the method in the thread you reference. Just move your code to the forms [blue]On Current[/blue] event!

[blue]Continuous[/blue] forms are another story. Here your limited to [blue]OLE[/blue] and embedding ... no way out! However you can set the OLE objects [blue]OLE Type Allowed[/blue] property to [blue]Linked[/blue] to save some overhead, and I hear 2007 does its own job in keeping it down. Wish I had better news.

For your reference: Handle/Display images in forms/database

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[con10t]

Aceman--Thanks for the info, at this point ANY news is good news. I'm at work at the moment, so I'll have to try what you suggested and continue reading. I'll let you know if that worked/helped. I appreciate all your help!

Deborah

 

[DFrostAcc]

I have an Access 2007 database that behaves differently under Windows 7 than under Windows XP. Basically I have a sub form within a form, the header data is displayed in the form and the detail is displayed in the subform and the detail lines in the subform are totalled in to a field in the footer of the subform, however this field does not update under Windows 7, instead a ‘...Calculating’ message displays until I click on the Windows status line or minimize/maximise the windows, after which the footer field updates with the total. Has anybody encountered this behavious before and have you mangaged to discover a work around? You assistance would be greatly appreciated!

 

[MajP]

AceMan and DFrostAcc,

Continuous forms are another story. Here your limited to OLE and embedding ... no way out! However you can set the OLE objects OLE Type Allowed property to Linked to save some overhead, and I hear 2007 does its own job in keeping it down. Wish I had better news

I just got beat up on this because I said the same thing but it is not true anymore. Access2007 released a new capability with the bound image control. For some reason this got little press. Even on the MSDN sites it is barely discussed. But with the bound image control all you have to do is bind it to a field with the path and it renders in a continous form. No code needed.

 

[MajP]

AceMan,
The lack of information on this is bizarre. This is a capability that has been desired for a long time, and it works really well as far as I can tell. You can even edit the path in the current record and watch the image render. But I have googled the web and cannot find any mention of this. Even the normal Access "instructional sites" refer to the old methods of doing this.

 

[MajP]

AceMan,
BTW here is where I got humbled by StrongM. Fortunately for me the user was on 2003 and my solution was viable, but I never asked.
Thread705-1632716

 

[DFrostAcc]

oops, I am not using images at all. Maybe I sould have created a new thread but I am also encountering the '...Continuing' message as experienced in this thread.

I am totalling numbers on a continuous form (which is actuallty a subform) in to a form field:
=Sum([Votes])

The field does not update until I click on the Windows status line or minimize/maximise the windows.

This operated correctly in the Windows XP environment but not on the Windows 7 environment.

 

[TheAceMan1]

[blue] ... You can even edit the path in the current record and watch the image render.[/blue]

Now thats a capability worth upgrading for! ...

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[kjv1611]

MajP,

Thanks for posting that information about the new ability in '07/'10. I don't know that I'll need it any time soon, but it's definitely interesting... and maybe I will need it some time.. will have to play with it and see..