Recent content by kroeger

Good advice, thanks again.

Update, Thanks BluIshDan. I have used the On Current event to decrypt the password. The password now displays as plain text and is encrypted again when the before update event triggers. I have been struggling with this all day!!!! :)

Thanks for the tip, I will look into this.

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...

hi will try that thanks

I have an unbound text box on the parent form called txtTaxRate. I have all of the subform fields bound to the SaleItems table. The field in that table called taxDue is the one I want to put the calculation in. There are also fields for qty and price. I want to do something like...

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...

Thanks I can see the logic in doing it that way. So long as I know the starting balance I can then write a query to sum all of the order item quantities to get qty sold. The reason I need to reference a stock qty though is so that the order can be fulfilled or whether additional qty needs to be...

thanks I will give it a go :)

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...

sorry I really must read the detail.

Sorry Bob, I did not mean it does not work. It works fine with your code. I was just thinking aloud on why it needs to set the check box to true to work correctly. Also I was just stating that the code works in the main form and therefore I do not need it in the other form.

Hi I have put your code into my db with the Nz function as well. The code is working!!! It will not work without the Nz function or if I leave out setting the check box to -1 afterwards. Why is it that it is only selectable if it is set to true? also please can you tell me what the cycle...

thanks I got the latest version.

Thanks for your time. I will have a play around with it and try and learn from it.