Recent content by nschroeder

I found the problem. In FormLoad, I had tbReportDate = Now() instead of Date(). My bad!

I see your point. I also have another problem. I have the date picker textbox defined with a format of Short Date, and that's the way it appears when the field doesn't have focus, but if I click in it, it shows up as date/time. Not only is it ugly, but it affects the query results, because it...

I have a field in a table containing date/time values, and want to use a parameter query with a form from which the user can enter a value in a date picker textbox. When a date is entered, however, no matching records are found because of the time in the field values. I can get it to work by...

Would be interested to see if others are getting the same results. Please be sure to follow my instructions exactly.

I'm on 2013, but I tried it on a 2007 machine with the same results. I've attached the db. First, open the FileDates table and note that there are date records for 9/23, 9/26, and 9/27 (yesterday's date). Then open the File Process Dates form. The Load code will run, but instead of creating...

I don't know how things work internally, but I suspect that with the presence of a subform, the system needs to resolve the first GoToRecord in both forms before it will allow another one. Is there a way to force that to happen?

Static: FileDate doesn't have a value until you've moved to the last record to get it. Missinglinq: Yes, that's correct. Gemma: I tried If DMax([FileDate], "FileDates") < Date, and the DMax function returned 2.34962406015038E-04, which if formatted equates to 12/30/1889. DMin returned the...

I had cut out an irrelevant IF, but failed to cut the matching End If. I fixed it above. Sorry for the confusion. If you read my first paragraph, you will see why it is needed, so I won't repeat.

OnOpen gets the same results. OnCurrent wouldn't apply here.

I'm creating a form tied to a table with only a date in it. The subform's table has the date and a filename as the PK (multiple files per day). The Form_Load event goes to the last record and checks the date. If it is < today's date, it creates a new record with the current date, so the first...

Update: I got on the 2010 PC and created a new, empty database. I then linked to the tables in the original, and copied all the other objects over. It didn't help -- I still got the error. I checked the references in the new database, and Microsoft Outlook View Control was not selected...

I have a db that includes buttons the users click to send queries as email attachments. It has been working fine, but now they get the error "can't complete the Output operation.". It works fine when I run it. I'm on Office 2013, and they are on 2010. If I log in to a 2010 machine, it doesn't...

Does someone please have an answer to how to make filters work on a subreport?

If you could please explain why adding "SNum = 1" as a filter to your SubReport (or my Section1 report -- they are both the same) generates an error, that would get me on my way. That was my original problem I wanted resolved.

It's not exactly what I wanted, but I think I could make some adjustments to make it work. Am I right that you can't use filters on subforms?