Recent content by iglobalusa

  1. I

    String Validations

    Bob Larson, many thanks for the code enhancement!
  2. I

    String Validations

    Bob Fitzpatrick you're a wizard!
  3. I

    String Validations

    To one text field, named stateno, with a length of 10 characters. Thanks.
  4. I

    String Validations

    What string function, or series of string functions, in a code can I use to prevent a user from : 1) entering a leading 0 in a text field for an ID Code with 10 characters e.g. 0346788692 2) allowing only to enter a leading A or H and no other alpha e.g. A346788692 3) allowing only to enter an...
  5. I

    Update loop not working

    Thanks for your suggestions. ig
  6. I

    Update loop not working

    Wayne: Thanks for your similar suggestion. Please refer to my reply to pbaldy. ig
  7. I

    Update loop not working

    Paul: What I'm trying to do, and not very efficiently, is to allow the user to modify the stateno field on the current record on a form and have the code update all the statenos on hundreds of records with the new stateno that the user just edited. I'm realizing just now that it is only...
  8. I

    Update loop not working

    Can anyone see why this code is not updating the field? Private Sub txtstateno_AfterUpdate() On Error GoTo Error_txtstateno_AfterUpdate 'look for all records with the same stateno then update the same edited field strSQL = "Select * from labdata Where stateno = '" & Me.stateno & "'"...
  9. I

    Input mask for date field not working

    Thanks, I'll try that although I may just have the user input a four digit year to simplyify things.
  10. I

    Input mask for date field not working

    Is this a system setting that can be changed? Or am I left with no choice but to modify the input mask so the user enters a four digit year? Thanks for your reply.
  11. I

    Input mask for date field not working

    Tried what you suggested but it's still ending up as 2028 instead of 1928.
  12. I

    Input mask for date field not working

    I have a form with a date field for users to input the date of birth. The data type is Date/Time and the format is Short Date. The input mask is: 99/99/00;;_ Everything is fine until a user enters any year from 1911 to 1929. So if the date of birth is 03/23/28, Access 2003 converts it to...
  13. I

    Recordset loop not working

    Thanks, David. You resolved the problem! And thanks for your advice on writing efficient code. I got rid of the "findnext stuff" since they were obviously not needed. What was I thinking! Here's the modification: Private Sub txtl_name_AfterUpdate() On Error GoTo Error_txtl_name_AfterUpdate...
  14. I

    Recordset loop not working

    I'm trying to edit fields in a recordset by looping through it using an ID number to match the record to edit. All records with a matching ID number are successfully edited except for the record prior to the last matching record. Can anyone help me resolve this problem? Private Sub...
  15. I

    You can't assign a value to this object

    You've helped me twice today! What a super guy! Thanks a bunch, iglobalusa
See more
Back
Top Bottom