Search results

Here's another trick. You can set the Tag property (It's on the Property Sheet / Other Tab for the control) on Form controls as appropriate. Then, when the Form Opens, you could call something like the function below: LockFormControls Me.Form, True LockFormControls Me.Form, False This would...

I have to fight with some similar issues, a couple examples being where users want to print something in black & white and sometimes in color, but without having to select that each time and controlling whether the printer prints single or double sided. I'm assuming when you print a receipt...

If you're just looking to restrict editing, you can toggle a form properties easily. Me.AllowEdits = False Alternatively, you could specify "acFormReadOnly" as the DataMode when opening the Form

Since you're using a loop, I'm going to assume you're holding the file path in a variable called strFilePath and that the file actually exists (since your looping through the files in a folder) If Left$(Dir(strFileName), 4) = Format(Now(), "mmdd") Then FileSystem.FileCopy strFileName...

Unit = DLookup("[Unit]", "Article", "[Article number] ='" & Article & "' OR [EAN] ='" & Standard & "'") Since you're using strings you need to use the single quote ' character to surround the strings If it helps, if Article were "12345" and Standard were "67890", the criteria portion of the...