Thanks Graham! - for the kind words. You are most welcome.
A suitable class for simulated continuous forms using unbound controls would be great and you are indeed the right person to set it up. I look forward to have a copy when it gets completed.
Best wishes,
A.D. Tejpal
------------
----- Original Message -----
From: Graham Mandeno
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, September 30, 2011 03:25
Subject: RE: [MS_AccessPros] Re: Following the color change thread
Hi A.D.
Excellent work, my friend!
For some time I have had it in the back of my mind to set up a class for
handling unbound "continuous" forms. The problem I was specifically wanting
to address is that of displaying record-dependent images in continuous forms
- for example, thumbnail images in a product list.
You have given me some good ideas for how to proceed. Thank you!
Best wishes,
Graham
> From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of A.D. Tejpal
> Sent: Friday, 30 September 2011 05:26
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Re: Following the color change thread
>
>
> Walter,
>
> My sample db named Form_ContSimulated_ColorsRowWise.zip, uploaded to
4Shared.com demonstrates the approach outlined in my earlier post. It is in
Access 2000 file format (Ref: DAO 3.6). Link for downloading the file is
given below:
> http://www.4shared.com/file/ngHp16DH/Form_ContSimulated_ColorsRowWi.html
>
> Simulated continuous form using unbound controls, displays 12 records at a
time. Full coverage of data is provided via suitable navigation buttons.
Apart from being able to edit the records, the user can add new records or
delete any desired one by clicking appropriate command buttons. All these
actions are feasible directly on the simulated form. Current record remains
identified by special highlight in first column.
>
> First two columns (locked) display the record number and TrainID. Next two
columns, holding TrainCode and ColorValue, are editable. Last column serves
as ColorStrip, each row displaying the color represented by ColorValue in
the previous column.
>
> There is two way synchronization between ColorValue and ColorStrip. Any
value entered in the former gets reflected as corresponding color in the
latter. On the other hand, double click on ColorStrip invokes the color
dialog box, where the user has unlimited choice and the color finally
selected gets displayed in the color strip. Simultaneously, appropriate
value gets assigned in ColorValue column.
>
> Note:
> The modules for color dialog box have been taken from Access 2002 Desktop
Developer's Handbook.
>
> You might like to try it out and confirm whether it is in line with your
objectives and whether anything needs further attention.
>
> Best wishes,
> A.D. Tejpal
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar