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 Chriss Miller 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 marcellvries

  1. marcellvries

    Me.Controlname active record instead of record1

    Hi PHV, Thank you for your quick response. I can't remember the reason why I put Me.Requery in the code, but I had one :) Removing it solves the problem. Thanks! Marcell
  2. 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...
  3. 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...
  4. marcellvries

    Planning system - Copy planning from previous week

    Hi JBinQLD, It works! For further reference and to help other people I will include the codes below. Again thank you for your help JBinQLD. With kind regards, Marcell The commandbutton on the form: Private Sub cmdCopy_Click() DoCmd.SetWarnings False DoCmd.OpenQuery "qryCopyLastWeek"...
  5. marcellvries

    Planning system - Copy planning from previous week

    Hi JBinQLD, Thank you for your quick reply! I prefer the learning-way also because with copy&pasting I'll never learn to master Access. I'm going to try to put the things you wrote into practise now and let you know when I succeed or when I run into any trouble. With kind regards, Marcell
  6. 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...
  7. marcellvries

    Double entry warning

    Hi TheAceMan1, Finally I have something that works. I removed "tblPlanning_1.WerknemerID, " & _ from the SELECT statement, and I changed the Cri statement to [COLOR=red]Cri = "[PlanningID]=" & varPlanningID[/red] (since it is a numeric field). The code now looks like this: Private Sub...
  8. marcellvries

    Double entry warning

    Hi, Thank you very much for your reply. Yes, the query returns all duplicates. In my previous post (which I was typing at the moment you sent your reply) you can see that in case of one clashing event, it appears two times in the query. So when there are two clashes, it appears four times in...
  9. marcellvries

    Double entry warning

    Hi TheAceMan1, I thought about the matter and looked at the query that I already had. When a 'clashing' event occurs it appears in the existing query as follows: tblPlanning.PlanningID tblPlanning.WerknemerID tblPlanning_1.PlanningID tblPlanning_1.WerknemerID 158 7 159 7 159 7 158 7...
  10. marcellvries

    Double entry warning

    One thing I forgot. Eventually it would be nice to see in advance who is available during a specific time. For example that when you enter the start and end time of a new event, people who are still free appear in green while people who are occupied appear in red. I think this is still far away...
  11. marcellvries

    Double entry warning

    Hi TheAceMan1, Thank you for your quick reply. I'm not sure if I understand everything correctly but this is my idea: I think that I have to execute the above code in the BeforeInsert part of the form. Is that correct? In the Load part of the form I have to declare the variables: Dim...
  12. 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...
  13. marcellvries

    SQL Query, Clashing events

    Hi Golem, Thank you for your quick reply. These fields are indeed real DateTime fields. I just tried the following code and it seems to work! SELECT tblPlanning.PlanningID, tblPlanning.WerknemerID, tblPlanning.Bweergavedatum, tblPlanning.Edatum, tblPlanning.Btijd, tblPlanning.Etijd...
  14. 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...
  15. marcellvries

    SQL Statement: INSERT & DELETE

    Hi Golom, Thank you very much! First it didn't work but then I removed the referential integrity between tblPlanning and tblRealisatie (don't ask why I enabled that in the first place ;) ) and now it's working fine. I hope someday I will understand VBA the way you do. With kind regards, Marcell
See more

Part and Inventory Search

Back
Top