Search results

  1. E

    show record that are Close to now date

    is there a way to show only the record that are close to now date for now i want to get around the "max function" i have a query that build from 4 queries one field called "caredate" i already used "max" in one query but im getting All the results (its ok) now i need to show only the record...
  2. E

    On Error Statement

    tnx all that one work Private Sub StudentID_AfterUpdate() If DCount("StudentID", "Studentsregister", "[StudentID] = '" & Me.StudentID & "'") > 0 Then Me.StudentID = Me.StudentID & "dup" End If End Sub The_Doc_Man tnx for the record Will be dealt with within a week
  3. E

    On Error Statement

    its shows syntax error
  4. E

    On Error Statement

    Private Sub StudentID_AfterUpdate() If DCount("StudentID", "Studentsregister", "=[StudentID]" & Me.StudentID > 0) Then Me.StudentID = Me.StudentID & "dup" End If End Sub pls help instead of add the "dup" for the duplicate "123456789dup" it insert the "dup" to every value i insert to the form field
  5. E

    On Error Statement

    I tried a different method I entered this code in the form field Private Sub StudentID_AfterUpdate() If DCount("StudentID", "Studentsregister", "=[StudentID]" & Me.StudentID) > 0 Then Me.StudentID = Me.StudentID & "dup" End If End Sub so if the student id is already there it will add the...
  6. E

    On Error Statement

    I'll try The_Doc_Man code And update later
  7. E

    On Error Statement

    I am another alternative to high school With ease of study and special scholarships The bylaw states that every student who comes even 10 times must submit an interview form(can't fix it)
  8. E

    On Error Statement

    tnx It is an automatic registration system for students. A student comes and presses a button and the system takes a picture of him. After that, a form opens for him and he enters his details. At the end, he presses a confirm button and its prints an interview form with his picture Now I have a...
  9. E

    On Error Statement

    i have a field call "studentid" with no duplicates allowed im using (DAO) "with rst" "addnew" now it could be that the "studentid" is already in the system and when the code well run it well give run time error so i need to put error handler On Error GoTo ErrorHandler if "studentid" excit move...
  10. E

    editable query without primary key

    I see you have opened a discussion about me So let me answer you First of all, the example with the Doctor is not nice because I have disability and know doctors closely Let's get to the point A person asks a question. There are those who firstly answer you are wrong and your approach is...
  11. E

    editable query without primary key

    ok solve it i add FK to the 2 tables "students" & stundentsnotes to the studentid field in the students table it's a unique index no duplicates and in the studentsnotes its index with duplicates from there i did a query with a join for "studentid" and now i can edit the data on every field...
  12. E

    editable query without primary key

    primary key we'll always be a unique index without duplicates and what do you do if you need index with duplicates you lost the PK
  13. E

    editable query without primary key

    yes im disappointed look at my Q' title editable query without primary key first he understood me then he took st to is way
  14. E

    editable query without primary key

    You have not indexed the JOIN fields correctly: These fields do not consist of any unique index or primary key. http://allenbrowne.com/ser-61.html
  15. E

    editable query without primary key

    https://access-programmers.co.uk/forums/attachment.php?attachmentid=78344&stc=1&d=1578452403 now if someone can fix frmStudentNotes when you press the plus data is fill up
  16. E

    editable query without primary key

    tnx like i explained students table don't have PK on student id because i need duplicate values so without PK on one of the studentid it will be read only
  17. E

    editable query without primary key

    is not an update query its a query build from 2 tables that when you open it its read only its an access rule if you don't have PK on the same fields of the tables
  18. E

    editable query without primary key

    that was my Q' how can i edit the field what was your suggestion? sorry for what im going to say but you get a Q' and you look on it as your on db and what you would do perfect if that was the scenario but you forgetting that is a different db not as you aspectet
  19. E

    editable query without primary key

    take is first db and try to edit the notes field
  20. E

    editable query without primary key

    i want to edit the notes field its read only query:banghead: what you gave me i already have
Back
Top Bottom