Recent content by krc547

Nevermind. I needed the form to Requery once they enter the dates so the query can grab the information. Thank you.

Ok so the form is letting me enter dates now but it is a continuous form and it is not loading the data. The query runs the data just fine.

So I changed my Query and the form opens now but will not let me enter a date in the fields on the form.

What if I took those two fields out and did a Between in the criteria referencing the startdate and the enddate on the form?

Yes, when I add [forms]![fadaseniors]![startdate] in the criteria field the form still errors.

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.

Worker perfect! Thank you

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

That was it, I forgot to give it a name. I have a parameter in the report that asks for the fiscal year. But then when I click the button to export the report it asks me the same questions like 5 times before it actually exports the file.

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.

His instructions say open any module and compile/decompile. I have no modules to open.

The screenshot is fe, but I did recheck the be and everything is linked.

It won't even let me open it without holding the shift key, or it locks up.

It does have a backend and I did relink it once I got it back. I have not decompiled/compact yet. I waiting for the admin to get back to me.

I created a copy of the whole db and sent it to a friend, he did a change to one of the tables to fix it (nothing to do with the login) and sent it back. The one he sent back is the one that freezes up or doesn't work with the login.