Search results

  1. S

    changing font color

    Hello, On a given condion I would like to change the font color in the detail section. How can I accomplish this? I am able to make a field visible and not visible using Me!objectName.Visible = true. How can I access its font color? Thanks for your help in advance.
  2. S

    Access tables in VBA in a report

    Hello, I have an idea how to do this but do not know how to write the code. In a report I would like to do the following: I have a key_id which is a hidden field on the report. For each record I would like to check the count of that key in a temporary table. if the count is 0 then I want to...
  3. S

    Finding duplicate records in a report

    Hello, I am not sure if this is possible but if it is any help or suggestions will be greatly appreciated. Lets say I have a record that falls in 2 or more categories. I would like to mark (change the font color) for the repeating entires. For example: Table A code name...
  4. S

    Report formatting

    Hello, I have a report that is made in landscape view with margins set to be .5 for left and right. Once I open the database and click on a button on a form that opens the report it displays fine. But problem start to arise after I close the report and click on the button again. The report...
  5. S

    Page Breaks and tables

    Hello, I would like to know if there is a way to insert page breaks depending on the output. Lets say I have a memo field on a report and under that i have a static table (Just lines with some fields so it looks like a table, NOT an access table). now what I want to do is if memo takes up...
  6. S

    Size keeps on increasing

    Hello, I have been working on a database which started out to be 7MB. I added some reports and some more queries to it and eventually it got to 8.5MB which was reasonable. The problem started arising when in one of the queries I omitted a column, the database size just shot up to 13MB and then...
Back
Top Bottom