how to duplicate the function of some of the toolbar buttons

[Atomic Shrimp]

I have a form which really needs to be modal and popup, as it will fit on the screen, but not when it's inside the access window (also, making it modal would effectively prevent the user from exiting Access by any other method than the close button I provide)

Now, the problem with this is that it makes the toolbar unavailable, so what I would like to do is create my own set of buttons that will sort the datasheet subform by whichever column the system caret/focus is currently in, like the A-z and Z-a buttons on the toolbar.

any ideas?

Mike

 

[charityg]

use the orderby property

 

[Atomic Shrimp]

How?

the subform doesn't apear to have such a property...

 

[Rich]

Use the shortcut popup menu bar or create a custom one.
HTH

 

[Atomic Shrimp]

Will the custom menu bar be acessible with a popup modal form?

 

[Rich]

Yes if you use a popup menu if you have short cut menu set to yes on the forms property sheet right click and the default sort popup menu bar will appear.
HTH

 

[Atomic Shrimp]

hmmmm, thanks Rich, but unfortunately not exactly what I'm looking for (fussy me) - I want to put the function behind a button that's visible all the time

 

[Rich]

You can create a macro to open your custom toolbar.

 

[Atomic Shrimp]

Rich, I think that a custom toolbar also won't be accessible when the form is modal and popup.

Can anyone tell me how to set the OrderBy property of a datasheet subform in VBA from the parent form's class module?

[This message has been edited by Mike Gurman (edited 05-09-2001).]

 

[Atomic Shrimp]

Got it, it's:

Me.SubFormName.Form.OrderBy = "[fieldname]"

Now all I need is the code for finding the name of the field with the system caret.

 

[Simplycongy]

This is probably too late, but its always useful completing a post...

MyField = Me.ActiveControl.Properties("Name")
Me.OrderBy = "[" & MyField & "]"

 

[ghudson]

Simplycongy, how the heck did you find this old post?

Enable/Disable The Control Box X Button

A Better Mouse Trap?

Searching the forum is a great way to discover and learn the answers to your Access programming questions.