filter/copy/paste buttons on a form

  • Thread starter Slez via AccessMonster.com
  • Start date
S

Slez via AccessMonster.com

I have a form that opens when users click a command button. It is set to a
specific size and is not maximized. On that form, there is one subform which
displays in datasheet view. Within that, there is another level of records
available via subdatasheet. It appears because the form is not maximized,
the Access toolbar buttons for filtering or copy/pasting do not apply. If
data in a field(s) is highlighted and you right click, you get the drop down
with the options. That works just fine.

What I'm wondering is if there is a way to place a small toolbar or command
buttons on the form that would enable users to perform the following 5
functions in the subform or the subform's subdatasheet:
Copy, Cut, Paste, Apply Filter, Remove Filter

Thanks in advance for any advice!
 
G

Guest

Hi Slez - I use macros to open toolbars. Create the Toolbar, then on the On
Open Event click on ... and choose Macro Builder. Give it a name and then on
the Action line put the command ShowToolbar and put the name of your created
toolbar in the Toolbar Name line. Set the Show option to Shere Appropriate.
Hope this helps -- yours Dika
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top