Troubleshooting Techniques

I have been struggling with a problem and would appreciate some perspective.

First the problem: I have been creating an application which relies on
allowing users to select and sort records using the standard toolbar in a
continuous form and then being able to print those records in the displayed
order. When successful, this uses the filter name in the OpenReport line and
includes an OrderBy statement on open in the Report. This works fine in
parts of the application, but in another location, Access asks for a value of
the specified sort field and then ignores the Orderby statement.

The only difference I can identify is that the form in the successful piece
is based on a table while the unsuccessful one is based on a query linked to
multiple tables.

I have compared the working and nonworking pieces of code and can see no
difference. I have tried developing the report again from scratch with the
same result.

Can anyone suggest 1) things to look at for this specific problem and/or 2)
general assistance in how one approaches troubleshooting. (I'd shoot the
code, but it wouldn't help!)

Thanks, Lloyd
.

Relevant Pages

  • Re: Where does SMS look for software installs to report?
    ... am still interested in knowing where SMS looks to report back a package was ... I was told by the package creator that I have to check the audit ... successful install, when it wasn't?" ... report states that the package will not run because the prior install was ...
    (microsoft.public.sms.misc)
  • RE: updates continusly downloading
    ... not sure you're having quite the same problem OCainte as you get a report to ... say it's successful, mine just keeps going and going unless i cancel it (to ... The downloading file’s size increases in ...
    (microsoft.public.windowsupdate)
  • Re: Where does SMS look for software installs to report?
    ... successful install, when it wasn't?" ... run, and if successful, at their next hw inventory they'd report the ... received the package fine and the entire package installed successfully. ... report states that the package will not run because the prior install was ...
    (microsoft.public.sms.misc)
  • Re: Snapshot Viewer Control in Continuous Form
    ... >> I have a Snapshot Control in a continuous form and I want the source ... >> data (based on one of the fields in the recrod source for the form). ... >> recrod source for the form, the report that should be displayed in the ... >> Snapshot Control would be CurrentUniqueValue.snp. ...
    (comp.databases.ms-access)
  • Re: Snapshot Viewer Control in Continuous Form
    ... > I have a Snapshot Control in a continuous form and I want the source ... > data (based on one of the fields in the recrod source for the form). ... > Snapshot Control would be CurrentUniqueValue.snp. ... The snapshot object I am using is set to trhe exact width of the report ...
    (comp.databases.ms-access)