Search:

Keep the old AutoUpdate field, and add a NEW FIELD... As far as Homework, you should be talking to a teacher, not posting in a forum that he'll be able to see the answer IF WE POST IT for you...

Forget that. Get them ALL, and then apply the FILTER property to your query results. Instant, as they are all in memory. Make sure not to use TOO MANY RECORDS, though.

Access will POINT to the spot, and show an example that uses # in the HELP section. Then again for the closing...

Try this:


Dim ConStr as String
ConStr = "INSERT INTO SV(MSSV,MaLop,Ho,Ten,HanhKiem,User,Status,Date) VALUES ( _
'" & ws.Range("A" & i).Value & "', _ '''IS THIS RANGE MSSV?
'" & ws.Range("B"...

Sounds like HOMEWORK to me...