Recent content by Slimjimmpc

So i have now been told it doesn't need to block the events but rather have a warning box saying an event has been booked on the same date. Its just how to check the date has been taken by other records then display either a label or message box.

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

it works but i need to be able to put it into a report. was planning to use In (1,2,3,4,5,6,7,8,9,10,11,12) then i can use those on the report and it would auto update. When i add In (1,2,3,4,5,6,7,8,9,10,11,12) to the end of the pivot i get the 1-12 but the cells are blank

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

Thanks for your time anyways. I decided to redo it all and eliminate the yes/no and change them into the misuse combo box. This way i don't get lots of empty records taking up space and searching for them becomes very easy. To me it seems more logical to eliminate yes/no and save space and...

Well i need to be able to do reports by bringing back one particular misuse/incident and supplying information such as the patrol it belongs too, location, new, action taken which is where they would enter 1-15 (e.g 7=litter and would bring back all rows related to litter within the month...

Ok thanks alot. Take a look and try anything. The main problem is the 1-15 misuses on the patrol sheet form. The user needs to be able to pick out one of those rows by month and then another by month and site. If you can think of a better way of doing the entire database...

So its turns out it does work but now i can't get the date parameter to work with it Format([Date],"mm/yyyy") [Enter Date MM/YYYY] So anyone know how i can use both the date one and the nth record parameters to work together? Also have a problem trying to parameter a location which...

Where is this subform control? I have looked through the properties windows. As for the code do you know the command to use?

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

Excellent. It works like a dream, thanks so much. Only problem i have now is to figure out how to open a form on a specific record from what the user would enter(date, ranger, site). If you have any ideas it would be greatly appreciated. Unless i could use a query and a new form.

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