Dynamically set column order on datasheet

[boblarson]

Hi guys!

Does anyone know if there is a way to dynamically set a datasheet's column order without changing the recordsource? I can't think of any code that would do it, but maybe someone has done it before.

What I have is a subform displayed in datasheet view and when the main form is opened, it is opened by selecting one of four departments and clicking a button. Now, of course three of those departments want to see the columns in a certain order and the fourth wants it in another order.

My boss (the new one with my new Access developer position) has told me the customer wants this "dynamic" view and I am not sure it can be done without setting a completely different query for the recordset.

So, anyone got any ideas?

 

[wazz]

hey bob. i haven't read this article for a while but there *might* be something in it for you: http://msdn2.microsoft.com/en-us/library/aa217449(office.11).aspx

 

[Banana]

Also, take a look at my class attendance prototype I uploaded in one of my thread, which the datasheet will try to dynamically sort based on the date.

It may give you some ideas.

HTH.

 

[boblarson]

hey bob. i haven't read this article for a while but there *might* be something in it for you: http://msdn2.microsoft.com/en-us/library/aa217449(office.11).aspx

Hey Wazz - Thanks, that should do the trick.

Banana: Thanks, I'll take a look.

 

[WayneRyan]

Bob,

I don't think DataSheets let you mess around like that.

If a continuous form will do, you can do all of those things somewhat easily.
Does it really have to be a DataSheet?

Wayne

 

[Banana]

WayneRyan,

Actually, it does. It's simply not documented. (Or at least not well-documented).

 

[boblarson]

Bob,

I don't think DataSheets let you mess around like that.

If a continuous form will do, you can do all of those things somewhat easily.
Does it really have to be a DataSheet?

Wayne

It does and the article WAZZ provided appears to show that it actually can be done. So, I'll check it out.