Search results

im sorry about this but thats not what i want example StudentCuttingTable StudentID CuttingID DateBorrowed 7790 MAT001 01/01/2006 7790 MAT002 01/01/2006 7762 MAT003 05/01/2006 7762 ENG001 06/01/2006 7790 ENG002 07/01/2006 ive made a report to...

the problem with that is that i dont only want 7759 i want it for every other student aswell i tried this..a cutting is an article so this i assume counts the number of cuttings in the studentcuttingtable when the studentid in the studentcuttingtable = the studentid in the 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...

im going to be entering the number bit...ive decided to do the calculating bit in the form and then add the letters bit infront of the number in the table.

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

ok i have two tables MembersAndDaughter and Siblings and a form for each... i have a button on each sibling record saying "move to MembersAndDaughter" i have the code that will copy the details to the MembersAndDaughters table but i dont want to copy over the SiblingID because it is the same...

hey thanks alot for that...worked like a charm now how would i use the variable in the code below (variable renamed to NewMemID) i think the code is assuming the variable, NewMemID, as a field but doesnt find it so it asks me to input some data. Private Sub Command16_Click() Dim NewMemID As...

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(...

anyway i think ive found a way but am having some trouble with the coding.. Private Sub Command16_Click() INSERT INTO MembersAndDaughters (MemberName, MemberFatherName, MemberGrandFatherName, MemberSurname) VALUES SiblingName, SiblingFatherName, SiblingGrandFatherName, SiblingSurname End Sub i...

thanks for your reply but there was a reason why i cant have them all in one table because the member table contains other things which i dont need to mention right now. i dont want to merge the two tables...

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