Re: Question on Albert's video regarding A2010

"Salad" <oil@xxxxxxxxxxx> wrote in message


That sounds really neat. Thanks for the explanation.

I haven't dl'd Office yet so I may ask a question that is very obvious
after doing so. Does one use something like this web service for a
continuous form as well? Like how you presented pics of the rooms?

The browser control works for both web based, or your longtime VBA client
(desktop) only applications. So, it a new control, and it not restricted to
web only, it works well for client apps also.

In fact, for client (VBA) applications, I think this control is one of the
most useful new controls we received in access in a VERY long time. It has
near unlimited uses...

Would I use this browser control the continues form to display the rooms?
No, I just used the new picture control we have in access. In fact, that new
control arrived in access 2007. And, I actually placed the pictures in the
database (used the new attachment column we have).

So, those pictures are stored in database. I did this for several reasons,
but one reason was then publishing was simple one click to the web, and no
additional work or setup was requited to make that continues form work in a
web browser.

The new picture control in access 2007 is quite nice, as it can be bound to
a database column. That database column can be a text path name to a picture
on your hard drive. Prior to 2007, you could make a picture control display
a picture from a path name, but it requited code in the on-current event to
setup the image control. And, prior to 2007, you could NOT display pictures
in a continues form at all. And, prior to 2007, placing pictures in the
database was a source of huge bloat.

So, with 2007 and 2010, this new picture control does NOT bloat the
database, does not requite code to refresh, and also works in continues
forms, and for 2010, the picture control works in browser based applications
(but, don't confuse browser based applications with the new browser control,
they are NOT related in any way. So, the new browser control is not part of
the new web stuff, and you are free to use this control in your longtime VBA
desktop applications).

However, the new picture control in access is really nice. Things like a
picture of country flag appearing beside a persons name does not take code
to do this. Or you can have a part picture appear beside a part number, or
perhaps a cute graphic folder icon to show the status of a project as being
open, or closed via a nice graphic. So, that 2007 picture control is
nice..and it carries over to 2010. it really opens up the ability to use
pictures in our applications with great ease.

Does one use something like this web service for a continuous form as well?

No, I did not need nor would use the web browser control to build that form.
That form is just a regular continues form. I make the buttons a bit larger
so it looks more "web like". And, I just drop the picture control onto the
continues form along with those buttons and text boxes. They all repeat over
and over just like all continues forms do...

However, you do bring up an interesting question:
Since the web browser control is bound, one of the first things I tried was
to drop a browser control onto a continues form!

That does not work. At lest in the early beta it did not work (the browser
control was grayed out in the tool box). So, I did try this!! I have to try
this again, or perhaps drop the control into the detail section on a form,
and then flip the form into continues mode to see what happens. Last time I
looked, this is not possible. So the bound picture control does work on
continues forms, but the bound browser control does not work in continues
forms. This is probably a good idea, since repeating a whole browser control
over and over in a form would be quite heavy from a memory and resource
point of view...

I could check in the latest beta preview we all have if this has hanged, but
I doubt it..

So, that continues form in that video was built like any other continues
form in access. I did not have to modify it in any special way when I
published it to the web...


Another question. Lets say we had a continuous form that displayed pics
of the rooms. Can one display the pics as thumbnails and by, let's say,
dbl-clicking on the pic it present a larger, full-sized pic of the room?

Well, if you look at that video, that's really how it worked. Those smaller
room pictures in the continues form really were much like thumbnails. Notice
how much smaller the room pics are in the continues form. To accomplish
this, I just sized the picture control smaller in the continues form. I did
not use two sets of pictures. I could have made the room pictures even
smaller in the continues form, but I had lots of room. I suppose if I sized
the picture even smaller in that continues form, it would have looked even
more thumbnail like.

Note that if you click on the picture, the attachment manager comes up
(that's how I view the front/back/side of the room). I did not have to write
that code, it built into the attachment control in access now. I just added
3 pictures to that one records attached field.

Note that clicking on the picture in the continues will also launch the
attachment manger. I actually I actually disabled the picture control in the
continuous form for this reason. I suppose I could put a invisible control
on top, and if you click on the picture then I could simply launch a form
the same way that the edit button (that is right beside that picture).

So, right now just clicking on the edit button does launch the room form,
and you do see a much larger image of the room. I suppose I could make
clicking on the picture do the same thing...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx


.

Relevant Pages

  • Re: putting a picture onto a userform without using the vba window
    ... control in the list and select. ... picture disappears. ... MsgBox "No picture on clipboard" ... Private Declare Function IsClipboardFormatAvailable Lib "user32" (_ ...
    (microsoft.public.excel.programming)
  • Re: Hi, Jay.It seems that I hastened to the findings.
    ... I was try to replace the picture in the content control. ... The code given in the site works when the content control is not in footer. ... newfooter is the name of the picture content control. ... (e.g. rotation, borders, shadows) ...
    (microsoft.public.word.vba.general)
  • Re: Display stored JPGs on a form
    ... I understand that storing images in an Access database does not make for the ... I have a Bound Object Frame control on a form that has as ... its control source the OLE Object type field in which the JPG is stored.. ... this by creating an image control with its "Picture" ...
    (microsoft.public.access.forms)
  • Re: OLE Object- the real question
    ... Now you have a blank image control. ... Dim strFilename As String, strFind As String ... My file path for the 1st picture is ...
    (microsoft.public.access.forms)
  • Re: Using Image Acquisition Automation: how to display the thumbnail?
    ... I note that the Picture control in VB allows me to assign the image ... make sure it has been tested in VFP. ... >>access all of the items in the JPG file, including the thumbnail picture. ...
    (microsoft.public.fox.vfp.forms)