Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 235
Search took 0.61 seconds.
Search: Posts Made By: fibayne
Forum: Modules & VBA 01-13-2018, 11:26 AM
Replies: 12
Views: 553
Posted By fibayne
Re: Adding parameter to query used to open reports

thank you :)
will try that now, the Policy No field is a text field, there are many policies with letters and numbers.
thanks again will post my results !!!
Forum: Modules & VBA 01-13-2018, 10:29 AM
Replies: 12
Views: 553
Posted By fibayne
Re: Adding parameter to query used to open reports

Hi
The code needs to run a batch of individual PDF's reports per policy number, the original code I posted worked fine apart from, to change the set of policies I wanted to run I had to go into the...
Forum: Modules & VBA 01-13-2018, 08:46 AM
Replies: 12
Views: 553
Posted By fibayne
Re: Adding parameter to query used to open reports

Hi ridders

Thank you for replying, it is failing here when I run the report

strSQL = strSQL & " WHERE [Policy No] BETWEEN '" & Me.[Policy No] & "' AND '" & Me.[Policy No] & "'"

with error...
Forum: Modules & VBA 01-13-2018, 05:55 AM
Replies: 12
Views: 553
Posted By fibayne
Re: Adding parameter to query used to open reports

Hi
Thanks for your replies, I think your suggestion Gasman is what would work, can you help with what is wrong on the code below ?

I have this criteria on the [Policy No] field on the query...
Forum: Modules & VBA 01-05-2018, 02:39 AM
Replies: 12
Views: 553
Posted By fibayne
Re: Adding parameter to query used to open reports

Hi many thanks for replying, my thoughts were to run batches of the individual reports using a parameter, the user would enter Policy number from and Policy number to, which would pick up the data...
Forum: Modules & VBA 01-03-2018, 04:41 AM
Replies: 12
Views: 553
Posted By fibayne
Adding parameter to query used to open reports

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...
Forum: Modules & VBA 12-03-2016, 09:12 AM
Replies: 1
Views: 1,942
Posted By fibayne
Button to PDF & save report to Desktop with a file name

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...
Forum: Modules & VBA 08-31-2016, 05:22 AM
Replies: 7
Views: 427
Posted By fibayne
Re: Loop through tblClient & tblValuation to produce report

Hi Minty ...many thanks for your reply and the link, I have added the Public Function SendOutlookEmail, below the rest of the code, could you help me with where to place the code to call the...
Forum: Modules & VBA 08-31-2016, 02:40 AM
Replies: 7
Views: 427
Posted By fibayne
Re: Loop through tblClient & tblValuation to produce report

Private Sub Report_Click()

Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim MyFileName As String
Dim mypath As String
Dim temp As String


mypath =...
Forum: Modules & VBA 08-31-2016, 02:39 AM
Replies: 7
Views: 427
Posted By fibayne
Re: Loop through tblClient & tblValuation to produce report

Hi
The code below was on a related thread and it seems to be working for my scenario in that it creates a batch of PDF'd reports (valuations) one for each client on the database and stores them on...
Forum: Modules & VBA 08-29-2016, 11:51 PM
Replies: 7
Views: 427
Posted By fibayne
Re: Loop through tblClient & tblValuation to produce report

Hi
so10070 on the report I want to see the client name and portfolio number form tblClients eand a list of the funds cash accounts allocated to his portfolio from tblValuationData these tables are...
Forum: Modules & VBA 08-26-2016, 05:44 AM
Replies: 7
Views: 427
Posted By fibayne
Loop through tblClient & tblValuation to produce report

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...
Forum: Queries 04-10-2016, 12:30 PM
Replies: 4
Views: 327
Posted By fibayne
Re: Rate Function

Hi Paul
the error I get is #Func! ...this function works fine in excel and has the same format/required fields

=RATE(nper,pmt,pv,fv,type,guess)
nper is number of periods of the loan, pmt is...
Forum: Queries 04-09-2016, 01:08 PM
Replies: 4
Views: 327
Posted By fibayne
Rate Function

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,...
Forum: Sample Databases 03-29-2016, 12:23 AM
Replies: 5
Views: 8,044
Posted By fibayne
Re: Loan Calculator

Hi contractor, I am trying to create a loan administration database which will record when payments have been made and actual balance left on each loan, and am using your payment calculator (many...
Forum: Forms 05-19-2014, 02:27 AM
Replies: 4
Views: 757
Posted By fibayne
Re: Search unbound subform records

hi ..thanks for your reply JHB I have found some code that does the searches I need rather than using the embedded Macro and also there are no problems with the search being carried out on a...
Forum: Forms 05-17-2014, 07:02 AM
Replies: 4
Views: 757
Posted By fibayne
Re: Search unbound subform records

Hi..I tried to use the Navigation Form that comes with Access 2010 but found it problematic so have tried to make something similar by placing the 5 subforms, these contain lists of records eg...
Forum: Forms 05-16-2014, 06:20 AM
Replies: 4
Views: 757
Posted By fibayne
Search unbound subform records

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...
Forum: Forms 02-16-2014, 12:21 PM
Replies: 7
Views: 2,780
Posted By fibayne
Re: disable / lock fields on form & subform based on checkbox

If you wouldn't mind letting me know how to do that ? otherwise thanks again for your help Fi
Forum: Forms 02-16-2014, 04:01 AM
Replies: 7
Views: 2,780
Posted By fibayne
Re: disable / lock fields on form & subform based on checkbox

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 =...
Forum: Forms 02-15-2014, 02:56 PM
Replies: 7
Views: 2,780
Posted By fibayne
disable / lock fields on form & subform based on checkbox

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
...
Forum: Forms 01-03-2014, 07:45 AM
Replies: 5
Views: 7,818
Posted By fibayne
Re: Show/Hide a field based on another field

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...
Forum: Modules & VBA 10-06-2013, 01:05 PM
Replies: 10
Views: 1,297
Posted By fibayne
Re: Calculations using previous record calculation

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
Forum: Modules & VBA 10-06-2013, 10:20 AM
Replies: 10
Views: 1,297
Posted By fibayne
Re: Calculations using previous record calculation

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...
Forum: Modules & VBA 10-06-2013, 05:57 AM
Replies: 10
Views: 1,297
Posted By fibayne
Re: Calculations using previous record calculation

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?...
Showing results 1 to 25 of 235

 
Forum Jump



All times are GMT -8. The time now is 11:55 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World