Search results

Hello: I am trying to automate a membership status flag based on comparing today's date and a recorded expiry date. The expiry date control is on a sub-form. I have the following code in the OnLoad event of the master form: Dim DateGap As Integer While Me.CurrentRecord <...

Hi there: My database is set up so membership information for a selected contact is displayed in a subform. I am trying to run an update query from a command button macro to select the subform data file record for the most recent membership record and set a field on that record to a value of...

Is anyone aware of a way to insert a half-line feed into text in a control?

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

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?

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.