Search results

  1. K

    count in report

    i have made a report from a criteria query. the report shows records since a date specified earlier. a table holds a collection of articles and another table with studentID and ArticleID and BorrowedDate. i have got the report thats shows the articles borrowed since a specified date. i have a...
  2. K

    add value to cell according to another cell in same record

    i have a table of articles. A field in the table is ArticleSubject the ArticleID is made up of 3 letters then 3 numbers. i want the 3 letters to be something according to the subject for example i want the first 3 letters of the ArticleID to be MAT*** (* is a number) if the subject is Maths or...
  3. K

    find highest number less than 1000

    hi im trying to look for code that will look in the MemberID field in MembersAndDaughter table and calculate the highest number less than 1000. i think i need to use the DMAX function and tried this but didnt work Private Sub Test_Click() Dim memid As Integer memid = DMax(...
  4. K

    Move a record to another table

    ok ive read some responses to people having trouble or need to know how to move a record from one table to another... i have two tables. One with member and another with thier siblings. i have two forms. one with the member details which contain a command box to open the other form for their...
Back
Top Bottom