Recent content by Alan Chan

After developing a database application on Access 2010, I send to a friend to have a test run on Access Runtime. There are two problems and would appreciate if anyone can help. 1. The accdb version comes up with an error message that it cannot verify that the the program come from a Trustworthy...

After developing a database application on Access 2010, I send to a friend to have a test run on Access Runtime. There are two problems and would appreciate if anyone can help. 1. The accdb version comes up with an error message that it cannot verify that the the program come from a...

You are right that the SendKeys function is unreliable and what it does is quite unpredictable. It would be good if we can just change the KeyCode and/or the Shift status byte to inject the character we want into the current text field on focus. I am now just using the Alt key detection...

Further to my response above, I recognise that you have proposed a practical way to do what I want. Thank you. But the situation is a bit more complicated as I have over 30 TextBoxes and ComboBoxes in the Form, and use a common event handler for all these Boxes. If I can change the KeyCode...

Yes, I can also check the Shift status and the KeyCode to do something else. However, the problem is to change the KeyCode or Status to change them to other characters (which cannot be directly input from the keyboard) to appear as input in the TextBox in mixing mode with other normal keyboard...

Dear experts, To facilitate input of special graphic characters such as the degree C and plus-and-minus symbols, I would like to use Alt-1 to Alt-9 key combinations, capture these keys in a KeyDown event procedure and change the keystroke to the desired graphical character code. I am using...

Dear experts, To facilitate input of special graphic characters such as the degree C and plus-and-minus symbols, I would like to use Alt-1 to Alt-9 key combinations, capture these keys in a KeyDown event procedure and change the keystroke to the desired graphical character code. I am using...

Yes you are right, after Compact & Repair the database, it does save after copy and paste on the code. This explains why the problem went away before, could be after I performed database repair. It is strange that, before database repair: 1. I can save the changes if I do not paste any code...

I have encountered several times, and now, that after using any "cut and paste" or "copy and paste" on VBA code in the event sub, even for a few words, Access does not allow me to exit when I answer 'Yes' to save the changes. It forces me to respond "No" to exit and re-enter any changes again...

[Solved]: Text ForeColor of ComboBox fields The code to change text color is like: Private Sub CommandButton_click() ComboVendorName.ForeColor = vbWhite ComboVendorName.BackColor = vbMagenta ComboProductName.ForeColor = vbWhite ComboProductName.BackColor = vbMagenta End Sub On button click...

Hi David, Thanks for the advice. Actually the code to change text color is like: Private Sub CommandButton_click() ComboVendorName.ForeColor = vbWhite ComboVendorName.BackColor = vbMagenta ComboProductName.ForeColor = vbWhite ComboProductName.BackColor = vbMagenta End Sub On...

I have also posted this on the VBA and Modules Forum. Thanks.

I am working on a database project using Access 2010 and encounter some ComboBox text color problem and would like to seek assistance. The form has a ComboBox that displays the Supplier Name. The Combo's source control is Supplier ID in the Products table which joints the Supplier Table...

I am working on a database project using Access 2010 and encounter some ComboBox text color problem and would like to seek assistance. The form has a ComboBox that displays the Supplier Name. The Combo's source control is Supplier ID in the Products table which joints the Supplier Table...