Search results

Hi Yah (find it hard to refer you as vbaInet), Tell you what??? its working....I just played around with the code and finally framed them right...Have a look at the refined code below...

That still doesn't answer the question. A subform control is a control just like a textbox is a control. Is sfrmUAEMem the name of the control or the name of the subform. These are two different things sfrmUAEMem is the name of the sub form

As I said before both these parts the true part and the false part work absolutely fine when used on their own. Only when I use them both as the True block and false block they fail. sfrmUAEMem is a subform and currPremiuminAED is a control in it. The Dsum function value gets subtracted from...

Hi I've tried pasting it but it displays #Name? I also tried the below but No success again, =IIf(IsNull([currAmtRcvd]),Null, IIf([qrypayments]![CurrencyID] <> 3,[Forms]![frmTempMain1]![currNonUAEPrem]-DSum("currAmtRcvd","qrypayments","[qrypayments]![CreditContID] = " &...

They both are numbers CreditContID is foreign key for payments table and currencyID though displays the currency type but actually stores the ID from the currencyList table. I think I've tried earlier exactly the way you've specified but with no success.

Hi vbaInet, Sorry struck again...I have to mention this. I orginally asked for help with a simpler version and with your kind help I've managed to work out on dealing with the actual thing....A quick question: Can i change the Control Source at Runtime? I've got two different criteria now and...

Thank you Very much VBAINET, You've been a great support to me. I am playing around with that function now. A quick question regarding the Dsum function, How do I decide whether to use [ ] brackets or not and also where to use the " " double quotes.

Hi Yah, Thank you for your help ...this one works fine but doesn't allow me to add any more payments to it or amend the existing payments. It almost locks the table. It prompts Recordset not updateable. I've tried changing the properties like Data Entry Thanks

Further to your message, I am not sure which record are you referring to but any ways, If you are referring to the record with CreditContID =2 then the actual premium is 50,000 and everytime they receive a payment amount (in this case the payment recieved was 200, 100 and 200. The outstanding...

Hi Again, Please look into the Control Source of the currAmtOutstand control on sfrmPayments form Many Thanks

Hi, Please find attached the updated version of the DB. Many Thanks

Oops... option 2 is missing the Sum() aggregate function. MainformTextBox - (SELECT Sum(AmountReceived) FROM TableName WHERE ID <= " & ID) In any case, the first one should have worked based on your requirements. By the way, I don't understand your spreadsheet in post #3. I don't see how you...

Hi Yah, I've been working on both these options since yesterday, but for some reason if it works it generates some random number (Very Inappropriate). Actually let me tell you one more thing, both these tables have a foreign key reference. In this case CreditContID in both the main form and...

Please look at the attached xl sheet and the formulae in it. I want this functionality in a datasheet form of MS ACCESS Many Thanks

Hello All, In the main form I've got the actual amount for example 1000 and I have a sub form in data sheet view which has two columns ROW Amount Recieved Outstanding Amount 1 100 900 2 200 700 3 300...

With reference to the above explanation I need some help regarding the little Icon where it says Edit List Items. My Query is can I have a list item which says "Add New" and when the user selects that Item a new form pops up to add a new field..?

How to use this even before opening the file ....as the password is to get into the spreadsheet and not to unprotect it...any Idea?

Does this code really works to break or recover Excel Passwords? Sub PasswordBreaker() Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer On Error Resume Next...

Hello, I had this same problem but then once went to design view n then back to form view ...it worked ...I'd ask u to give a try...Good Luck

Good Morning All, I am struck with a Modal Dialog Form.. Basically I've got a main form with a datasheet subform which is not editable which has a Primary key and a foreign key columns in it. The only way to add some data to this datasheet view form is by clickin' a cmd Button. Once I click...