Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mikepf

  1. mikepf

    Compact & Repair Error "No Read Permissions..."

    It almost sounds like someone else has the db open (the icon will have a lock on it).
  2. mikepf

    picture size

    It appears that the size of the graphic is doing it. Look at Google but I believe that a GIF graphic has less colors therefore it should be a smaller size but I could be wrong. At anyrate use a smaller graphic to reduce the size of the file. Good luck!
  3. mikepf

    picture size

    Try using a smaller black/white gif file. Color takes a lot bigger size.
  4. mikepf

    Writing an Expression

    Yes, the update query would be one way to do this but I wanted to try using an expression on the SSN field of the form. It appears nobody uses this kind of update because nobody has told me how to do it. I initially thought using Validation Rules was where the expression is used but am now...
  5. mikepf

    Writing an Expression

    Yes, in a text box and update a table.
  6. mikepf

    Writing an Expression

    Well, if you put =IIf([SSN]=50,99,[SSN]) in Control Source for SSN, then you get a green edge on the SSN field (in design) and #ERROR on the SSN field after opening up the form. Any thoughts?
  7. mikepf

    Writing an Expression

    Well, SSN in this case is not social security number. I was trying to use the Expression Builder for the field to change 50 to 99. Can you tell me the correct code to enter in Expression Builder to do this?
  8. mikepf

    Writing an Expression

    So how do I edit the SSN field to change all 50 to 99? I almost feel that this edit should be put someplace else. If so where?
  9. mikepf

    Writing an Expression

    But I put the expression in the validation rule. Where should the expression be placed?
  10. mikepf

    Writing an Expression

    In the expression IIF([SSN]=50,99,[SSN]) when I enter 60, all works well. But if I enter 50, I get "The value entered doesn't meet the validation rule for the field or control". BTW SSN is defined iin a tabale as Number (long intiger). Any thoughts?
  11. mikepf

    Compress & Repair problem

    Copy and rename to the drive = cloned
  12. mikepf

    Copy backed up Access database to production version

    Is it safe to restore an entire backed up version of an Access database to the production version? Or is the best way to copy in only those objects from the backed up version to production? If I delete the production version first, then I would have to setup short cuts again for all users...
  13. mikepf

    Compress & Repair problem

    What is the cause and cure for this condition? I get a window that says "Could not find field 'Description'". The related error code is 3799. I had previously cloned a database and made changes to it. Somehow a table must have gotten corrupted. The error condition went away only when I...
  14. mikepf

    Validate a field

    Upon EXIT of a FORM, how do you validate a field NOT to be space? Thanks!
  15. mikepf

    COMPRESS & REPAIR problem

    I seem to sense that a "trashed" table can cause this problem but there may be other issues too.
See more

Part and Inventory Search

Back
Top