Search results

I am trying to find out how to get a date range search to return all records here is the code Between [Forms]![Search]![startDate] And [Forms]![Search]![endDate]

Ok I got it to work Thanks for your help

ok i am looking to get a uniform look to first name and last name fields it is for 2 fields and i have been reading the other posts in regards to it but am getting a little confused as to where the coding goes. I have tried the code in expression builder and its not working and not sure if i...

Ok now would I be placing that in the Events with On Lost Focus? :confused: And if so is that under expression builder? Sorry I just have some basic knowledge of Access and looking to learn more. :)

Ok I am still learning some of the features of Access but where would I place this if I wanted to do Proper Case on a Form for controls called txtFName & txtLName? I understand that I need to change yoursting. StrConv([yourstring], vbProperCase)

Thanks for your help that last one worked great

then after I hit ok it then highlights the Private Sub Form_Current

Ok the .Locked is highlighted again with a compile error "method or data member not found"

Ok Sorry I should have clarified that the control names are those listed above. I am not super familiar with VB and this may be a silly question but would I still place the With Me code inside the Private Sub Form_Current?

@Bob those are the names of the fields that I am trying to lock out

Ok when i try coping that code I am still getting the error message. Am I missing something?

I am looking for a way to lock specific fields after data has been entered so that they can't accidently be changed if they are searching through the records is there a way to do this for Access 2007? I have found another another thread but the ways listed did not work: If Not...