Search results for query: *

Ok, now this is a good one, Probably very basic, but it needs to be done. Can I add a Iif statement to a command button to open the specific query, dependant on a value in a database field? For example: IIf([Contractor Details]![Contract Type]="AGENCY",/OPEN AGENCY...

can someone explain this code please. Private Sub WeekendDate_AfterUpdate() 'MsgBox [Bill Rate] & " " & [ContractorRate] If [ChargeRate] = " " Then [ChargeRate] = [Bill Rate] Else [ChargeRate] = [Bill Rate] End If End Sub I'm having a dense day. Thanks Dom

Ok, this is a really bad question to ask, but it is driving me up the wall. I have a table of information: ConID name charge/hour 1 Dan 24 2 Dave 30 and I need to have the following table populated for hyours worked: ID conID Charge/hour Hours...

Hi, I have the following code on a form: Option Compare Database Option Explicit ------------------------------------ Private Sub List0_AfterUpdate() ShowRecord.Enabled = True End Sub -------------------------------------- Private Sub List0_DblClick(Cancel As Integer) If Not IsNull(List0)...

I have a query that I wish to construct that adds 2 hours to a gerneral time format. This is DD/MM/YY HH:MM The only issue is that it must only add working hours. It must consider that the office is only open from 09:00 till 17:30 and only during the week. Hence if the time is 16:30 on a...