Recent content by eclipse33
-
E
Display field from child table
I hv a relationship as follows: Person 1 ------- N Assignment Person (PersonID, lastName, firstName...) Assignment (AssignmentID, PersonID, AssignmentDate, Score) I would like to show the Score of the latest assignment in the Person Form... -
E
Import from Excel error
Actually I'm importing the excel into an EXISTING table, which the data type of the columns have been defined. But when I import the data from excel, access complaint that some records could not be imported because of of the data type mismatch or data length too long. But it didn't suggest... -
E
Import from Excel error
Hi All I'm trying import an excel spreadsheet into an exisiting table. But there are some conversion errors in some records. But there is no conversion error table or log for me to trace. Anyone knows how can I find the records with error in order to fix them? Thanks in advance!