• dynamically add text to a report control

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » dynamically add text to a report control

    Author
    Topic
    #463725

    not even sure where to start with this one.. i have a function that compares old and new values in two queries and, using Debug.Print, I can get a nice list of named fields and old/new values. what i am asked to do is put this sort of data on a report, and well how do i do that? i need some kind of response.write to a control. if this is not possible in Access, any advice on how else to do it would be great. the report in question will be generated and printed on-site from laptops, no network or internet will be available.

    TIA!

    Viewing 2 reply threads
    Author
    Replies
    • #1184851

      You could create a table with 3 text fields:
      – FieldName
      – OldValue
      – NewValue

      Create a report based on this table.

      Write code that

        [*]Deletes all records from this table.[*]Uses your function to add records to this table, instead of writing to the Immediate window.
    • #1184852

      Steve

      I was going to say the same as Hans, I have a series of tables that I use to archive old values (mainly for back up purposes) which could be used to store the old values. I would as go so far as to increase the number of fields that Hans suggested to include the record_id for referential purposes

      • #1184853

        I would as go so far as to increase the number of fields that Hans suggested to include the record_id for referential purposes

        Good idea. One could add other fields as needed, for example the Field Type of the field, if available a Modification Date/Time, etc.

      • #1184856

        Steve

        I was going to say the same as Hans, I have a series of tables that I use to archive old values (mainly for back up purposes) which could be used to store the old values. I would as go so far as to increase the number of fields that Hans suggested to include the record_id for referential purposes

        Thanks. this part of the project is going to be a bit crucial… well, it’s the pith of the whole thing, as we will be uploading items name/value pairs to a backend system which will also be used to support petitions to change the values back if needed. so, I need to ensure there is a defined table with three columns: old, new, reconsidered. the header will be person making change(s), date of commit, date of upload, date of reconsideration, perhaps a few other things. Big project, overall.

    • #1184854

      good idea… just for kicks i wrote the string to a messagebox, which works but not any kind of solution, obviously.

    Viewing 2 reply threads
    Reply To: dynamically add text to a report control

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: