Recent content by yhchen

Thank you SOS. You're my hero!

Thank you SOS I followed your instruction... and yes the new record can now be added but it does not set ID field to be required when Xource=1... would you be able to upload the file you successfully amended?

thank you, sos very much appreciated!!

the file is too big to upload to here.... I uploaded to my skydrive... http://cid-5edd539792b3921e.skydrive.live.com/self.aspx/Public/db1.mdb

When the code is removed and the new record is added, in the table vew it did return a 1 when the code is added back... it pops up the same message again (would not appear the error message at all)

2nd try!! Thank you SOS

Hello herewith the screen capture... I am sure this will clear things out a little bit... Thank you SOS...

Thank you SOS..I have done so but still not working... :( It seems that this code is stopping the "SandN" bottom from working. If I removed the IF code, then the bottom works fine. Once I put the IF code back, it pops up with the same warning message.... the Error"" line was an .... errrr...

Hello.... I encountered some problem.... The form has the following code: Private Sub Form_BeforeUpdate() If Me.Source = 1 And Len(Me.StudentID & "") = Null Then Cancel = True MsgBox "You need to fill in the Student ID", vbExclamation, "Entry" Error "" End If End Sub Private Sub...

Thank you SOS (and missinglinq) You guys are the best!!

I have a form that I use to track the imcoming phone calls I would like to set the field of a textbox "Student ID" as a required field when the value of option group is 1 (when the value of option group is 2 then "Student ID" is not a required field) I am struggling how to write the...

Thank you very much...you made my day!! I really appreciate your help!

worked!!!! Thanks a lot!!

WhenUpdated is the name of the field... any idea?? :(

only just realised it didn't work for both forms!!! It should stamp the date if it is not a new record....:(