Search results for query: *

Background: I've designed a query that tracks due dates for quarterly reports based on the anniversary date. I've used PHV's code to ensure the anniversary date is relative to the time the person is entered into the system and it all works perfectly. Problem: I need to modify query so that...

MainForm = Me SubForm = frmFCPSYCHMEDS Checkbox = FC_PsychMeds This code below works fine for showing/hiding the subform based on whether cbxFC_PsychMeds is checked. The problem is when I check cbxFC_PsychMeds for one record, it makes the SubForm appear for all records rather than the related...

tbxFirstAidStatus located on frmManagers (underlying tblManagers). Ideally, I would like to bound the textbox above to a field so I could use it in reports in queries. Is there a way to do this even though the control source is a calculated value. I can do the above with no problem if I do a...

I'm trying to write code to prevent overlapping periods a manager is assigned to a project. Here's the code: If Me!EndDate <= Forms!frmManager!EndDate And _ Me!EndDate >= Forms!frmManager!StartDate Then _ MsgBox "The start date is included in a previous manager's period."...

I have a qry question with 3 parts. Fields: [manager], [start], and [end]. 1st part: I want to be able to enter initial start date if this will be the first manager on this particular project. 2nd part: If more than 1 manager has been assigned to a project, I'd like for the new manager's start...

Help, "tblMYTABLE fields" [Person], [to], [from], [#days] "qryMTTABLE fields" [Person], [to], [from],#days: DateDiff("d",[FROM],[TO]) I have qryMYTABLE based on tblMYTABLE. My main reason for doing a query is I needed to calculate the # of days a person was assigned to project and I don't...

I'm trying to replicate the mcrContract macro in the Entertainment "Running Microsoft Access 2000" by John Viescas to assign IDs to new persons without skipping and numbers. I believe I have the conditions and actions set up correctly but I can't figure out how to have the Form start macro. I'd...

I’m trying to set up a query that automatically tracks due dates for 30 day, QR 1, QR 2, QR 3, and QR 4 reports based on the anniversary date. The anniversary date is calculated from the mm/dd of the effective date and the current “yyyy”. So far, I used the code below is as follows: Code...

My Code: REPORT STATUS: IIf(DateDiff("d",Now(),[Report Status])>7,"Current",IIf(DateDiff("d",Now(),[Report Status]) Between 0 And 7,"Due",IIf(DateDiff("d",Now(),[Report Status])<0,"Overdue"))) This code works well in setting field value at "Current" if report is not due for 8 or more days...