Search results

Ok, So Event Data was just a query of all the EventReport data. I'm not sure why this was being used, but I can see the Event Form is a Dynaset Recordset type. The button on my Main Switchboard is setting an SQL query (like this: sSQL = "SELECT EventReport.* FROM EventReport ORDER BY...

Ok, comparing the current version with an older version, when opening the Form and going to Sort & Filter -> Advanced -> Advanced Filter/Sort... in the Table/Query section the "Table" name is "Event Form" in the new version (this is the name of the form), and in the Old version the "Table" name...

Hi, For the example shown, the control is a combo box, which reads a set of default values from a table. If I filter using the Ribbon control on say "Not Started", I can't then use the Ribbon Filter to filter on other combo boxes on the form (i.e. "Severity" which is also reading some values...

Hi All, I can't figure out Form Filters. Basically I have a load of controls on the form. The first control I select I'm able to click the Filter button on the Ribbon and get shown a load of checkboxes to filter the field on (see capture.png) On subsequent controls, clicking the Filter button...

Hi, I've taken over the running of the front end of an access database. It's old and antiquated, but is owned by our client and they don't want to move away from it. (it's probably worth pointing out I'm new to VBA, and not a programmer). Most of what the users want in stored in one table...