Recent content by AZ_CC

That doesn't make sense to me, though - there will be more than one amount when there is more than one funding source. Is that intentional, to keep the client tied more closely to that funding source then just via the transaction ID?

Okay, I think I'm getting closer. I'd need to have one table, tbl_Transactions, that included all the common information that's not dependent upon the clients or program specific expenditures. Then, I'd need two junction tables, one each for the client and funding table that included any info...

Yes. Our grant funders absolutely *do* require that we be able to tie specific funding expenditures to specific clients. We were literally audited on being able to produce this last week, and it's part of the reason we currently maintain a number of *separate* excel sheets and Access databases...

This is what I was leaning towards. I'm just not entirely sure how it will work to then relate Client expenditures made for them in different funding sources. I can see how you can 'follow' the key trail (this Client is tied to this ExpenditureID via the junction table, which it tied to this...

I've done some poking around, but haven't been able to get my head around this. I'm working on modeling expenditures for a non-profit, and I'm not sure how to proceed because there seems to be more than one many-to-many relationship involved. A given expenditure will have 1 or more funding...

This is specific to a memo field - when I was researching around after the corruption happened, I discovered that memo field corruption damage can often be limited by storing those fields in a separate table with a 1-to-1 relationship. I'd still lose the text in those fields. I've not used the...

I'm currently building up a database, and want to improve the way I'm handling the memo fields. I'd thought I'd planned for it fairly well, but had the first corruption problem at about 750 records. Right now, I'm simply using a bound text box with the underlying table as a record source for...

I thought the DCount/DLookup I'm relying on in the end only worked if those changes had been saved to the underlying record source? I can run the code in that event if the D functions will function, but I'm also concerned about triggering what's turned out to be a very slow operation...

It ends up working to use DCount as a more robust solution; I have a query set up to break out the value selected in the multi valued field, and can use that so that these Dcount statements get me the info I need on the selections made: Dim iSelectedTopics As Integer Dim iSelectedNone...

That will work, although it's not as elegant as I'd like. I can probably also use a DCount of one flavor or the other in the OnExit as a safeguard in case the combo box AfterUpdate event is never called (because the user left it blank). I assume that's the same reason I can't use .ItemData to...

I'm having issues with a snippet of my code. I have a mainform, called frm_Youth, and two subforms I'm using to emulate a split form, called sbfrm_CasenoteSummary and sbfrm_Casenote. One of the fields on the sbfrm_Casenote subform is a mutivalue combo box. I want to require than input, but...