Search results

Debug.Print works as described - thanks - but still stumped by the data type mismatch error, specifically: Run-time error '3464': Data type mismatch in criteria expression. Here is my current code with a note on Debug.Print: Private Sub cmdSearch_Click() If Len(cboSearchField) = 0 Or...

I am trying to adapt an example to filter a form using a second form that collects both a field name (cboSearchField - all options are text controls) and field content (txtSearchString) and passes their contents to: Private Sub cmdSearch_Click() If Len(cboSearchField) = 0 Or...

Thank you, that's exactly what I need. Looks like I had bad syntax, yes?

JHB - I've uploaded the database with sample data. The problem area would be found in form PersonalMasterF under the Radiothon tab, which contains the RadthonSubF sub-form. The code based on your query suggestion is in RadThonInvoiceQ1/Q2, the report is RadthonInvoiceR. As this stands, it...

OK, trying a new tack here, to try to get the first query to filter to a single donation record. This code ... SELECT Forms!PersonalMasterF!RadThonSubF.Form![MasterID] AS MasterID, Max(Forms!PersonalMasterf!RadThonSubF.Form![RDYear]) AS RDYear FROM RadThonT; ... successfully finds a single...

Thanks for that! To explain the context a little better: In this database the donations file (RadThonT) is linked to a contact file (ContactMasterT) by a field called MasterID. The user looks up an individual in a form, and then has available all of that individual's donations in a sub-form...

OK, just getting my feet wet in VBA. I am working on a volunteer organization's database, and am trying to create capacity to print an invoice for a donation pledge. I have a sub-form that displays donation records for a selected individual. From the sub-form I have created a command button...

Hello, is anyone aware of a way to set a form validation rule such that a DD/MM/YYYY date entry must always be the last day of the month specified?

Figured this one out myself, after lots of research - sub-queries don't work, but if I create a second query based on the one with the calc fields and pass the fields to the second query, the select criteria work fine in the second query.

Hi: I've created a query that finds the last non-zero field in a series of fields and captures the year and amount in calculated fields. I've defined the fields in the calcs by wrapping the expressions in CDbl(). When I try to use the calc fields as select criteria, however, my calculations...

Hi, I'm a non-progrmmer taking on a complex Access build for an NGO, so it's definitely learn-as-I-go. Presently at this :banghead:stage and looking for help.