Re: Dynamic Report Fields

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Larry Linson (bouncer_at_localhost.not)
Date: 10/26/04 

Date: Mon, 25 Oct 2004 19:27:02 -0500

I seem to remember seeing a similar or identical post sometime not too long
ago. Unless you clarify, there is just not enough detail here for a useful
response.

As I read it: you have a table whose design changes, or may change, each
month. You want a self-adjusting report to determine what is in the table
(Record Source) and re-create or modify itself to accommodate, in sections
"determined by a code".

Perhaps with some detail and description, someone could make some
suggestions. But as I read what you have written, I'd say, "Give thanks that
Access' Reporting is so user-friendly, because you have described something
best addressed by manually creating or modifying the existing report each
month."

I suspect the environment is not quite as unstructured as it seems to me
from reading your description, however, and look forward to seeing more
detail.

  Larry Linson
  Microsoft Access MVP

"Bryan" <anonymous@discussions.microsoft.com> wrote in message
news:0ea601c4baea$dfbd8670$a601280a@phx.gbl...
> Hello.
>
> I have a problem which I'm unable to improve. I need to be
> able to create a report based off a table every month.
>
> 1. The table each month can contain various columns
> 2. I have no control over the data
> 3. The data is broken into sections by a code
>
> The current solution I have is for every column in my
> table has a field on the report, table name 'Test', report
> name 'txtTest' etc. The problem comes when more and more
> fields are added to the table.
>
> I've tried a number of solutions but none seem to work.
> First of all I can't set the control source dynamically,
> because of the Sub_Header (that sets the labels for each
> code).
>
> I've also tried to have aliases for all of my fields,
> field1, field2 etc, but that doesn't work either.
>
> Any ideas? I'm pulling my hair out here.
>
> Thanks,
> Bryan

Relevant Pages

  • Re: Multiple users on an Access database
    ... I think version 97 was the last one that allowed you to modify objects while someone else was using the mdb - not any more. ... I've split the database however I'm still encountering problems. ... design of a Report or Form the following message appears " Microsoft ... Access can't save design changes or save to a new database object because ...
    (microsoft.public.access.security)
  • zickige Fenster
    ... um z.B. REPORT PREVIEW oder MODIFY COMMAND in richtiger ... Beim REPORT PREVIEW ist, abhängig von der Vorgeschichte (ob ich z.B. ... Bei MODIFY COMMAND schalte ich die Resourcen-Datei ein, ...
    (microsoft.public.de.fox)
  • Re: Individual vs.whole dB locks on forms/reports during modificat
    ... Fix access so that users can once again modify forms while others are logged ... Employ per form and per report level locks exactly like the table locks so ... >> Here's another data integrity SNAFU, say a user opens a form for modify ...
    (microsoft.public.access.forms)
  • RE: How to pass param for IN() clause to sql command?
    ... Since this is a SqlCommand at it's heart, ... Now, if only I could take these individual query files and generate the DataSet from them easily, and then modify the definitions contained in my SSRS report files! ... I suppose it is being helpful and "fixing" my quotes to double quotes ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: How to get a report to default to a default printer...
    ... Unfortunately, you cannot modify the ... DoCmd.OpenReport sReportname, acViewPreview ... If you manually open the report in design mode, change the printer settings, ...
    (microsoft.public.access.modulesdaovba)