Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dommales

    Action from a command button

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

    Action from a command button

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

    From updates

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

    A nice easy one - VB code

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

    From updates

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

    Pick list quey.

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

    Pick list quey.

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

    Work time queries

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

    Work time queries

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

    Work time queries

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

Part and Inventory Search

Back
Top