Search results

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.

The main form is called frmMaintainContacts, the sub-form control for the sub form with the checkboxes is frmContactType and the actual checkbox controls themselves are called chkAssociate, chkBusiness and chkFriend. good luck with the football. Arsenal have dropped off a bit lately!!! I have...

hi Bob, there are definitely three check boxes on that sub form, the view was obscuring it. also the controls are as follows: two text boxes on the main form three check boxes on the first sub form (sub-form named frmContactType) three text boxes on the second sub form (sub-form named...

Hi Bob, I have entered your code and once I select the next record after not selecting a check box the message box opens as expected. Straight after I dismiss the message another message box opens saying "You can't go to the specified record". When I close this and try to select the check box it...

sorry Bob, it keeps telling me that I have objects that are not compatible with the earlier format. I have paired it down to just three tables and the main form and sub form but it still will not let me save in the older format. I have no macros either.

Well I don't see how I ignored the advice. You cannot break it down any more than trying one if statement surely? I have googled, I have searched these forums, I have been trying different things all day today and the last few days, as well as referring to books.