Search results

Hi I am using the code below to produce individual valuation reports for each policy, rptVALBATCH. To limit the number of reports produced in one go, there is a parameter query hard coded on the policy number field in the report query of Policy Number, Between "CL10000074" And "CL10000354"...

Hi This may help someone looking to open a report in PDF format and save to file, with your own choice of file name. txtPDFRef is a field that contains the filename you want, in my example it is =Format(Date(),"yyyymmdd") & " - " & "Statement " & [txtClient] Private Sub cmdPDFInv_Click()...

Hi...I have tblClient table and a tblValuationData, the tables are linked by Policy number. Each client has several lines of valuation data, categorised by either cash accounts or fund holdings. I have a report with record source tblClient, this report has 2 sub reports with recordsource tble...

Hi,,,been trying in vain to use the Rate function that appears to be a built in function and also as below Private Sub CalculateAPR() txtAPR = Rate(txtNumberOfPayments, txtPaymentAmount, txtLoanAmount, 0, 0) End Sub Has anyone used the function that could help with what I'm doing...

Hi...I have set up a navigation form which contains 5 unbound subforms that are made visible or not visible thru the on click event of command buttons on the main form, the subforms have a command button with an embedded macro that searches for a record based on what has been keyed to an unbound...

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

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

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

Hi I have a report based on a union query, the date parameters for the report come from a form that opens with command button 'Print Report'. The dates are unbound and have default values of Date() and Date()-90 The report was working fine till this morning ie 01 March 2010, I changed the system...

Hi I had hoped to be able to choose from a combo on a continuous subform and by the selection make certain controls visible or invisible, it does do this however the selection in each new line on the form changes what is visible and invisible on all previous lines, is it possble to, by the...

Hi, not sure the best to achieve this but think perhaps a Union query ?? I have an application table which holds the client name, intermediary name, adviser name and life insured name, the primary key on this table is ClientAppID Client Name and Insured Name are stored in tblClientMain and...

Hi..I have a report with 6 sub reports, each subreport contains a tab control with 200 individual calculations...probably not the best way to do this I am sure..each subreport calculates correctly and when I bring them together on the main report I can see all the calculations on screen...

Hi I have this code from the following link http://www.access-programmers.co.uk/forums/showthread.php?&p=694123#post6941 which works really well , I would however like if possible to be able to open frmClientMain after the table has been updated with the new client at the new clients record so I...

Hi... I am working on a db which needs to illustrate the growth rate of an assurance product over 3 growth rates and for 10 years, introducers fees (it also uses IIf statements to determine whether the introducer fee is an amount of percent) and management charges are calculated on the value of...

Hi...I have been using and modified slightly a sample accounting DB posted by Khawar which has been a great help, I have changed an SQL union query which brought together a client statement with a balance brought forward depending on date criteria selected ...this however is now not working...

Hi... I am trying to build a report for a life assurance illustration spanning 10 years with many variables building up the monthly totals and am only half way thru adding all the fields to the report and have got an error stating too many fields (over 255) by the end of the report I would need...

Hi need a bit of urgent help, I posted a sample database while looking for some help, which I need to remove, coudl anyone please help me to do this the db contains company data...many thanks Fi

Hello again :) I have a report based on a query with a calculated date field, is it possible to use the Between And criteria on this field (when I try it asks for parameters FDOM, perpass, perpasm, periodlu) on the report NPD is set to short date format NPD: IIf([FDOW]<Date() And...

Hi, looking for advise on which direction to take with this, if possible I have a form with policy start date from which the customer chooses the period to receive payments - Quarterly, Monthly, Half Yearly, Yearly I would like to select the pmt period and and have the date calculation done...

Hi...cant get my head round this at all :( ...I have a subform where info about the progress of debt collection on a clients fees is recorded. The main form (ClientID, ClientName, ClientCode, Manager) has a subform which shows all current o/s debts for that client (this sf is populated from an...