Search results

  1. C

    Save button

    Hi there thanks for that. However i am having problems with checking more than one field using the add new button on_click: If IsNull(Me.Actual_Claim_Date) Then MsgBox ("Please enter in claim date") End If If IsNull(Me.Actual_Claim_Status) Then MsgBox ("Please enter in claim status") End If If...
  2. C

    Save button

    hi, i am trying to program the save button where On_click if a certain field is left blank then for a message to appear for them to not progress forward until the field is complete. any ideas??
  3. C

    create a loop

    Hi DCrake that is correct. Thanks
  4. C

    create a loop

    hi its not just 5 theres 20 all togeather. the values that are in the fields come from the table authorities. how would you write this in code "straight forward match not match would suffice." thanks
  5. C

    create a loop

    Hi NigelShaw yes thats right if one of the authorities are displayed in another field then show a message. if not allow it to be entered in. so for example Authority 1: x Authority 2: y Authority 3 z Authority 4: p Authority:5 p Message appears and doesnt allow the user to enter in p. So...
  6. C

    create a loop

    I dont understand that?? What i mean is the code that i have written works fine but instead of entering in row1 = Form_Authorities.Authority_1 row2 = Form_Authorities.Authority_2 row3 = Form_Authorities.Authority_3 row4 = Form_Authorities.Authority_4 isnt there a loop i can do where it goes...
  7. C

    create a loop

    hi guys im trying to create a loop where it goes through the authority fields without entering in each field. If it is the same then it should come up with a message. At the moment it works as the following: Dim row1 As String Dim row2 As String Dim row3 As String Dim row4 As String row1 =...
  8. C

    open a report based on a field

    hi guys i am trying to open a report based on a certain field. So i what i am trying to do is when you press the open form button it automatically looks at the certain field the project reference field and opens up the report for that project reference. any ideas how to do this??
  9. C

    Prevent data being entered in twice

    Hi Neileg thanks for that, how do i go about adding a compound index to the project ID and Authority ID??
  10. C

    Prevent data being entered in twice

    can i not enter in any visual basic code in the authority field?? something like this: Dim row As String row = form_Local_Authorities.Local_Authority_Name.Value DoCmd.GoToRecord , , acNewRec If form_Local_Authorities.Local_Authority_Name.Value = row Then messagebox.show ("Authority allready...
  11. C

    Prevent data being entered in twice

    Ok, right what i am trying to find the solution for is: For every project there can be one or more authority involved with that project. i have created a project form which contains a subform with inputting the authorities in from a drop down list. I am trying to find a way where once the user...
  12. C

    Prevent data being entered in twice

    Ok, right basically what i am trying to find the solution for is: For every project there can be one or more authority involved with that project. i have created a project form which contains a subform with inputting the authorities in from a drop down list. I am trying to find a way where once...
  13. C

    Prevent data being entered in twice

    Right guys scrap that idea it seems difficult to do. What i have done is delete the authority table and created a new one with a tick box next to them. I have created a form on this table and have added it to the project form. Now when i add with a relationship to the project ID none of the...
  14. C

    Prevent data being entered in twice

    the different authorities do have unique keys the primary key but it still lets is select the same authority. Thanks
  15. C

    Prevent data being entered in twice

    In my database i have a authorities table. Now i have linked that to a form called projects and what i am trying to do is if a user for example chooses an authority from a dropdown list box, and wants to choose another authority aswell that may be involved in that particular project how can i...
  16. C

    Prevent data being entered in twice

    Hi, i am trying to find a method where if a authortiy has been chosen from a lookup box and users try to entert it in again in the same form a message will come up saying that "the authortiy has allready been selected". thanks
  17. C

    code

    Where is the before insert section?? i Cant seem to find it. thanks
  18. C

    code

    Dim newrec As Integer DoCmd.GoToRecord , , acLast newrec = Form_ChangeControl.Number.Value DoCmd.GoToRecord , , acLast Form_ChangeControl.Number.Value = newrec + 1 Exit_Command29_Click: trying to have a field in a form to update the number by 1 in access in the button next...
  19. C

    Mandatory fields

    i have changed the required field to yes but you can still continue. I am entering data in form view but im not too sure on where to go to put in the alternative formula??
  20. C

    Mandatory fields

    hi, i am trying to create a rule where is say staff fill in a new members form and forget to put in the name and leave it blank a meassage will appear stating that it needs to be filled in to progress. is there a validation rule for this in Access??
Back
Top Bottom