By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Toolbar problem

P: n/a
Hi,
I am using WinXP Pro with Access 2003.
I created a custom toolbar and I added the Sort Ascending and the Sort
Descending button to it. When the user wants to browse a table, I have a
table selection window that displays the tables. When the user selects
the table I open a window that diplays the table in Datasheet mode, but
the Sort buttons on the toolbar are not enabled. I can't find any
documentation on this, can anyone help.

TIA
Tim Hunter

*** Sent via Developersdex http://www.developersdex.com ***
Dec 14 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Tim Hunter wrote:
When the user wants to browse a table, I have a
table selection window that displays the tables. When the user selects
the table I open a window that diplays the table in Datasheet mode, but
the Sort buttons on the toolbar are not enabled. I can't find any
documentation on this, can anyone help.
Instead of giving your users direct access to tables which always is a
very, very bad idea, create a form that opens in datasheet view and set
the shortcut menu for your form to your custom pop up.

Note that if you have calculations on on the form control itself,
instead of in the recordsource query/SQL, you won't be able to sort that
control.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me
Dec 14 '06 #2

P: n/a
Sorry, I didn't explain myself in enough detail. I do have a form that
has it's data set to the table, not an sql. I open this form in
Datasheet mode. The form allows editing and I have editing routines
behind most control on the form.
The toolbar displays but the sort buttons are not enabled.
I have used this same approach on another app and it worked fine. I
checked and rechecked to see where there is a difference but i have not
found anything.
As far as the Shortcut Menu is concerned, i have never used that
property and on my form it is set to "NO".
I hope this helps...

TIA
Tim

*** Sent via Developersdex http://www.developersdex.com ***
Dec 14 '06 #3

P: n/a
Another comment...when I directly browse the table, the sort buttons on
the toolbar are enabled. When i call my form that opens the table in
Datasheet mode, the sort buttons are not enabled...
When I open the form i use the following statement:
DoCmd.OpenForm "BrowseCustomers", acFormDS, , , , acDialog
I have tried this statement many different ways but nothing seems to
work.

TIA

Tim Hunter

*** Sent via Developersdex http://www.developersdex.com ***
Dec 14 '06 #4

P: n/a
Problem Solved...You never stop learning
When I use the open form statement with "acDialog" instead of
"acWindowNormal" the sort buttons on the toolbar are not enabled. This
makes no sense to me at all but I know it works because i just tested
it. Please add your comments...

TIA

Tim Hunter

*** Sent via Developersdex http://www.developersdex.com ***
Dec 14 '06 #5

P: n/a
"Tim Hunter" <th*****@rochester.rr.comwrote in message
news:45*********************@news.qwest.net...
Problem Solved...You never stop learning
When I use the open form statement with "acDialog" instead of
"acWindowNormal" the sort buttons on the toolbar are not enabled. This
makes no sense to me at all but I know it works because i just tested
it. Please add your comments...
The whole point of a modal/dialog form is that it is the only part of the
program you can interact with until it is closed (or hidden). If you could
interact with menus and toolbars that could also allow you to open another form
or report or close the application. The acDialog option specifically wants to
prevent that.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Dec 14 '06 #6

P: n/a
OK, that makes sense. I have never opened a form in MODAL mode before in
fact I was not aware of the command until recently. I always programed
my way back from where I came. This obviously makes life easier when
used properly. Thank you so much for helping me with this problem.

Tim Hunter

*** Sent via Developersdex http://www.developersdex.com ***
Dec 14 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.