Search results

I have an Invoice form to display all of a clinician's billable times per day. This form is not opened directly, but triggered by any one of three different forms where "billable time" work is entered. Every time a "billable time" work is triggered, the Invoice form is opened but the subform...

I have a form with a subform. This form is to keep track of billable time per day. When entering data directly, there are no problems. However, I want to open the form from another form where the "billable time" is initiated. When I enter the billable time then exit the field, the billable...

I have a form which lists details of a Clinicians work including his "billable time" per patient appointment. On another form I have the Clinicians Notes, date of patient appt. and if the time is billable. I have triggered a "billable time" afterupdate from this form, then use a macro...

Thanks very much. The online help showed DateSerial Function would only work with "numeric" input (year "2000", Month "5") and so on. It works perfectly.

I have a form that shows from and through dates. The from date is a fixed date - "Patient admission date" through "the last day of the previous month" previous to the "current" date. My current DateSerial function is =DateSerial(2000,5,1-1). Can I automatically update the "month" and "year"?

Thanks, Axis. But how do I "hardwire a criterion"?

I have entered a DLookup =DLookup("[Referral]","tblRefer","[ReferID]=" & Forms![frmReferral]!ReferID) and it works, but only if the frmReferral is Open. Anything I can do without having to open the other form?

I have a form with a subform. In the subform the client enters an activity then the time (hour?-maybe), minutes and seconds) to perform the activity. The times entered are accumulated (on another form) for the day. The daily total of the time field is then used to calculate a total pay for...

I have a form based on a query. Two fields are DOB and Age. The Age field datatype in the underlying table is number. I use the following as the Control Source in the Age field: =IIf(IsNull([DOB]),"",Year(Now())-(Year([DOB])-(DateSerial(Year(Now()),Month([DOB]),Day([DOB]))>Now()))) I cannot...