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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by figgis

  1. figgis

    Overlaps

    Hi I am being driven mad. Am reading SQL for Dummies, when I discover an operator called OVERLAPS which is meant to return true or false if 1 time range falls within another time range, brilliant I thought, but can find no meaningfull references r examples to it, only the occasional mention. My...
  2. figgis

    Test if time is booked in diary

    Terry Thank you for your time it has been a help to know it is not an easy task. (will re assign myself as a Technical User) :) Jim
  3. figgis

    Test if time is booked in diary

    Thank you so much for responding, I work in an environment where anyone using word is considered an egg head. I think you are at the nub of my problem. looping through my recordset of times to check if the slot is free. I assume it should be a procedure on the after update event of the...
  4. figgis

    Test if time is booked in diary

    ah I must have explained my self badly, I have two fields StartTime and FinishTime, as in a diary, I want the user not be able to enter in a time that is alredy boooked,(between these times) obviously if there was only one other booking on a day it would be easy, but there could be an unknown...
  5. figgis

    Test if time is booked in diary

    Hi I have written a diary application, but on the diary entry form I want to test if a time is free i.e. 09:30 to 11:30 booked 12:40 to 15:00 booked If a new entry is made that it is not allowed to enter in any booked time. This has stumped me for a long time Jim Johnson
  6. figgis

    recommendations for a book on ADP

    Looking for a book on APD, I am not a beginner with MS Access but I am a beginner with SQL server, any recommendations from experience please
  7. figgis

    Re Indexes in table design

    I have a diary application which I am trying to speed up, have combined some fields in a multiple index ie Date and Name. Question is when using muliple indexes what use is the Index Name and when is it used, and does Access automaticaly use this new index or do i have to call it somehow.
See more

Part and Inventory Search

Back
Top