Search results

  1. S

    Check date and time when entered

    Access 2000 So i have an events form. Which stores Date, StartTime and EndTime What i want is when a user adds a new event that it doesn't clash with any events already in it based off those 3 values. So if there is an event on 16 March at 1pm till 3pm then you can't add another event on...
  2. S

    Crosstab Date Help

    Trying to take todays date then show all records that are 12 months before the date. e.g. March 2010-Feb 2011 Set up just like a rolling financial report. The problem is in my coding somewhere. PIVOT Year([Date])*12+Format([Date],"mm")-(Year(Date())*12+Format(Date(),"mm"))+1 In...
  3. S

    Required Multiple Records in Sub Form

    Two problems. Using Access 2000 1. I need the user to be able to enter 15 records in my subform and only 15. Currently using this bit of code to limit adding 15 records and it works. If Me.RecordsetClone.RecordCount > 14 Then Me.AllowAdditions = False End If What i need is a way so the...
  4. S

    start at nth record then select every 15th record after

    access 2000 The query is basically getting the user to enter a month/year and a number from 1 to 15 which would select a row within that month then also select every 15th record. So if the user entered 01/2011 and the number 4 it would select all records in jan start at the 4th record then add...
Back
Top Bottom