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

    Me.Controlname active record instead of record1

    Dear all, I've created a complaint form database where people can enter complaints. If the complaint is resolved, it can be closed by a specific person. When you click the 'close complaint' button, the system is supposed to check whether two specific fields are filled in. If not, a message...
  2. marcellvries

    Query to see available employees

    Hi there, I designed a planning system which works great. However there are always things to improve. It looks like this: qryPlanning PlanningID LocationID EmployeeID Start End 1419 36 81 15-2-2009 13:00:00 15-2-2009 18:00:00 1420 36 88 15-2-2009 13:00:00 15-2-2009 18:00:00 1421 36 1...
  3. marcellvries

    Planning system - Copy planning from previous week

    Hi there, Currently I'm designing a planning system in MS Access for a security company. It is going well but I got stuck at one issue. Background I have a table tblPlanning with the following fields: PlanningID, LocationID, EmployeeID, Startdate, Enddate, Starttime, Endtime. I have a...
  4. marcellvries

    Double entry warning

    Hi there, I'm designing a planning system in Access. Last week I (with help from you) created a query that looks for double entries (http://www.tek-tips.com/viewthread.cfm?qid=1479557&page=1). Now I would like to create something that when a user adds a new event, the above query is executed...
  5. marcellvries

    SQL Query, Clashing events

    Hi there, I'm designing a planning system in MS Access and currently I'm working on a query to identify events that overlap. Until now I have the following, which checks for the same employee (WerknemerID) assigned to multiple events at the same time. SELECT tblPlanning.PlanningID...
  6. marcellvries

    SQL Statement: INSERT & DELETE

    Hi there, I'm developing a database (planning system) and I'm facing the following problem. When I click on a button on the form, I would like to add all records from tblPlanning with Confirm = true to tblRealisatie and subsequently remove those records from tblPlanning. So in fact I would...

Part and Inventory Search

Back
Top