?
Solved

Access 2007 Dynamically create a report from a dynamic table using VBA

Posted on 2014-10-21
4
Medium Priority
?
1,088 Views
Last Modified: 2014-10-21
Hi Experts!!! I need help in creating a report/subreport from a table which will have dynamically built/variable columns. I have attached a screen shot of the actual table.

Any help will be appreciated.

PLEASE! :)
Untitled.jpg
0
Comment
Question by:Ei0914
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 38

Expert Comment

by:PatHartman
ID: 40395318
The biggest problem with doing this is that you don't have design access to objects when running under the control of the runtime engine or if you distribute the database as .mde/.accde/.accdr

I'm hoping this isn't really a dynamic table but is rather a crosstab report that changes header labels as columns change.  You can find an example in this KB article.
http://support.microsoft.com/kb/328320
0
 

Author Comment

by:Ei0914
ID: 40395343
Hi Pat!!! I can make it a Crosstab query/report. Just not sure how to go about it :)
0
 
LVL 38

Accepted Solution

by:
PatHartman earned 2000 total points
ID: 40395410
You don't have to change it although temp tables cause bloat and so they are not good practice.  You can use the KB article regardless of whether the source is a table or a cross-tab query.
0
 

Author Closing Comment

by:Ei0914
ID: 40395799
Thanks Pat!
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question