Recent content by atiq
-
A
Date Input mask problem!
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... -
A
Counting certain values in a field in Select Query
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... -
A
Email Validation
can any provide me with a validation rule for an email field making sure that @ is included. any help would be appreciated. -
A
Having a clock displayed on a Form
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 -
A
Having a clock displayed on a Form
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 -
A
Multiply Parameter Queries!
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... -
A
Menu Struture!
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! -
A
Multiply Parameter Queries!
i tried that but it doesnt seem to work neither do i get any error message. -
A
Multiply Parameter Queries!
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... -
A
Report Heading Problems.
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] & " " &... -
A
Count Function in Access Query.
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... -
A
Default value for a Combo box.
What expresion! But what expression do i use? sorry im new to Access and Database! -
A
Count Function in Access Query.
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... -
A
Default value for a Combo box.
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? -
A
Count Function in Access Query.
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.