Search results

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?

Thank you for the reply. However, the problem remains. Your "SubReport" appears to be just a copy of my "Section1" report, but with the "SNum=1" filter removed. When I add it back, the error message returns. When I open Section1 (or SubReport) by it self with the filter, it works just fine...

Sorry, but this will take a bit of explaining. I'm developing a Pre-Underwriting QC Checklist for our loan processors. It includes 66 questions that are divided into 15 sections. The main form, Audits, has one record per loan, and 15 subforms (Section1, Section2, etc.) on a tab control, since...

I resolved it by storing the actual employee name in the audit file, instead of the employee ID, switching the column count to 1, and changing the Limit to List parameter to No. It's not as efficient, storage-wise, but it solves the problem.

I don't want terminated employees to appear on the list. Otherwise, they'll be calling me saying, "please remove so-and-so from the list, he no longer works here".

I'm creating an Audit form with a combobox from which the employee name performing the audit can be selected. The data source is the EmpNames query which selects from the Employees table, linked to another database. The EmpNames query includes a record selection criteria where...