Re: Rerun an open query in Access 2007

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Sorry, Dan: I can't tell you specifics like that.

I have found that not all buttons work in all contexts.

Beyond that, the links I gave are the best leads I can suggest.

Or perhaps someone else will jump in who has attempted that.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"DanR" <DanR@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E1CD7024-5F87-4677-97A4-757D728A6B53@xxxxxxxxxxxxxxxx
Allen,

I read the articles to which you referred, and now am able to have a new Tab
on the Access Ribbon using the XML shown here:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui";>
<ribbon startFromScratch="false">
<tabs>
<tab id="dbCustomTab" label="RK Custom Tab" visible="true">
<group id="grpReRun" label="ReRun">
<button id="cmdQueryRunQuery" label="Run" imageMso="QueryRunQuery"
size="large" />
</group>
</tab>
</tabs>
</ribbon>
</customUI>

However, I don't know what events are available for "onAction" to tell
Access to re-run the Query that is "on top".

Do you happen to know what the "onAction" name is that Access 2007 uses for
"Run Active Query"?

I thought that the "Run" button would, by default, perform its usual
function, unless I specified some other function. However, nothing seems to
happen when I press it.

Your help is appreciated.

Thanks.

Dan
--
Dan R


"Allen Browne" wrote:

Changing the ribbon is quite a bit more work, but it's easy to customize the
Quick Access Toolbar.

If you really want to customize the ribbon, here's some leads:
http://www.accessribbon.de/en/?Access_-_Ribbons

http://blogs.msdn.com/clintcovington/archive/2006/12/08/msdn-article-on-creating-custom-ribbons-in-access-2007.aspx
http://accessjunkie.com/faq_30.aspx

"DanR" <DanR@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:80A874C0-DC74-4A12-B68A-07B3F474DA3D@xxxxxxxxxxxxxxxx
> Hi,
>
> In Access 2003 I was able to place the "exclamation point" RUN button > on
> my
> Access toolbar so that I could easily re-run a query that I already had
> open
> (rather than try to find it in a list of a few hundred queries). The
> queries
> I run usually ask for user input, so by re-running them I am able to > give
> different input.
>
> Is there any way in Access 2007 to place a "RUN button" on the "Home" > tab
> toolbar?

.

Relevant Pages

  • RE: Two PCs Different Results
    ... Dave Hargis, Microsoft Access MVP ... "Dan @BCBS" wrote: ... I'll try creating a new query from the orginal the adding your suggestion to ...
    (microsoft.public.access.queries)
  • RE: Newbie question, looking for earliest test record for each s/n
    ... would expect the Model# and ProductCd to be unique for a particular SerialNo. ... Try removing the TestStatus field from the the query, ... "dan b in st. louis" wrote: ... I'm looking to keep only the first test record for each s/n. ...
    (microsoft.public.access.queries)
  • RE: Newbie question, looking for earliest test record for each s/n
    ... "dan b in st. louis" wrote: ... That is, on the menu bar in the query designer, click on the ... I'm looking to keep only the first test record for each s/n. ...
    (microsoft.public.access.queries)
  • RE: multi calculations
    ... I used Dan as table name. ... "Dan @BCBS" wrote: ... I can make A. work, but when I try B in the same query, it will not work. ... The field is called = "IssueClosedDate" all the calculations are based on ...
    (microsoft.public.access.queries)
  • Re: counting records in a recordset
    ... > I have a query that is supposed to return only 1 record, ... > record and alert the user to contact the database administrator. ... I cannot get into specifics because you did not ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)