From: Costa Zu on
Hi Peter,

Thanks for your advice. I've made more headway in the last 2 days
than I did in the previous 2 weeks! Your comments are truely
appreciated.

I created a query and pointed the sub-form to that, which solved the
problem of the wrong records displaying.

I have heard that Visual Studio Express also contains the license for
the Flex Grid control. VSE is free, so I am going to give that a go.

Thanks for your help.

Regards

Costa.


On Thu, 26 Apr 2007 14:11:47 +0100, Peter Hibbs
<peter.hibbs(a)btinternet.com.NO_SPAM> wrote:

>Hi Costa,
>
>Firstly, I don't have Access 2007 so I cannot help if there are
>problems that are specific to this version of Access.
>
>I am some trouble visualising your set up, do you have two tables, one
>for the main form and one for the subform with a 1 - Many
>relationship. It sounds to me as if you have the main form AND the
>subform bound to the same table, I don't think that will work. I
>created a Continuos type form with several OLE Object fields and
>embedded that in another form and it works fine. I think you must be
>doing something wrong there.
>
>Regarding the Flex Grid control, I got it by installing Visual Studio
>6 which has Visual Basic 6, Visual J++ and Visual C++ 6, if you can
>find a (cheap) copy of this software then that will give you the
>necessary License. You may also be able to purchase the control direct
>from Microsoft but I don't know how or how much it would cost to do
>this.
>
>Alternatively, you could try using the VideoSoft FlexGrid control
>which I believe may come with Access, it shows up as :-) VideoSoft
>FlexArray Control in the list of ActiveX controls. This control is
>compatible with the Microsoft version but has a few more useful
>facilities like being able to edit cells directly. However, you still
>need to pay for it to use it properly. Whenever you open a form with a
>VideoSoft grid control you get a message popping up telling you to pay
>for the software, if you can live with that then I suppose you could
>use it for free. I have not purchased one of these so I have no idea
>how much it costs.
>
>Another possiblity is to import a form with a Flex Grid control on it
>into your project from my demo database and then modify the form and
>code to suit your requirements. However, as I mentioned in the
>documentation, this may corrupt your database file so make sure you
>make a back up copy before attempting this. Other users have said that
>this mehod works OK with no problems so it may work for you.
>
>Hope that helps.
>
>Peter Hibbs.
>
>On Thu, 26 Apr 2007 14:56:11 +1000, Costa Zu <get_cool(a)hotmail.com>
>wrote:
>
>>Hi Peter, again,
>>
>>I'm implementing my sub-form with Attachments as a continuous form but
>>an interesting thing has occurred when I inserted the form into my
>>main form:- only the current record is displaying in the sub-form. I
>>think this might have something to do with linking the master fields
>>and child fields.
>>
>>Basically, the sub-form works as a vertical scroll bar showing all the
>>different records in a continuous form. The main form displays a
>>detailed record of the current record selected in the sub-form.
>>However, the sub-form is now also only displaying the current record
>>in the continuous form ... ie: 1 picture.
>>
>>Any advice?
>>
>>I think this may be because I haven't set up my Access 2007 Options
>>properly yet. In that regard, I hope the next version of Office at
>>least GIVES YOU THE OPTION of using traditional menus or the ribbon.
>>
>>Regards
>>
>>Costa.
>>
>>On Tue, 24 Apr 2007 14:47:00 +0100, Peter Hibbs
>><peter.hibbs(a)btinternet.com.NO_SPAM> wrote:
>>
>>>Costa
>>>
>>>Don't panic, it is possible.
>>>
>>>What you need to do is have a field for each image in your table. Make
>>>the field types OLE Object and insert then into your Continuous form.
>>>Then you can just copy and paste your images into the relevant fields
>>>when the form is displayed. I think the only problem with this method
>>>is that the images are stored within the database file so if you have
>>>a large number of large images (in KB that is) the file could be quite
>>>large. Northwind database uses this method to show Employee images on
>>>a form (although not a Continuous form in this case).
>>>
>>>I suggest you try that method first. If you have a large number of
>>>images you can also do the insert image part using some VBA code but
>>>that is a bit more complicated.
>>>
>>>HTH
>>>
>>>Peter Hibbs.
>>>
>>>
>>>On Tue, 24 Apr 2007 13:31:04 +1000, Costa Zu <get_cool(a)hotmail.com>
>>>wrote:
>>>
>>>>Hello,
>>>>
>>>>This is still driving me crazy.
>>>>
>>>>I am trying to create a continuous subform down the right hand side of
>>>>my main form. The subform simply contains a list of thumbnails that I
>>>>want to display in a continuous form. I used to have a tall skinny
>>>>subform that just scrolled up and down, but now my list is too long
>>>>for the maximum height.
>>>>
>>>>When I created the continuous subform the image displayed in each
>>>>record defaulted to that of the current record. Advice that I've
>>>>received here does not seem to have helped. This is the advice that I
>>>>have received to date:
>>>>
>>>>1.
>>>>Advice: Upgrade to 2007 because that will do what I want to do.
>>>>Action: I upgraded. Bad advice. Images are treated the same as in
>>>>2003. Ie: that doesn't work.
>>>>
>>>>2.
>>>>Advice: Use MSFLXGRD.OCX and look at
>>>>http://www.lebans.com/conditionalformatting.htm
>>>>Action: Great idea! I can see the demo. I want to do something
>>>>similar to the thing with the flags. However, when I try to add the
>>>>control to my form I get the following message:
>>>>
>>>>"You dont have the licence required to use this ActiveX control"
>>>>
>>>>Now what do I do?
>>>>
>>>>Geez! My problem is simple ... give me an Image control that works
>>>>the same way as a text box in a continuous form. i.e: displays the
>>>>image associated with the right record. Is there no one else in the
>>>>world who wants to do this? I am at a total loss and extremely
>>>>disappointed with MS and MS Access.
>>>>
>>>>Can anyone help me out?
>>>>
>>>>Thanks
>>>>
>>>>Costa

From: Peter Hibbs on
Hi Costa

We would be interested to hear if the Visual Studio Express edition
has a License to use the Flex Grid control. I downloaded the Visual
Basic 2005 Express version which did not have it, hopefully VSE does.
If you get it working perhaps you would be kind enough to post back
and let us know the results as a lot of other programmers will be
interested.

Thank you.

Peter Hibbs.

On Fri, 27 Apr 2007 10:49:37 +1000, Costa Zu <get_cool(a)hotmail.com>
wrote:

>Hi Peter,
>
>Thanks for your advice. I've made more headway in the last 2 days
>than I did in the previous 2 weeks! Your comments are truely
>appreciated.
>
>I created a query and pointed the sub-form to that, which solved the
>problem of the wrong records displaying.
>
>I have heard that Visual Studio Express also contains the license for
>the Flex Grid control. VSE is free, so I am going to give that a go.
>
>Thanks for your help.
>
>Regards
>
>Costa.
>
>
>On Thu, 26 Apr 2007 14:11:47 +0100, Peter Hibbs
><peter.hibbs(a)btinternet.com.NO_SPAM> wrote:
>
>>Hi Costa,
>>
>>Firstly, I don't have Access 2007 so I cannot help if there are
>>problems that are specific to this version of Access.
>>
>>I am some trouble visualising your set up, do you have two tables, one
>>for the main form and one for the subform with a 1 - Many
>>relationship. It sounds to me as if you have the main form AND the
>>subform bound to the same table, I don't think that will work. I
>>created a Continuos type form with several OLE Object fields and
>>embedded that in another form and it works fine. I think you must be
>>doing something wrong there.
>>
>>Regarding the Flex Grid control, I got it by installing Visual Studio
>>6 which has Visual Basic 6, Visual J++ and Visual C++ 6, if you can
>>find a (cheap) copy of this software then that will give you the
>>necessary License. You may also be able to purchase the control direct
>>from Microsoft but I don't know how or how much it would cost to do
>>this.
>>
>>Alternatively, you could try using the VideoSoft FlexGrid control
>>which I believe may come with Access, it shows up as :-) VideoSoft
>>FlexArray Control in the list of ActiveX controls. This control is
>>compatible with the Microsoft version but has a few more useful
>>facilities like being able to edit cells directly. However, you still
>>need to pay for it to use it properly. Whenever you open a form with a
>>VideoSoft grid control you get a message popping up telling you to pay
>>for the software, if you can live with that then I suppose you could
>>use it for free. I have not purchased one of these so I have no idea
>>how much it costs.
>>
>>Another possiblity is to import a form with a Flex Grid control on it
>>into your project from my demo database and then modify the form and
>>code to suit your requirements. However, as I mentioned in the
>>documentation, this may corrupt your database file so make sure you
>>make a back up copy before attempting this. Other users have said that
>>this mehod works OK with no problems so it may work for you.
>>
>>Hope that helps.
>>
>>Peter Hibbs.
>>
>>On Thu, 26 Apr 2007 14:56:11 +1000, Costa Zu <get_cool(a)hotmail.com>
>>wrote:
>>
>>>Hi Peter, again,
>>>
>>>I'm implementing my sub-form with Attachments as a continuous form but
>>>an interesting thing has occurred when I inserted the form into my
>>>main form:- only the current record is displaying in the sub-form. I
>>>think this might have something to do with linking the master fields
>>>and child fields.
>>>
>>>Basically, the sub-form works as a vertical scroll bar showing all the
>>>different records in a continuous form. The main form displays a
>>>detailed record of the current record selected in the sub-form.
>>>However, the sub-form is now also only displaying the current record
>>>in the continuous form ... ie: 1 picture.
>>>
>>>Any advice?
>>>
>>>I think this may be because I haven't set up my Access 2007 Options
>>>properly yet. In that regard, I hope the next version of Office at
>>>least GIVES YOU THE OPTION of using traditional menus or the ribbon.
>>>
>>>Regards
>>>
>>>Costa.
>>>
>>>On Tue, 24 Apr 2007 14:47:00 +0100, Peter Hibbs
>>><peter.hibbs(a)btinternet.com.NO_SPAM> wrote:
>>>
>>>>Costa
>>>>
>>>>Don't panic, it is possible.
>>>>
>>>>What you need to do is have a field for each image in your table. Make
>>>>the field types OLE Object and insert then into your Continuous form.
>>>>Then you can just copy and paste your images into the relevant fields
>>>>when the form is displayed. I think the only problem with this method
>>>>is that the images are stored within the database file so if you have
>>>>a large number of large images (in KB that is) the file could be quite
>>>>large. Northwind database uses this method to show Employee images on
>>>>a form (although not a Continuous form in this case).
>>>>
>>>>I suggest you try that method first. If you have a large number of
>>>>images you can also do the insert image part using some VBA code but
>>>>that is a bit more complicated.
>>>>
>>>>HTH
>>>>
>>>>Peter Hibbs.
>>>>
>>>>
>>>>On Tue, 24 Apr 2007 13:31:04 +1000, Costa Zu <get_cool(a)hotmail.com>
>>>>wrote:
>>>>
>>>>>Hello,
>>>>>
>>>>>This is still driving me crazy.
>>>>>
>>>>>I am trying to create a continuous subform down the right hand side of
>>>>>my main form. The subform simply contains a list of thumbnails that I
>>>>>want to display in a continuous form. I used to have a tall skinny
>>>>>subform that just scrolled up and down, but now my list is too long
>>>>>for the maximum height.
>>>>>
>>>>>When I created the continuous subform the image displayed in each
>>>>>record defaulted to that of the current record. Advice that I've
>>>>>received here does not seem to have helped. This is the advice that I
>>>>>have received to date:
>>>>>
>>>>>1.
>>>>>Advice: Upgrade to 2007 because that will do what I want to do.
>>>>>Action: I upgraded. Bad advice. Images are treated the same as in
>>>>>2003. Ie: that doesn't work.
>>>>>
>>>>>2.
>>>>>Advice: Use MSFLXGRD.OCX and look at
>>>>>http://www.lebans.com/conditionalformatting.htm
>>>>>Action: Great idea! I can see the demo. I want to do something
>>>>>similar to the thing with the flags. However, when I try to add the
>>>>>control to my form I get the following message:
>>>>>
>>>>>"You dont have the licence required to use this ActiveX control"
>>>>>
>>>>>Now what do I do?
>>>>>
>>>>>Geez! My problem is simple ... give me an Image control that works
>>>>>the same way as a text box in a continuous form. i.e: displays the
>>>>>image associated with the right record. Is there no one else in the
>>>>>world who wants to do this? I am at a total loss and extremely
>>>>>disappointed with MS and MS Access.
>>>>>
>>>>>Can anyone help me out?
>>>>>
>>>>>Thanks
>>>>>
>>>>>Costa
From: Costa Zu on
Peter,

Give me a week or 2 and I'll get back to you about VSE.

Cheers

Costa

On Fri, 27 Apr 2007 20:41:55 +0100, Peter Hibbs
<peter.hibbs(a)btinternet.com.NO_SPAM> wrote:

>Hi Costa
>
>We would be interested to hear if the Visual Studio Express edition
>has a License to use the Flex Grid control. I downloaded the Visual
>Basic 2005 Express version which did not have it, hopefully VSE does.
>If you get it working perhaps you would be kind enough to post back
>and let us know the results as a lot of other programmers will be
>interested.
>
>Thank you.
>
>Peter Hibbs.
>
>On Fri, 27 Apr 2007 10:49:37 +1000, Costa Zu <get_cool(a)hotmail.com>
>wrote:
>
>>Hi Peter,
>>
>>Thanks for your advice. I've made more headway in the last 2 days
>>than I did in the previous 2 weeks! Your comments are truely
>>appreciated.
>>
>>I created a query and pointed the sub-form to that, which solved the
>>problem of the wrong records displaying.
>>
>>I have heard that Visual Studio Express also contains the license for
>>the Flex Grid control. VSE is free, so I am going to give that a go.
>>
>>Thanks for your help.
>>
>>Regards
>>
>>Costa.
>>
>>
>>On Thu, 26 Apr 2007 14:11:47 +0100, Peter Hibbs
>><peter.hibbs(a)btinternet.com.NO_SPAM> wrote:
>>
>>>Hi Costa,
>>>
>>>Firstly, I don't have Access 2007 so I cannot help if there are
>>>problems that are specific to this version of Access.
>>>
>>>I am some trouble visualising your set up, do you have two tables, one
>>>for the main form and one for the subform with a 1 - Many
>>>relationship. It sounds to me as if you have the main form AND the
>>>subform bound to the same table, I don't think that will work. I
>>>created a Continuos type form with several OLE Object fields and
>>>embedded that in another form and it works fine. I think you must be
>>>doing something wrong there.
>>>
>>>Regarding the Flex Grid control, I got it by installing Visual Studio
>>>6 which has Visual Basic 6, Visual J++ and Visual C++ 6, if you can
>>>find a (cheap) copy of this software then that will give you the
>>>necessary License. You may also be able to purchase the control direct
>>>from Microsoft but I don't know how or how much it would cost to do
>>>this.
>>>
>>>Alternatively, you could try using the VideoSoft FlexGrid control
>>>which I believe may come with Access, it shows up as :-) VideoSoft
>>>FlexArray Control in the list of ActiveX controls. This control is
>>>compatible with the Microsoft version but has a few more useful
>>>facilities like being able to edit cells directly. However, you still
>>>need to pay for it to use it properly. Whenever you open a form with a
>>>VideoSoft grid control you get a message popping up telling you to pay
>>>for the software, if you can live with that then I suppose you could
>>>use it for free. I have not purchased one of these so I have no idea
>>>how much it costs.
>>>
>>>Another possiblity is to import a form with a Flex Grid control on it
>>>into your project from my demo database and then modify the form and
>>>code to suit your requirements. However, as I mentioned in the
>>>documentation, this may corrupt your database file so make sure you
>>>make a back up copy before attempting this. Other users have said that
>>>this mehod works OK with no problems so it may work for you.
>>>
>>>Hope that helps.
>>>
>>>Peter Hibbs.
>>>
>>>On Thu, 26 Apr 2007 14:56:11 +1000, Costa Zu <get_cool(a)hotmail.com>
>>>wrote:
>>>
>>>>Hi Peter, again,
>>>>
>>>>I'm implementing my sub-form with Attachments as a continuous form but
>>>>an interesting thing has occurred when I inserted the form into my
>>>>main form:- only the current record is displaying in the sub-form. I
>>>>think this might have something to do with linking the master fields
>>>>and child fields.
>>>>
>>>>Basically, the sub-form works as a vertical scroll bar showing all the
>>>>different records in a continuous form. The main form displays a
>>>>detailed record of the current record selected in the sub-form.
>>>>However, the sub-form is now also only displaying the current record
>>>>in the continuous form ... ie: 1 picture.
>>>>
>>>>Any advice?
>>>>
>>>>I think this may be because I haven't set up my Access 2007 Options
>>>>properly yet. In that regard, I hope the next version of Office at
>>>>least GIVES YOU THE OPTION of using traditional menus or the ribbon.
>>>>
>>>>Regards
>>>>
>>>>Costa.
>>>>
>>>>On Tue, 24 Apr 2007 14:47:00 +0100, Peter Hibbs
>>>><peter.hibbs(a)btinternet.com.NO_SPAM> wrote:
>>>>
>>>>>Costa
>>>>>
>>>>>Don't panic, it is possible.
>>>>>
>>>>>What you need to do is have a field for each image in your table. Make
>>>>>the field types OLE Object and insert then into your Continuous form.
>>>>>Then you can just copy and paste your images into the relevant fields
>>>>>when the form is displayed. I think the only problem with this method
>>>>>is that the images are stored within the database file so if you have
>>>>>a large number of large images (in KB that is) the file could be quite
>>>>>large. Northwind database uses this method to show Employee images on
>>>>>a form (although not a Continuous form in this case).
>>>>>
>>>>>I suggest you try that method first. If you have a large number of
>>>>>images you can also do the insert image part using some VBA code but
>>>>>that is a bit more complicated.
>>>>>
>>>>>HTH
>>>>>
>>>>>Peter Hibbs.
>>>>>
>>>>>
>>>>>On Tue, 24 Apr 2007 13:31:04 +1000, Costa Zu <get_cool(a)hotmail.com>
>>>>>wrote:
>>>>>
>>>>>>Hello,
>>>>>>
>>>>>>This is still driving me crazy.
>>>>>>
>>>>>>I am trying to create a continuous subform down the right hand side of
>>>>>>my main form. The subform simply contains a list of thumbnails that I
>>>>>>want to display in a continuous form. I used to have a tall skinny
>>>>>>subform that just scrolled up and down, but now my list is too long
>>>>>>for the maximum height.
>>>>>>
>>>>>>When I created the continuous subform the image displayed in each
>>>>>>record defaulted to that of the current record. Advice that I've
>>>>>>received here does not seem to have helped. This is the advice that I
>>>>>>have received to date:
>>>>>>
>>>>>>1.
>>>>>>Advice: Upgrade to 2007 because that will do what I want to do.
>>>>>>Action: I upgraded. Bad advice. Images are treated the same as in
>>>>>>2003. Ie: that doesn't work.
>>>>>>
>>>>>>2.
>>>>>>Advice: Use MSFLXGRD.OCX and look at
>>>>>>http://www.lebans.com/conditionalformatting.htm
>>>>>>Action: Great idea! I can see the demo. I want to do something
>>>>>>similar to the thing with the flags. However, when I try to add the
>>>>>>control to my form I get the following message:
>>>>>>
>>>>>>"You dont have the licence required to use this ActiveX control"
>>>>>>
>>>>>>Now what do I do?
>>>>>>
>>>>>>Geez! My problem is simple ... give me an Image control that works
>>>>>>the same way as a text box in a continuous form. i.e: displays the
>>>>>>image associated with the right record. Is there no one else in the
>>>>>>world who wants to do this? I am at a total loss and extremely
>>>>>>disappointed with MS and MS Access.
>>>>>>
>>>>>>Can anyone help me out?
>>>>>>
>>>>>>Thanks
>>>>>>
>>>>>>Costa