Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    LOOKING FOR REPORT DIALOG EXAMPLE -

    LOOKING FOR REPORT DIALOG EXAMPLE - NBS7335

    I

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: LOOKING FOR REPORT DIALOG EXAMPLE -

    Where does the report come into all this? I sounds like you are looking for a series of forms that allow the user to drill down into the criteria to specify. In Access, you don't need a series of stuff like this, you can simply change the rowsource of the combobox to show the next level of selections. You can use a couple of unbound date time picker controls to allow them to enter the dates. The report sequence translates into grouping and sorting in Access reports. Assuming that your DATE, REVENUE CODE or OUTCOME CODE means that they can select one of these to sort by, reports have an OrderBy property that can be set from code.
    Charlotte

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: LOOKING FOR REPORT DIALOG EXAMPLE -

    Hi Charlotte

    That's exactly what I'm trying to accomplish.

    New to Access, is there example code you know of that will lead me in the right direction?

    Thanks, John

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: LOOKING FOR REPORT DIALOG EXAMPLE -

    If you haven't already done so, invest in some books on Access. And search this board on books for some of the recommendations that have already been posted. There are also sample databases on the CD, not only Northwinds but also a Solutions9.mdb that has a bunch of cute stuff in it. And this RptSmp00.exe that you can download.
    Charlotte

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: LOOKING FOR REPORT DIALOG EXAMPLE -

    Hi Charlotte

    Thanks for your help.

    Do you know if there is a qrysmp00.mdb

    Thanks, John Graves

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: LOOKING FOR REPORT DIALOG EXAMPLE -

    Indeed there is. Get it at <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q207/6/26.ASP>QrySmp00.exe</A>
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •