Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nhtennispro

    Startup macro won't fire at command line /x Acc 2003

    Is there any reason why a macro won't fire when I use /x at the commmand line? I have disabled the AutoExec macro, then prevented anything else from opening in STARTUP, but the macro is not firing when I click the shortcut. Here's my shortcut "H:\New H Drive\REVPORT\Audit Access DB Pace Prod...
  2. nhtennispro

    Access runs when its a MAQ, not from form

    I have an application which works fine for me, but not for the other users. The other users have MORE POWERFUL computers than I do and have at least the same permissions. When I create for them a query shortcut (MAQ) they are able to run the queries fine, but not when they are calling them from...
  3. nhtennispro

    Query works one PC, but not another (Oracle tables)

    I am using Access 2003 to link 2 Oracle databases together for a rather complicated (20 tables) query. It works on my PC, but doesn't work on other PC's that are as every bit as powerful as mine. I am not using pass through queries to the Oracle dbs as views that I would need have not been...
  4. nhtennispro

    What's So Bad About Using GoTo

    TheAceMan1, Here is an example of when I use "GoTo" what do you do instead. Function Test() On Error GoTo TestErr ..... Exit Function TestErr: MsgBox Err & ". " & Error If Err = 1111 Then Resume ElseIf Err = 2222 Then Resume Next Else 'Exit End If End Function...
  5. nhtennispro

    Group Sort Expert does not always work ... why?

    Perhaps this is covered elsewhere, but what I also found is that A) Create a summarized field to enable Group Sort Expert B) Use the Group Sort Expert to create a top 10 list C) Delete the field in step A and the Group Sort Expert stays enabled.
  6. nhtennispro

    Group Sort Expert does not always work ... why?

    You are right on both counts. Adding a summary field allowed the button to become enabled. Thanks
  7. nhtennispro

    Group Sort Expert does not always work ... why?

    Actually no. On the report that I have a GROUP SORT EXPERT enabled I have summaries on a number of fields. When I delete the group (and the summarized fields) and reinsert the group the GROUP SORT EXPERT is then disabled.
  8. nhtennispro

    Group Sort Expert does not always work ... why?

    I am trying to do a Top Ten report with totals of just the 10 records not the entire recordset. However when I attempt to do it the GROUP SORT EXPERT does not become enabled. When I look at some of my other reports that has the GROUP SORT EXPERT enabled. When I deleted the group, then...

Part and Inventory Search

Back
Top