473,320 Members | 2,158 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Toolbar problem

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
6 1472
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
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
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
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
"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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Chris | last post by:
Hi I have designed my website to fit my standard windows. I use a javascript scroller that nescitates the removal of the browser scroll bars. However if a user has an extra toolbar open in...
1
by: Prakash Wadhwani | last post by:
When I start my Application I put the following code in the Main form Load Event which switches off all the ToolBars so that nothing except my form & it's controls are visible to the user. ...
7
by: Andy Bates | last post by:
I have hopefully a simple problem in C#. I designed a form with a listview on left, vert splitter against that, then the remainder of the form from top to bottom: a listview, horiz splitter and...
1
by: none | last post by:
hiho@ll i want to make a IE Toolbar which has a newsticker built in the problem i have is i don't really know how to use static text in a toolbar? the second question will be, how can i change...
6
by: Juan Pedro Gonzalez | last post by:
I wanted to add a Combobox to a toolbar... Kind of the look you get on VisualStudio's toolbar. I've been able to find some VB 6 samples, but the placeholder option is no longer available for...
6
by: Joseph Geretz | last post by:
I'm porting a C# Outlook Addin originally engineered as a COM Addin over to use VSTO. I've gotten this to the point where my VSTO Addin installs its Menu items and Toolbar buttons when Outlook...
4
by: Gerhard | last post by:
I have an MS Access app with multiple forms. One of the forms has a Toolbar (MsComctlLib.Toolbar) and it works as advertised. I handle the buttons in the Toolbar1_ButtonClick event. I would like...
3
by: Undergrid | last post by:
Hi All, I've got a few toolbars in my application hosted in a ToolStripContainer. I have found a problem whereby the location of a toolbar is not restored when doing a LoadSettings if the...
6
by: =?Utf-8?B?L2Rldi9udWxs?= | last post by:
Hello, i am using visual studio 2003 enterprise architect version. I am making apps for the .Net framework 1.1. While testing an interface, i discovered something strange. In this application...
10
by: Steve | last post by:
Just a warning to the group. The Google Toolbar causes Firebug to issue lots of "Too much recursion" errors in the toolbar.js and eventual causes my Firefox browser to stop responding when using...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.