Search results

Thank you, I understood! Sorry for being raw in writing codes! I'm not at all an expert user! :p thank you again! sara.

Dear Rabbie, I'm not sure I understand what you mean... If I do as follows? Function sara_shift_open() Dim db As Database Dim prop As Property Dim PropBool As Boolean Const PropNotFound = 3270 Set db = CurrentDb() PropBool = False On Error GoTo CatturaErrore db.Properties("AllowByPassKey")...

Dear RuralGuy, thank you for your comment! I know it's strange, I will search the way to check the existence of a file without opening it! I wrote this code in 5 minutes, so I used the few command I had in mind! :p The condition exit... yes, for sure you're right! I will change it! Dear Poppa...

hi! I'd like to use the AllowByPassKey to disable shift open key, because I'd like to hide tables and modules to users of my db. However, since my db is a database for dataentry, I need to be able to view and access to tables and modules, after users have entered data! So I need something that...