Solved

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

Posted on 2014-10-21
4
892 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
  • 2
  • 2
4 Comments
 
LVL 35

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 35

Accepted Solution

by:
PatHartman earned 500 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access report groups with sums 5 29
User Level Security 6 38
Reference Controls on subforms 7 28
Dcount help 2 17
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

809 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