Search results

I have a query that I would like to get the dates from a form I have setup. The problem I am having is that there are formulas in the fields and I keep getting an error on the form when I try to run it.

I have a table and I created a query that I wanted it to pull a certain type from the field for the fiscal year that was asked. In my criteria I had "Fixed", then I decided I needed to see "Special" as well so I added it to the or field in the query and then it returned not just fiscal 2023...

I have a button on my report and have this as the code: DoCmd.OutputTo acOutputReport, "rFiscal-Month Comparison", acFormatXLSX, "C:\Users\kcummings\Desktop", True But it just errors out and says it can not export the report.

I have a database that I am working on just changing some design stuff from the one I have now. The old one runs fine and the new one ran fine until I copied this code over which is identical to the old one and all the tables are the same but the FE freezes every time I try to open it. Private...

Is there a way to create a form to allow a user to select a date and it will show the data input for that day and change the data if incorrect?

I have two tables. I have a fixed category table and a Route table. when I try to input data on a form it returns this error:

Is there a way to get a report to export automatically to excel when the report is closed? Or is there a way instead of viewing it to automatically export it to excel?

I have a database set up and I need the report to return the data by fiscal year and fiscal month. For example our fiscal year runs from July 1 through June 30. So I would need the report to list the months from July to June with fiscal year.