Search results

Hi pbaldy...many thanks for your help the code on the subform is now Private Sub Form_Current() If Forms!VoucherMainAdd!Locked = -1 Then Me.AllowEdits = False Me.AllowAdditions = False Me.AllowDeletions = False Else Me.AllowEdits = True Me.AllowAdditions = True...

Hi trying to lock records on a form and subform after a checkbox has been ticked, have used the code below from a previous post. Private Sub Form_Current() If Locked = -1 Then Me.AllowEdits = False Me.AllowAdditions = False Me.AllowDeletions = False Else Me.AllowEdits = True...

Hi Apologies for posting on an older thread.. I am using this code to (not very successfully) show/hide fields. By selecting a value in a combo box cboAcctID fields txtAcctDR and txtAcctCR are updated with a value, or not depending on the whether there is a value to update with. If after the...

thanks for this ypma,,,,will keep you posted on my progress and thanks again for your help I have been trying to work out a way to do this do this for a month now! :) Fi

Hi...I took the first line of code out, then added a new line and the fields updated as expected but when I deleted all but the first row in the table then added a new unit price on the next line on the form, then added the qtr date, the only field that calculated was Unit Move, is there a...

Hi ypma,,,thank you for taking the time to do this, although not clear on the spreadsheet the unit price is manually updated each quarter end also, could your update code accommodate this also? thanks Fi

I was referencing the incorrect ID field, there is now data in the NewUnits field (not the correct data...) but I'm working on that, thanks again for your help much appreciated ...Fi

Hi CJ I have the main form which contains Policy data and the subform which contains the asset valuation data for the policy, the current unit calculation is previous unit calculation less units deducted for charges, as in the excel spreadsheet, below is the query behind the subform at the...

Hi CJ,,,many thanks for your reply, working on this now...Fi

Been looking through various posts and feel sure this can be done, I have partially done it using PrevRecVal module I found on the web. I created what I need to do in Access in Excel first, the problem doing this in Access (for me) is I need to refer to the results in the previous record...

Hi I have tried to better explain what I am trying to do on the attached word doc as I keep getting error messages with the calculations I am trying and am going round in circles, there is a circular reference which I cant work out, I am sure there is a way to do this and if anyone can help me...

Running sum brougtht forward total Hi...I am in the process of building a life assurance database that has unit linked products and am having trouble calculating the latest unit price for a transaction, i have attached a spreadsheet to show how it should work, if anyone has done this before and...

crikey...just read this certainly never meant to give a negative reputation...really sorry :) Fi

Hi ave thanks for your advice ...I had spoken to soon as statements with pre VDate transactions arent reporting correctly...so I am taking your advice and working thru what the query is doing step by step...will post back with progress,, thanks again Fi

thanks Dave for the advice, as I had spoken to soon, it isnt working correctly for those statements that have transactions pre VDate, so taking your advice and breaking the query down to work out where it is failing...cheers Fi

Hi Dave Cant understand why this should have stopped the report working after 27.02.10 ?? The first WHERE selects transactions between the dates to report on the statement, the second narrows it down to only report on those where FDate is greater then VDate Then once the transactions build...

Hi Dave Picking up on your point about the WHERE clause I have changed the both to read WHERE (((VouchersMain.VDate) Between [forms]![frmAccountLedger]![FDate] And [Forms]![FrmAccountLedger]![TDate]) Which although not working correctly yet it is getting closer to the correct data on the...

Hi vbaInet interesting article...if you hear anything further and if there is a possibility that it has somehow happened in access please let me now....cheers Fi

thanks Dave will try that and post back :)

Hi Hopefully this is legible SELECT VouchersMain.VNum, VouchersMain.VDate, tblAccTranType.Account,tblAccTranType.CurrentAcct,VoucherDetail.txtNarration,IIf([CurrentAcct]="Debit",[TransactionAmount],0) AS Debit, IIf([CurrentAcct]="Credit",[TransactionAmount],0) AS Credit, [Credit]-[Debit] AS...