Tip Bank

Question: I inserted a new row in a table with Identity column, and saved it by calling update function. Then I immediatly tried to modify this record and update again.

Question: I am attempting to add a picture of a form to a Word file. How can I do this? Answer: The simplest method, most often overlooked, is to run

Question: When a user wants to find help on a column that has focus, I want that user to be able to hit F1, and help to be displayed based

Question: Given: Dim oX as Object Set oX = optChoice1 If TypeOf oX is CheckBox Then… If optChoice1 is a CheckBox the If… will be true unless optChoice1 is an

Question: My application is started by clicking an icon with a TARGET of “\itgcssd1sgrsv3.0132sgrs.exe” and a START IN directory of “c:winnt”. Is there any way to determine the TARGET location

Question: How do you get the position of the mouse pointer (x- and y-cordinates) in a script? Answer: Use the PointerX() and PointerY() functions.

Question: We would like to find out if a directory that was typed exists. Furthermore, we prefer not to use a list box control or getFileOpenName. Answer: To do this

Question: I have tried using the “shell” statement in VBA to load and run an existing .exe file. The file seems to load but does not run. (I have used

Question: Using PFC, when I select a row, it turns dark blue, often obscuring the data. Is there a way to change the color to something lighter? Answer: The way