determining selected columns in datasheet

  • Thread starter Thread starter Malcolm Cook
  • Start date Start date
M

Malcolm Cook

Hi,

I can't figure out if it is possible to determine the controls behind the
current selected columns in when a form is in datasheet view

I know how to get the .selleft and .selwidth, but, since columns can be
hidden and rearranged, I don't think I can use these in figuring this out.

I even started in on an approach that compares each ctl.ColumnHidden state
before and after calling DoCmd.RunCommand acCmdHideColumns. What a hack!
It works except for one problem... too bad for me, acCmdHideColumns only can
hide a single column at a time. Its as if the access engine itself does not
know what columns are currently selected.

Any takers?

Thanks,
 
Hi Malcolm Cook,

Thanks for using MSDN Newsgroup!

From your descriptions, I understood that you would like to find what's the
left or the right column in Access ADP Datasheet for the current selected
column. Have I understood you? If there is anything I misunderstood, please
feel free to let me know:)

Based on my scope, I don't think thare are any better way than your
workaound. You could count the hide column number as n and then make n
times .selleft or .selright

Further, I am not very sure about your business impact on this issue, would
you please show me a detailed scenario so that I think we may find another
way to resolve it. It is highly appreciated if you could provide a sample
adp file with DDL in SQL Server :)

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support
 
Back
Top