Results 1 to 15 of 15
  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Location
    London, Gtr London, England
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    how to display (2000)

    Please help I am stumped.
    Sorry I have been out of Access development for a while and have come across a problem I am sure you gurus can help me with.

    I have attached a file which shows my table structure and the requested user interface. I am uncertain how to display, what control to use, this user interface. I have looked at trying to query the data using cross tab, but that only gives me one column header when I need to group columns as well as rows.

    please can someone help me.

    Thanks in advance.

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

    Re: how to display (2000)

    Are you trying to design a report? A crosstab can give you the basic data and you can group and sort in the report itself.
    Charlotte

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: how to display (2000)

    The Pivot Table feature introduced in Access 2002 can display the data the way you want, but it is not available in Access 2000. Your best bet might be to create a pivot table in Excel based on an Access query. You don't need to import the data themselves into Excel, the Pivot Table Wizard in Excel lets you use an external data source.

    Warning: If you have multiple models, the display will become very wide, since you want to have 3 levels in the column headers: Model, Group and Frequency. You might exceed the 256 column limit of Excel.

  4. #4
    Star Lounger
    Join Date
    Jan 2002
    Location
    London, Gtr London, England
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to display (2000)

    If I was to imbed an excel object on my form and display the informatin in a pivot table would this allow for user update?

    Charlotte to answer your question I am trying to display theinformation to the user in a form so that they will be able to easily update. They are moving over from an excel spreadsheet to an access application so like to view it the way they always have.

    So I guess the big question is if I embedd an excel object of type pivotgraph, will the user be able to update the data, though I don't want the pivot table holding a connection to the database?

    Hope this is clear.

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

    Re: how to display (2000)

    You didn't make it clear initially that you were trying to design a data entry form. Crosstabs, etc., are not updateable, but you can recreate the look you want with forms and subforms in Access without the need for a pivot table, since you won't be pivoting anything.
    Charlotte

  6. #6
    Star Lounger
    Join Date
    Jan 2002
    Location
    London, Gtr London, England
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to display (2000)

    Would this be achieve buy having multi subforms embedded in each other?

    Sorry I have been away from development for 6 months and am trying to get my head back around how to do these things which should be second nature.

    Thanks for your help!

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: how to display (2000)

    No, a pivot table is not updatable, neither is a crosstab query.

  8. #8
    Star Lounger
    Join Date
    Jan 2002
    Location
    London, Gtr London, England
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to display (2000)

    Can I added that I require the result to be unbound as I do not want conflict issues with multiple users!

    Thanks for your help in advance.

  9. #9
    Star Lounger
    Join Date
    Jan 2002
    Location
    London, Gtr London, England
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to display (2000)

    Charlotte how would I create the sub form given the following example.

    I have a parent form which has the allocation model option. On selection of this it is to determine what is displayed in the child form. The problem is I do not know what group or frequency combinations are going to be required. how do I design this child form to alter dependant on the allocation model selected?

    Hope this is clear.

  10. #10
    Star Lounger
    Join Date
    Jan 2002
    Location
    London, Gtr London, England
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to display (2000)

    Can you use Data Grids in Access? this might help display my required information

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

    Re: how to display (2000)

    Yes you can use a data grid, but you must have the developer edition of Office to distribute a setup that includes a datagrid because it needs to be licensed and available on the other machines that use the application.
    Charlotte

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

    Re: how to display (2000)

    Show the model for selection in a combobox and only display the related information after a selection is made. You can, in fact, nest subforms, but I'm confused by your statement to Hans about unbound forms, since you appear to want a bound subform. <img src=/S/confused.gif border=0 alt=confused width=15 height=20> Have you gone beyond the paper stage yet? I'm having difficulty envisioning the actual design.
    Charlotte

  13. #13
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: how to display (2000)

    Like Charlotte, I'm confused by your wish to use an unbound form. Apart from that, the design you attached in the first post in this thread is more a reporting format than a data entry/editing format. I think it will be inordinately complex to implement for data entry/editing.

  14. #14
    Star Lounger
    Join Date
    Jan 2002
    Location
    London, Gtr London, England
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to display (2000)

    Thanks Hans and Charlotte for your help. I thought of using combos to display the specific frequency, low level data, though I want to provide the information to the user to update in the same form they currently have it in excel workbooks. I guess I am trying to provide them exactly what they currently have, which is not possible.

    Thanks for your help.

  15. #15
    New Lounger
    Join Date
    May 2001
    Location
    New Jersey, New Jersey, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to display (2000)

    Have you considered using Excel as the interface with VBA programming to retrieve the data from Access tables and more code to update the tables. It seems too complex for your needs, but would let you keep your current interface.

Posting Permissions

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