Search results for query: *

Actually, I just found a thread that explains why my first approach at doing this, conditional formatting of the label, wasn't working: http://www.tek-tips.com/viewthread.cfm?qid=1370627&page=7 I was attempting to set the expression to [IS_OPTION] = True. Apparently you need only the field...

That's a really great reference. Thanks. However, in this specific case I need to check the value of a field, not a control, from the report data source. It is in the underlying query, but not contained within a control anywhere on the report. How do I update the unbound label's properties...

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...

Thanks for the suggestion, Remou. I ended up receiving some local help from an experienced user who suggested not actually flagging the CLINs since this would be a redundant bit of data being stored. He came up with the following function: Public Function PositionToContract(lngCLINS_ID As...

Remou, Technically speaking, I suppose you are correct. However, from the perspective of "satisfying" a single SIDS entry, that makes things a little trickier when you consider the following: Take the data I supplied as an example. If the very next shipment is for 10 pieces (toward the CLIN...

Remou, Unfortunately, that's not possible due to the way the contracts are structured by our customer. The contractual delivery schedule is contained within a standard appendix to the contract called the SIDS (shipping instruction data sheets). The SIDS is broken out by date due, and lists...

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...

That was the ticket. Thanks!

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...

Sounds reasonable, but I'm afraid I'm over my head writing this query expression. Here's what I tried (and failed miserably): To the underlying query for the required deliveries subreport, I added fields from the tables that supply the actual delivery date and quantity. Note that, because of...

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...

So I asked around and it was pointed out to me that you cannot simply copy your Query SQL View code directly to VBA. Apparently it doesn't like all the double quotes. That said, I now have a functional update routine that runs after Form_Update: Private Sub Form_AfterUpdate() 'Turn off...

Dang. Same error. Thanks for the help--if something comes to you in the night, I'll give it a try. In the meantime, at least I have a functional workaround using your earlier suggestions. Thanks!

No dice. Same error message. It did, however, take a little longer processing before delivering the bad news, but the end result was the same.

Must be some kind of logic data type error conversion going on ('True' vs. '-1' maybe?). Access nasty gram: "[App Name] didn't update 1027 fields due to a type conversion failure <snip> ...

Right you are. I somehow screwed up the first attempt at cutting and pasting your SQL statement into a working update query--I was surprised to see you need only the one table being updated and not the second table upon which the criteria expression is being run. All it took was a few mintues...

Thanks, PHV. I think I'm getting close, but need a bump over the finish line. The problem is that my update query returns one entry for each delivery line item instead of only one "grouped" entry with a total for each CLIN as the select query does. Here's what I have: UPDATE CLINS INNER...

So I successfully created a Select query that returns all CLINs that should be marked IS_COMPLETE = True, but are not. Note: There is a bit more of the relational structure of the db apparent in the SQL statement below than I disclosed in my earlier post. Simply put, each DELIVERY in the...

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...

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...