Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Haccess
  • Content: Threads
  • Order by date
  1. Haccess

    Field references from various report sections

    Hi. I need to highlight certain records in a report. My specific question is how to reference a field in a report underlying data source query to change the visible property of a label in the report detail header section. Here's what I'm trying to accomplish: Private Sub...
  2. Haccess

    Complex query/update approach?

    All, I need some advice on how to approach a complex query and update problem. I need to identify all records in a contract line items table that are currently late to contract for reporting purposes. The tables involved are: CLINS (the individual contract line items and associated...
  3. Haccess

    Multiple columns possible on a sub-subreport?

    Hi. I have a nested main report, a subreport, and a sub-subreport (think invoice no., line item no., and serial numbers). How do I get the serial numbers sub-subreport formatted with snaking columns so they don't take up so much room on the sheet? The subreport shows multiple columns in...
  4. Haccess

    "Running Sum" Comparisons by Date

    Hi. I need to add some functionality to an existing report that compares actual deliveries to required deliveries. The parent report is grouped by contract line item number ("CLIN"), with two subreports linked to the parent CLIN by CLIN_ID. To keep things simple, we'll call the parent report...
  5. Haccess

    Best way to calculate and update table fields after form entry

    Hi. I'm working on an Access app designed to track delivery status to contract. Contractual requirements take the form of Contract Line Item Numbers or "CLINS." Each CLINS table entry includes a total contract quantity for each CLIN along with an IS_COMPLETE Yes/No field to facilitate...
  6. Haccess

    Calculations/Field Updates after Form Data Entry

    Hi. I'm working on an Access app designed to track delivery status to contract. Contractual requirements take the form of Contract Line Item Numbers or "CLINS." Each CLINS table entry includes a total contract quantity for each CLIN along with an IS_COMPLETE Yes/No field to facilitate...
  7. Haccess

    Using Report Query Fields to Format Detail Controls

    Hi. What's the general syntax for formatting report detail controls' forecolor based on the value of a field in the report's data source that isn't shown? Background: My report's data source includes a field called IS_HIGHLIGHTED (yes/no data type). I want to highlight the forecolor of...
  8. Haccess

    Determining Detail Section Height for Line Method

    Hi. Today I discovered the Line method for report sections. Seems very powerful--I'm hoping I never have to physically draw another line in report Design View again. However, I'm coming up short figuring out how to determine the height of the current report section so I can code the Y2...
  9. Haccess

    player doesn't display correctly

    Lord, I go to give Quicktime 5 a chance and this happens: http://home.carolina.rr.com/haccess/qtweird.png The splash screen was just a grey box... I remembered back in the day it used to ask if you want to upgrade to pro or not so I just clicked at random and got the player to load... and it...

Part and Inventory Search

Back
Top