Search results

So it looks like the error in my code is in this spot: Private Sub cmdLogIn_Click() If userName & password = Null Then Exit Sub ElseIf Not password = DLookup("password", "tlogin", "userID = " & txtID) Then It works on the original, but not the new one that I am working with.

I did that, that is how I was able to get back in and copy the code. But when I try to step into it, it just freezes or stops working.

I tried, but it just kept freezing up.

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

OK I think I am tracking now. Thank you.

So the highlighted yellow field won't let me select just a single date to see instead of looking through the whole database.

I have a form that shows all the data in that table, but I can't get the select a date field to work to show just that date from the table.

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?

Thank you

Here is my database in zip form. Thank you

Would it be possible to upload a zip file of the database and maybe offer some feedback?

So how do I turn off Referential integrity, or do i want to?

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:

Oh that makes sense. Thank you

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?

Thank you, that worked

It would be Fiscal Year 23

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.