Search results for query: *

Thanks for the help all, but in the time of posting and the time I picked up a reply, I have used conditions in a macro to achieve the same results. Thanks so much and I am sorry for wasting all you time. Dom

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...

The 2 tables are needed as one is a master (current Table) and the other is a history table. As along the point of a contract, we really should give contractors a pay rise. With a history table that means we can report on old information. I already have the one to many relationship set up, but...

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...

Oops Sorry, The bit highlighted is Private Sub ShowRecord_Click() Thanks

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)...

Thanks for the help guys, I have actually got around the problem without any programming by using lots of queries and reference tables. It is a bit of a nightmare but it seems to be doing the job, from what testing I have done. And I have a major headache now..... Thanks again Dom

Thanks for the help John, but this function does not do what is required, Is it true that Access does not have any in built functions to recognise work days and work time. Will I have to construct a VB script to acheive my requirements? Can anyone shead any light on this? Dom

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...