Search results

  1. K

    User Account Form - Encrypted password

    Hi, I am using an RC4 vba function to encrypt the password when a user account is setup in the front end of my split database. The password is stored in the backend encrypted. It is encrypted in the before update event of the form by calling a function against the bound password field. My...
  2. K

    Use parent form value in sub-form calculation

    Hi, I have a parent form where I enter a value for tax rate. I need to use this value in the tax calculation in the subform fields i.e. subform.taxdue = subform.qty * subform.price * parent.taxrate. I can get the value into the field. But I do not think I am putting it in the correct event. The...
  3. K

    Best form event to update stock

    Hi, I would appreciate some advice on the following: I have an order form with an order details sub form. Both are bound to their respective tables and function correctly, with the OrderID being inserted automatically into the order details table. However I am using VBA to update and check...
  4. K

    Unable to select control after event cancelled

    Hi, I have validation on a checkbox on a sub form and after the validation fails and the cancel = true is executed in the before update event, I am unable to select the checkbox on the form. Access will not allow the selection. Any ideas would be appreciated. Hope this is the right forum. my...
  5. K

    How to validate that at least one checkbox is selected

    Hi, I am trying to validate that the user selects at least one checkbox out of three on the form in Access 2010. They can select one, two or even all three if they wish, but at least one must be checked. I am using the following code attached to the click event of a command button. It was fine...
  6. K

    Hi everyone

    Hi, I have just joined. I am fairly new to Access and have only been programming since last summer. Mainly VB.Net, HTML/CSS/PHP and some C++.
Back
Top Bottom