A.D. Tejpal
adtp at airtelmail.in
Wed Jun 8 23:27:55 CDT 2011
Datasheet Manipulation:
================
While handling datasheets, some of my sample db's as mentioned below, might be of interest:
1 - Form_FreezeDataSheetColumnsAndSize
2 - DatasheetDynamicColumns
3 - FreezeDatasheetRows
4 - AnchorRowInDataSheet
5 - InsertRows
6 - Form_DatasheetHighLightStyles
7 - FormsSelectedBlockInDatasheet
8 - Form_TrackBulkSelectionsInDataSheet
9 - Form_DsContSetDisplayPos
10 - Form_CascadedCombosOnDatasheets
11 - FormSubf_ReOpenAtCurrRec
12 - Form_SubformAsListBox
Note:
Sample 6 (Form_DatasheetHighLightStyles) also demonstrates an enhanced style for anchoring one or more rows (which need not necessarily be contiguous).
The above samples (in access 2000 file format) are available at Rogers Access Library. Link:
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45
Best wishes,
A.D. Tejpal
------------
----- Original Message -----
From: jwcolby
To: Access Developers discussion and problem solving
Sent: Wednesday, June 08, 2011 23:07
Subject: Re: [AccessD] Datasheet Subform column width a unhappily resetting
There is no way to programmatically change the widths as the form opens?
John W. Colby
www.ColbyConsulting.com
On 6/8/2011 9:53 AM, William Benson (VBACreations.Com) wrote:
> Hi Lambert,
>
> It was very appropriate to paste that link and in fact it is the article
> which I used to finally put in code which helped me force the columnwidths
> to be what I want them to be. That said, it does not explain how, even
> without the use of code, my form was quite acceptably retaining the
> columnwidths when he form was closed, without any need to run VBA to reset
> the widths -- up until the time when I cut the controls off the form and
> pasted them back.
>
> Anyway, since I am using the code to set columnwidths upon startup now, it
> doesn't really matter. With the exception that if you were a user, I am sure
> you would not like changing the column widths on a 15-column subform every
> single time you open the main form. I should think that it would be Access's
> default behavior to leave such settings alone - especially as the form was
> saved.
>
> *UNLESS* clicking the SAVE button on the toolbar affects the main form and
> does not have any impact on the relationship of the formatting of the
> subforms whilst they are engaged/displayed by the main form? Perhaps there
> is another way to save the settings during the session? I.e, though it is
> the long way around, I *could* read the columnwidths within the columns of
> each subform as the main form closes (or as those subforms close) and store
> them in a table then on startup of the main form, read the last used column
> widths from that table!
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
> Sent: Wednesday, June 08, 2011 8:54 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Datasheet Subform column width a unhappily resetting
>
> This link might be the answer to your needs...
>
> http://msdn.microsoft.com/en-us/library/aa217449(v=office.11).aspx
>
> Lambert
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson
> (VBACreations.Com)
> Sent: Monday, June 06, 2011 9:56 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Datasheet Subform column width a unhappily resetting
>
> As additional input... I have decided just to autofit the columns in code
> setting columnwidth = -2 ... but if someone knows how come, without that
> trick, my columnwidths had been set to some standard uniform width just by
> cutting and pasting the controls on the subform... I would appreciate still
> to know what I did or failed to do.
>
> -----Original Message-----
> From: William Benson (VBACreations.Com) [mailto:vbacreations at gmail.com]
> Sent: Monday, June 06, 2011 9:24 PM
> To: Access Developers discussion and problem solving
> Subject: Datasheet Subform column width a unhappily resetting
>
> Kind Sirs/Madams
>
> I had a database working pretty well, datasheet subforms on a main form. I
> had expanded their widths manually, and was happy with everything. I would
> shut the form, re-open it, the widths would stay as they were set. Then I
> decided to add another field in between the first and second fields on the
> subform. This was a little tricky to do because even though I inserted the
> field in the correct location in terms of form view, when the form opens in
> datasheet view, the field is tacked on at the end. I have in the past
> guessed maybe the datasheet view wants to show controls (i.e., columns) in
> the order in which they had been added to the form. So what I do to work
> around this is I cut all the controls out of that subform in design view and
> paste them on a different form's canvas, then cut them and paste them in the
> order I want the columns to show in datasheet view. That seems crazy but it
> works, because the controls get added to that form's controls collection
> anew, and in the r!
> ight order.
>
> OK, well all of a sudden I do this craziness, and I get partially the result
> I want when the main form opens -- in that the datasheet subform does have
> the new field and it is in the correct position. BUT ... no matter how many
> times I stretch the columns, even SAVING the form before closing it, the
> NEXT time I open it, the columns are all the same width. Any ideas why my
> columnwidth settings are not being retained? I personally don't know if it
> has anything to do with the way the controls were added to the form -- and
> in fact I am now on my umpteenth such activity with the same form(s), and
> the problem of the columnwidths never showed up until now. But something
> changed since I added that field...