Recent content by freddy k

  1. F

    Showing a warning message if records share 2 fields

    Hi, I've tried searching the forum but not quite sure what to look for. I have a form which displays a table in datasheet view: Day: (Date) Shift: (Text) WorkerID: (Looks up worker from a different table) Shifts are pre-entered and then workers are assigned to shifts as and when. I'm trying...
  2. F

    Fitler subform by date range?

    Hi, Thanks for your reply. I appreciate what I am trying to do is probably beyond the realms of a novice. I've tried to attach a zip of the database but it's too big. The basic table layout is tblWorker: WorkerID First Name Last name tblSite: SiteID Site name tblShift: ShiftID Date...
  3. F

    Fitler subform by date range?

    Hello, I am a complete Access novice but have been asked to create a database for work. I work for a kind of employment agency which sends support staff to various sites throughout the city. So far I have 3 tables: Worker Site Shift requests and have linked workerID and siteID into...
Back
Top Bottom