Search results

  1. 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...
  2. 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...
  3. 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.
  4. 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
  5. 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!
  6. 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...
  7. 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] & " " &...
  8. 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?
  9. 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.
  10. A

    Count Function in Access Report

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

    Copying and using the same navigation (command) buttons!

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

    no warning messge when runing the delete, append or update query!

    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!
  13. A

    Deleting 5 year old records!

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

    Help needed on Up-date Query!

    i am trying to update a field within a table. But i dont want to update the whole of the data within the field just one part of it. The field is the Tutor Group for students in the format 7B, 7D, 7F, 7H, 7M, 7S, 8B, 8D, 8F,... etc where the number represents the year group! i want to use an...
Back
Top Bottom