how to display (2000)

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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!

Reply | Quote

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!

Reply | Quote

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.

Reply | Quote

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. Have you gone beyond the paper stage yet? I’m having difficulty envisioning the actual design.

Reply | Quote

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. Have you gone beyond the paper stage yet? I’m having difficulty envisioning the actual design.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote