KB-32674: Compacting an Access database.
Question: Why do Access files not reduce their sizes after its records are deleted? Is there another way to make them release this space? Solution: This is Access’ normal behavior.…
Question: Why do Access files not reduce their sizes after its records are deleted? Is there another way to make them release this space? Solution: This is Access’ normal behavior.…
Question: With two windowed screens, how can I click on a button and open the screen in the frame where the button is? Solution: In the button’s script, use the…
Question: How can I extract a certain amount of characters from a script’s left or right? Solution: To do so, use Left and Right functions to extract characters from the…
Question: How can I retrieve, via scripts, both user name and user group to which this user belongs? Solution: Username is retrieved by Viewer‘s User property. Example: dim user user…
How can a specific alarm be acknowledged inside E3Alarm via scripts? Alarm acknowledgement via scripts has been a feature of E3 since its version 3.2. To do so, three new…
Question: How can I check, at runtime, whether an object’s Value property is already linked? Solution: To do so, use a script that is similar to the one in the…
Question: How can I synchronize the PLC’s date/time with the computer’s date/time (BIOS)? Solution: To do so, use this script: dim oShellSet oShell = CreateObject(“WSCript.shell”)oShell.run “cmd /K DATE “& Application.GetObject(“Dados.Data”).Value,0…
Question: How can I open a pop-up window from another pop-up window, closing the first window in the process? Solution: To close the first pop-up window, follow these procedures: Create…
Question: How can I retrieve the number of characters in a string? Solution: To do so, use VBScript’s Len function. Sample script to be executed at a button’s Click event:…
Question: How can I convert an integer into a string? Solution: To do so, use VBSscript’s CStr command. For example: CStr(15).