Search results

thanks Mile-O-Phile just used code spot on as usal :) thanks rob :D

hi i have a table with 2 fields town and county i then have a bound form with 2 text fields on it town and county and what i am trying to do is when i enter woodford in field town it autofills london in to the county field and if i enter romford it autofills essex in to the county field thanks rob

thanks for the reply :) got it sorted now i put the following code in the after update event of the text field Me.[myfield] = StrConv(Me.[myfield], 3) thanks to all who have helped me this forum is the best on the net :D thanks rob :)

now sorted thanks for looking hi i have fout text fields on a form and what i am trying to do is this when i update a text box and then move to another text box i want the text i have enterd in to the first box to change to upper case from lower case any ideas? thanks in advance for your...

NOW SORTED THANKS FOR LOOKING :) hi ok this is what im trying to do. i have 4 fields on a form and one of them is locked or unlocked depending on user access level so i would lile a mgs box to show when someone clicks in the field(saying this field is locked) when it is locked and no msg...

ok i have now sorted it thanks anyway for looking ok this is what i want to do the following code enables or disables a command button on page open depending on the users access level Private Sub Form_Open(Cancel As Integer) Select Case User.ViewID Case 1, 2 Me.Command117.Enabled = True...

THANK YOU YOU ARE A LIFE SAVER!!!! :D That worked a treat thank you very much i had been trying to sort it out for hours :rolleyes: rob

HI THIS IS MY FIRST POST SO BE GENTLE :) OK WHEN I OPEN A FORM I HAVE THE FOLLOWING CODE IN THE ON OPEN FUNCTION Private Sub Form_Open(Cancel As Integer) On Error GoTo Err_Form_Open If User.AccessID = 1 Then Me.cmdAdmin.Enabled = True Else Me.cmdAdmin.Enabled =...