Recent content by maperou

Thank you CT2013. Unfortunately yes they do have to see the field that is date field (start date). Would this code make the field invisible?

Thank you CJ London. Apologies I'm not an expert in VBA. I can understand the logic but not write it, so I'm really a diaper VBA user. Appreciate it if you could please explain what this code is trying to achieve and what nz means. Just a little history here. I took over a database that has...

Hi hmongie. Did you ever figure out how to do this? I have the same question and would appreciate it if you can let me know what solution you found for locking a field after a user has entered information.

Is it possible to lock a field in a form after the user has populated the field? So for example, I have two date fields and I want them to be locked after the user has entered values on those fields. I want to avoid the user to come back in the future and change those fields. However I would...

Hi Paul (pbaldy) I have tried using the code you sent me for validating data before saving it but I can't make it work. I keep getting errors. This is what I wrote in VBA: Private Sub Text111_BeforeUpdate() If Len(Me.Text111 & vbNullString) = 0 Then MsgBox "You need to add the Deal Overview...

Paul (pbaldy) may I ask you what's the code to temporarily lock a field until the user enters data in that field. So if the user wants to skip a field the system returns a message that he can't continue unless he enters the information on the field he's trying to skip. Thanks!

pbaldy this is great! Thank you so much! The code worked!

Thank you for responding pbaldy. I tried adding to the first combo box in the after update expression builder the code you sent me but it didn't work. When I go to enter the date in the first combo box I get an acess error: "The expression After Update you entered as the event property setting...

Hi everybody, I have a form that has two date combo boxes. I would like to have one of the combo boxes populate by itself with the same value the user enters in the other combo box. How do I do this? Appreciate your help!

Hi everyone, I'm new to any kind of forum and I thought I would like to join because this is a great way of learning from others as well as sharing valuable experiences. I work in Corporate America where I do a lot of data analysis. I created an access database 8 years ago and since then I...