Search results

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

why doesn't this code work? I have been trying to figure this out for whole day but not very successfully... so I am hoping someone here will be able to spot the error... I googled this datestamp method: It worked once (somehow) and then just doesn't work anymore.... any idea?

Thanks Steve....it's still not working though... :( no debug message nor error message, just nothing happened.... You mentioned earlier that the [Update] should be a Boolean field and that it is linked to [lastupdate] and I am not quite sure about what you meant about that... as you can see...

Thank you Steve, but it doesn't work... Attached the design view screenshot: I put down: Private Sub Update_After() oldlastupdate = LastUpdate IIF(Update,date(),oldlastupdate) End SubNothing happened..... only that in the code view, the line of IIF appears as red... any idea?? another...

Hello.... Hope someone here knows about the answer about this: When user attempted to update a record in the form, I would like the field "lastupdate" to be datestamped if the field Confirm Update (yes/no) is ticked... I tried to use IIf([Update],Date(),"") but it's not working... Hopefully...

Hi thanks a lot The below code works... Private Sub Form_Open(Cancel As Integer) DoCmd.GoToRecord , , acNewRec End Sub