Search results

I have used 00/00/00;_ as an input mask for the date. the format of the date is Short Date. The problem that i am facing is when i type the invalid date 29/02/07 to test whether it rejects it! it accepts the date and automatically changes the date to 07/02/2029 which is wrong. can someone help...

I am trying to count the total postive and negative behaviour incident. the name of the field is Category which is a combo box and has the values Minor, Major and Postive (these are the behaviour types. i want the query to count the total number of Postive and negative (this is Minor and...

can any provide me with a validation rule for an email field making sure that @ is included. any help would be appreciated.

Thanks for this examples. i wanted to use both digital and analoge. but the analoge clock zip file that you send doesnt open! oce again thanks for your help1

i am trying to create a clock with the date that i could display on a form? can someone help me design a basic one? any help would be appreciated

i tried the following SQL code as i instructed: SELECT tblIncident.DateOfIncident, tblIncident.Period, tblIncident.Location, tblIncident.DescriptionOfIncident, tblIncident.DateOfDetention, tblIncident.TimeOfDetention, tblAction.Decription, tblBehaviourType.BehaviourType, tblStaff.StaffSurname...

I am about to create the menu (navigation) structure for my system but wanted it to be fancy. Anyone got any suggestions or GOOD websites that have different menu types. any help/suggestion would be appreciate!

i tried that but it doesnt seem to work neither do i get any error message.

i have a Query where i have Criteria for two fields as the following: Field :Date of Incident Crirteria: [Forms]![frmSearchStudent&Date]![cboStartDate] And [Forms]![frmSearchStudent&Date]![cboEndDate] Field: StudentSurname Criteria: [Forms]![frmSearchStudent&Date]![Combo0] Occasionally...

i am wanting to the following for the report title: Incidents summary Report by [a combo box field location on a form] Behaviourial Category This is the expression that i used but didnt work: ="Incidents summary Report by" & " " & [[Forms]![frmSearchByBehaviourCategory]![Combo0] & " " &...

The fields are from three different tables which are as follows: tblIncident DateOfIncident, Period, Location, DateOfDetention, TimeOfDetention, DescriptionOfIncident, tblStaff StaffSurname tblStudent StudentSurname, StudentForename tblAction Decription tblBehaviourType BehaviourType But...

What expresion! But what expression do i use? sorry im new to Access and Database!

Error message The error message is the following: You tried to excute a query that does not include the specified expression ‘IncidentID’ as part of an aggregate function. The following fields are used: DateOfIncident, Period, Location, DateOfDetention, TimeOfDetention, DescriptionOfIncident...

can anyone tell me how i can have the default value of the combo box field as the first value in the combo box drop down list?

i'm trying to count the total number of records found for this query. i used the following expression (code) in the QED field row Total Incidents: Count([IncidentID]) which, result in an error message. Can sum1 help me solve this problem. any help would be highly appreciated.

Additionaly information. the =Count([StudentSurname]) works fine when i put it in the Detail section of the report in design view but displays #Error if i put the same box in Page Header or Footer. any ideas how i can get this count function working from the Page Header or Footer while having...

I have got serveral forms where i want to use the same command buttons for each form to navigate through records. i was wondering if there is a way of achieving this without having to create all of the same command buttons again each time for a different form. i tried copy and paste which copied...

Thanks mate! Thanks for that rainman89! really do appreciate this.

why isn't my Access giving me warning before runing the delete, append or update query because usually it warns you that you are about to append, update or delete the following number of records. It must be the settings, can someone help!

i know this must be a piece of cake but i'm new to Access! Anyway, am using a delete query and want an expression that i can use in the criteria to allow me to detect (and delete) records that are 5 years old. i used Date() - 1825 but was wondering if there was any other way or function that...