Recent content by ProtegeV2

I have a report based on a query where: WHERE (((tblSchedule.[Cheque Date]) Between [Enter start cheque date] And [Enter end cheque date]) AND ((tblSchedule.Decision)=[Enter Decision A or R (Approvals/Refusals)])) I would like the event procedure to display a report named "rptPrimaryCategory"...

Hi there, I have a report based on a query where: WHERE (((tblSchedule.[Cheque Date]) Between [Enter start cheque date] And [Enter end cheque date]) AND ((tblSchedule.Decision)=[Enter Decision A or R (Approvals/Refusals)])) I would like the event procedure to display a report named...

Thanks so much, it works!

I should have mentioned that I tried taking off the brackets and received the following message: The OpenForm action was cancelled. You used a method of the DoCmd object to carry out an action in Visual Basic but then clicked Cancel in a dialog box. Yes, [Docket #] is a number field size...

Now I'm getting a message that the form name is misspelled or doesn't exist. It is spelled correctly... Private Sub Command99_Click() On Error GoTo Err_Command99_Click Dim stDocName As String Dim stLinkCriteria As String Dim strWhere As String strWhere = "[Docket #]= '" &...

Thanks, but it still opens [Project Request Form] on record 1. Do I need a DLookup or something to get the matching "[docket #].[Project Request Form]"?

I want the "Project request form" to open the same record displayed in the tracking form. It opened record 1 on the project request form. Thanks.

I don't know if you need this, but the form's On Current is: Private Sub Form_Current() Me![txtDocInv] = DLookup("[SumofInvoice Amount]", "[qryInvoicedTD]", "[Docket #]=" & Me![Docket #]) Me![txtEstimate] = DLookup("[SumofTotal]", "[qryEstimates]", "[Docket]=" & Me![Docket #]) End Sub I'm...

I love you PHV! Thanks, it's perfect.

I ran the query with Start Date "1/1" and End Date "3/1": Date Range 1/1/2005 - 1/31/2005 1/1/2005 - 1/31/2005 1/1/2005 - 1/31/2005 1/1/2005 - 2/22/2005 1/1/2005 - 2/22/2005 1/1/2005 - 2/22/2005 1/1/2005 - 2/22/2005 1/1/2005 - 2/22/2005 1/1/2005 - 2/22/2005 1/1/2005 - 2/22/2005 1/1/2005 -...

The dates I mentioned are both from [SchedDate]. The list sorts correctly for January - three records in February aren't in proper ascending order for some reason. The sorting and grouping on reports usually allows date fields to sort by "year" instead of "each value". Can you remind me how...

Can someone please tell me why my records aren't sorting in ascending order? 02/09/2005 appears after 02/16/2005. Here is my SQL - the report is grouped by "Date Range" - each value - group interval 1. SELECT [SchedDate] & " - " & [EventEnd] AS [Date Range], tblSchedule.StartTime...

Thank you, I will give it a try.

Hi, Is there an easy way to run a report by week (7-days)in calendar format? I want to display the weekday with the corresponding information i.e., [event name] below it. In my SQL below, how can you list "WhatDay" for each weekday for the month/year requested with the event information below...

Thanks RoyVidar. Can you tell me where do I put the code? In a module??