Search results

I have a form linked to a table which is used to edit the table. There is a button to save the table, but I also want to add the function of creating a new entry for a backup table to preserve the old record (with a version number that changes to know which versions are which). I keep hitting...

I have a report with a form that supplies values for it to filter the fields in the report on, but also checkboxes to make the fields "disappear" if the user doesn't want them in the report. Problem is I can't get the mechanism to make them disappear work right. Here's the code I made...

So I have a report with a lot of fields that the user needs to be able to filter from a form full of combo boxes and text boxes. I've made code that I think should work but isn't. DoCmd.OpenReport "Custom Report", acViewReport, , whereString If Not IsNull(Me.txtID) Then whereCriteria =...

Hi, I'm trying to use SQL coding in the WHERE criteria to get a query to either A: evaluate a series of formulas from a table based on information from the date entered in a datebox OR B: evaluate a series of formulas from a table based on the year to date by default if the datebox is left...

I have an Access Database with a multi-column list box, and I want to hide certain columns based on if certain checkboxes are checked or not. As it stands, I can use code like If ChkClient = 0 Then Me.lstDisplayReport.ColumnWidths = "0; 1 in; 0; 1in ; 1 in; 1in; 1 in" Else...